Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • View, start, stop, and refresh the query-level wait collector.
  • Collect query-level wait statistics historically and set the time to collect them.
Warning

It exists a Microsoft known defect with SQL server that stems from an overly-complex Extended Event filter on SQL Text.

When to use wait monitoring

...

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.

...