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:

0 comments on “Wait Monitoring
1 Pings/Trackbacks for "Wait Monitoring"
  1. […] anyone who downloaded Beta 3 and set up the historic waits monitoring:  What you set up will still be active if you upgrade to Beta 3.1, just upgrade to Beta 3.1, and […]

Leave a Reply

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

*

To prove you are not a robot: *