Select Page

Wait Monitoring

5 Dimensions of Wait Time Drill Down

Drill down on queries causing the most wait time by the following dimensions; time, host name, login, database, and instance.  With these dimensions you can quickly find details on the query or queries causing the most waits on your SQL Server.

Waits Advisor

Once you find the problem query, use the Waits Advisor to analyze the query and figure out what needs to be done to fix it.  You don’t know what the specific wait type means, just click on it and get details and suggestions on how to improve your query.

 

Related Links:

Trackbacks/Pingbacks

  1. » Database Health Version 3.1 So Soon After Beta 3 Steve Stedman - [...] anyone who downloaded Beta 3 and set up the historic waits monitoring:  What you set up will still be…

Submit a Comment

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

To prove you are not a robot: * Time limit is exhausted. Please reload CAPTCHA.