Page History
...
You can access the Query Monitor tab of the Monitored SQL Server Properties window by right-clicking the appropriate SQL Server instance, and then selecting Properties. Click Query Monitor when SQLdm SQL Diagnostic Manager displays the Monitored SQL Server Properties window.
...
Select the events that help you best diagnose the specific issues occurring with query performance on your SQL Server instance. For example, you may want to monitor queries taking a long time to complete, requiring heavy CPU usage, and causing a large number of logical disk reads or physical disk writes, which indicates a memory issue.
SQLdm SQL Diagnostic Manager uses tracing to locate and flag worst-performing T-SQL. SQLdm SQL Diagnostic Manager cannot display binary data in a readable format. If you captured DTS packages, you may see unreadable characters in the Command field of the Tree View. Capturing DTS data may also adversely affect the performance of the SQL Server or Data Warehouse you are monitoring.
...
| Info |
|---|
You can also configure these options directly from the new advanced query views in the SQLdm SQL Diagnostic Manager web console. |
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >