Page History
...
| Tip |
|---|
If you want to prevent certain queries from appearing on the Query Monitor views, click Configure Query Monitor > Advanced and enter the applications, databases, or SQL text you want to exclude from the Query Monitor collection. You can also configure these options directly in the SQL Diagnostic Manager web console. |
The Query Monitor Signature Mode view is the place to start when investigating query performance. It broadly defines queries and trends with a less overwhelming amount of data and allows you to diagnose a query in a general sense. Once you identify a potential problem, you may want to view the statement mode view to see why a query is experiencing performance problems for a particular user, and then to the query history to see how the query performs over time and the associated trends.
...
| Scroll pdf ignore |
|---|
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > > |