Versions Compared

Key

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

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.

Note
titleQuery Store

Query Store is now an option for query plan collection and monitoring. Query Store must be enabled on the monitored instance, along with Query Monitor and Query Waits.

Tip

SQL Diagnostic Manager does not change Query Store selections at this time. Try the

Newtab2
aliasIDERA SQL Query Store Optimizer
urlhttps://www.idera.com/productssolutions/freetools/sql-query-store-optimizer
for more on Query Store improvements

Image Added

The Wait Monitoring tab of the Monitored SQL Server Properties window allows you to configure how SQL Diagnostic Manager collects wait statistics.

...