SQL Diagnostic Manager allows you to collect and view wait statistics on the selected SQL Server instance. Wait statistics offer one of the best means in diagnosing the reason a bottleneck is occurring on your system.
The Wait Monitoring tab of the Monitored SQL Server Properties window allows you to configure how SQL Diagnostic Manager collects wait statistics.
- View, start, stop, and refresh the query-level wait collector.
- Collect query-level wait statistics historically and set the time to collect them.
Overly complex filters of SQL Text using Extended Events can cause high loads on the monitored instance due to a known Microsoft defect.
When to use wait monitoring
Wait Monitoring helps you diagnose congestion or blocks on your system. You should enable Wait Monitoring for the time period required to diagnose specific issues you experience. When your diagnosis is complete, disable Wait Monitoring.
Access the Wait Monitoring tab
You can access the Wait Monitoring tab of the Monitor SQL Server Properties window by right-clicking the appropriate monitored SQL Server instance, and then selecting Properties. Click Wait Monitoring when SQL Diagnostic Manager displays the Monitored SQL Server Properties window.