Introduction to SQL Workload Analysis

SQL Workload Analysis identifies where SQL Server issues exist. Then, drill down into periods of latency. This way, correlate all of the contributing factors to establish the root cause. Immediately know what databases are processing, drill into SQL statements, and receive actionable advice. SQL Workload Analysis is an add-on to SQL Diagnostic Manager and a component of the IDERA Dashboard.

Read this solution brief to learn how to explore top monitored instances, focus on problematic occurrences, explore top locked objects, explore top logins, explore top SQL statements, explore top programs, and customize the layout.

Topics: Database Performance, Database Diagnostics, Database Monitoring, SQL Query Performance
Products: SQL Workload Analysis