Analysis reports provide information that allows you to analyze the current effectiveness of your SQL Servers. Click the links below for more information.
Access the Reports view
SQL Diagnostic Manager provides two paths to access the Reports view. The first access path is by clicking Reports in the Navigation pane. The second access path is by clicking Go > Reports. The second path is the only option if you hide your Navigation pane in the SQL Diagnostic Manager Console.
Server Analysis Reports
Top Servers
Use the Top Servers report to identify your worst performing SQL Servers.
Server Statistics
Use the Server Statistics report to analyze and compare performance trends across two SQL Servers.
Server Inventory
Use the Server Inventory report to find SQL Servers that share the same properties.
Query Overview
Use the Query Overview report to identify your worst performing queries.
Top Queries
Use the Top Queries report to find queries that are performing poorly or executing too frequently.
Alert History
Use the Alert History report to analyze the alert history for a SQL Server.
Baseline Statistics
Use the Baseline Statistics report to review and compare metric and baseline values across two SQL Server instances.
Database Analysis Reports
Top Databases
Use the Top Databases report to identify your worst performing databases.
Database Statistics
Use the Database Statistics report to analyze and compare performance trends across two databases.
Top Database Applications
Use the Top Database Applications report to find database applications that consume system resources.
Mirroring History
Use the Mirroring History report to analyze the event history for a mirrored database.
Top Tables by Growth
Use the Top Tables by Growth report to identify the fastest growing tables.
Top Tables by Fragmentation
Use the Top Tables by Fragmentation report to identify the most fragmented tables.
Tempdb Statistics
Use the Tempdb Statistics report to analyze performance statistics for your tempdb database.
Transaction Log Statistics
Use the Transaction Log Statistics report to analyze the use of your log files.
Availability Group Statistics
Use the Availability Group Statistics report to view the historical health of your availability groups, availability replicas, and availability databases.
Resource Analysis Reports
Session Statistics
Use the Session Statistics report to track key session and network performance metrics over time.
Detailed Session Report
The Detailed Session report provides detailed session information on your selected SQL Server instance.
CPU Statistics
Use the CPU Statistics report to track key CPU performance metrics.
Disk Details
Use the Disk Details report to track key disk metrics.
Disk Space Usage
Use the Disk Space Usage report to obtain an overview of the available disk space across your SQL Server environment.
Disk Space History
Use the Disk Space History report to view the history of activity for a specific disk.
Disk Statistics
Use the Disk Statistics report to track key disk performance metrics.
Replication Statistics
Use the Replication Statistics report to track key replication performance metrics.
Memory Statistics
Use the Memory Statistics report to track key memory performance metrics.