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!
SteveStedman5
SteveStedman5
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

4 Comments on “Long Running Queries

  1. 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

Leave a Reply

Your email address will not be published. Required fields are marked *

*

To prove you are not a robot: *