Comments
Sort by recent activity
So many features to choose from, but I am going to opt for custom metrics. The reason for this is to enable a consistent alerting platform. It also allows us to use pre-defined pagerduty alert mechanisms with no extra effort at all. Where possible, we'll use SQL Monitor custom metrics over jobs configured in SQL Agent. / comments
So many features to choose from, but I am going to opt for custom metrics. The reason for this is to enable a consistent alerting platform. It also allows us to use pre-defined pagerduty alert me...
Hi Alex, I tried both average and total and I was sorting by Duration. I tried sorting on different columns to see if I could get the query to appear. I also tried going into the top 10 waits and looked through those to see if the offending query would surface, to no avail. The longest running query in the top 10 list was 6 seconds. Today, I can see a very slow query (known bug in our data warehouse) with an alert reporting a query taking 103 seconds. In the top 10 queries list, I can see the same query with a duration of 125,096ms. We're on version 9.1.9. Clive / comments
Hi Alex,I tried both average and total and I was sorting by Duration. I tried sorting on different columns to see if I could get the query to appear. I also tried going into the top 10 waits and ...