Posts
Sort by recent activity
Queries in Top Queries by Total split into separate items
What is the difference between these queries in the Top Queries section ordered by total in the Server Overview page?
The top two have executed millions of times in the selected time period and ha...
Text in Long Running Query Alert - Last statement to run?
I have a long running query alert telling me a query has run for 3675 seconds:However, when I find the query in the Server overview, I find that the query only took 67 seconds, and query store seem...
Unexpected Databases showing in tempdb version store graph
I am seeing some unexpected databases showing in the tempdb version store graph on the server overview page:We can see msdb, and some user databases I have named T1, T2, B1, B2 and B3, are all usin...
Report Access
Hi,Is is possible to grant access to just the reports page and just a given number of reports?We have some users who I would like to be able to see a report in real time (rather than just on the Em...
Email reports Per Server
I have a number of Reports set up in the reports page and have been looking at Emailing them out but I would want to send one report per production server.I set up an Email schedule and it appears ...
Create a Custom Alert from a built in metric
There are a number of metrics available in the Analysis tab. Is there a way I can create a custom alert based on these metrics?I want to create an alert for when Log Space Used % exceeds a give val...
Jump From Alert to Point in Time on Server
When I open an alert, I can click the hyperlink next to "Source" and it takes me to the server overview page for the that server, however, it displays at the current date and time. Is it possible f...
Can I get Email Alerts for an alert that is below the general Email threshold?
We have our Email notifications set to only Email on high severity items.However, I have a custom alert which when raises a Medium severity alert and would like to send an Email when that alert fir...
Retrieving Transaction Isolation levels in blocked process reports
There are two methods I have been using to understand blocking situations on our servers:
The processes tab in the Blocking Process alert
The blocking processes section in the server overview
I can...
How to Understand High CPU Utilization
One of our servers has high CPU utilization just after 6PM for around an hour:If I then look at the CPU utilization graph for the highlighted time period I see: If I look at the 100% period just af...