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
Use the Top Servers report to identify your worst performing SQL Servers.
Use the Server Statistics report to analyze and compare performance trends across two SQL Servers.
Use the Server Inventory report to find SQL Servers that share the same properties.
Use the Query Overview report to identify your worst performing queries.
Use the Top Queries report to find queries that are performing poorly or executing too frequently.
Use the Alert History report to analyze the alert history for a SQL Server.
Use the Baseline Statistics report to review and compare metric and baseline values across two SQL Server instances.
Database Analysis Reports
Use the Top Databases report to identify your worst performing databases.
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.
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.
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
Use the Session Statistics report to track key session and network performance metrics over time.
Use the CPU Statistics report to track key CPU performance metrics.
Use the Disk Details report to track key disk metrics.
Disk Space Usage
Use the report to obtain an overview of the available disk space across your SQL Server environment.
Disk Space History
Use the report to view the history of activity for a specific disk.
Use th report to track key disk performance metrics.
Use the Replication Statistics report to track key replication performance metrics.
Use the Memory Statistics report to track key memory performance metrics.