Versions Compared

Key

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

...

The Query Monitor is a standard SQL Server SQL Server trace that collects events occurring on your SQL Server SQL Server instance over a period of timewhile.

Note

Enabling the Query Monitor can cause SQL Server performance degradation while it runs. Enable the Query Monitor only when diagnosing specific query issues.

...

You can open the Add Servers wizard from the SQL Diagnostic Manager Console menu by selecting Image Removed > Manage Servers, and selecting Image Added > Manage Servers and clicking Add in the Manage Servers window.

...

Choosing the appropriate interval depends on your specific monitoring needs. When your SQL Server SQL Server instance performs poorly, you can decrease the collection interval so that you can track changes more often. When monitoring a SQL Server SQL Server instance that has with a very heavy client load and a large number of databases, you can increase the time period between collections to reduce the possibility of the frequent collections causing a performance impact on your clients.

...

Query Monitor includes advanced options that allow you to filter applications, databases, and SQL text SQL text from collectioncollections. Use semicolons (;)  to to separate multiple entries. You can also use the percent character (%) as a wildcard.

...