Page History
...
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 File > Manage Servers, and then > 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.
You can access this window by clicking the Advanced button in the Query Monitor tab of the monitored SQL Server Properties window.
| Scroll pdf ignore | ||||||
|---|---|---|---|---|---|---|
Newtabfooter |
|
...
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
...
...