Activity overview
Latest activity by clivestrong
Server Upgrade and Data Retention
Hi,We are upgrading our production platform which will include new cluster names for our instances.For example, if we have a single named instance called - PRD-APP-01\EMEA, we will be creating a ne...
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 ...
Long running query is not present in the TOP 10 QUERIES list in the main panel.
I found a long running query in my alerts page which took 278 seconds starting at 15:13 yesterday. If I now zoom in on 24 hour view and look at a 15-20 minute period around the time of the alert, ...
Querying and Updating Alerts
Hi,I'm looking for a way to automatically clear certain messages from the Alerts inbox. I'd be filtering on the process full command. For example, when I click into a Long Running Query, I see a ...