Long Running Queries
Find and fix long running queries from the Database Health Long Running Queries Page.
The times shown are in milliseconds.
Double click on the chart, or on any query in the grid to get the Long Running Queries Advisor.
You get to the Long Running Queries page from the Database Overview Page or from the hierarchy tree.
Download Database Health Monitor now.
Enroll Today!
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!
Contact Info
Stedman Solutions, LLC.PO Box 3175
Ferndale WA 98248
Phone: (360)610-7833
Where can i find how far back in time is the monitoring go, when i don’t have the Historic Reporting configured, is it as long as the SQL instance is running ?
If you are not using the historic reporting, then you only have access to the real-time reports. Most of those are pulling from DMVs and other locations that are reset when the instance was restarted, however they don’t all go that far back, some of them are only a “right now” view of the status.
-Steve
Hello, are they on s, ms or microseconds?
Run time is in milliseconds.