Comments
Sort by recent activity
I'll bump this question up as well, and give a little context. What I would love to be able to do is start reviewing patterns in the long-running queries so we can review them with the development team. I'd be glad to compose something within the SQL Monitor tool, so perhaps the answer is partly "create a custom metric", but I'd need some help knowing how to count "long-running queries detected for <database object>" . We know there's gobs of helpful details once we look at the alerts, but when you're pawing through many alerts, it would be great to focus on "this keeps happening" vs "this happened a lot one day, and then never again, so don't throw a bunch of time at it.". Hope that helps! / comments
I'll bump this question up as well, and give a little context. What I would love to be able to do is start reviewing patterns in the long-running queries so we can review them with the development ...