Page History
Query Monitor is a useful SQL Server tool that allows you to log and analyze queries. Query Monitor allows you to establish criteria for the queries you wish to capture, and filter those results to analyze the queries returned. Use the Query Monitor when diagnosing poor query performance on your SQL Server instance. You should monitor queries if your SQL Server instance performance is poor, as a way to diagnose potential query issues.
| Tip |
|---|
To explore query data in multiple ways and get a handle on queries in your system, try our New advanced query views of the SQL Diagnostic Manager web console. |
...
Access the Queries tab by clicking the appropriate monitored SQL Server instance , and then clicking the Queries tab.
...
| Info |
|---|
Query names are not persistent. The names They are different on different desktops and in different sessions on the same desktop. |
...
All queries are presented exactly as they are collected by the Query Monitor Trace collects them.
Use Filter Settings to customize your view
...
You can access advanced filters by clicking the Filter button. These options include the ability to filter out specific applications, databases, and SQL text from your query collection.
...