Analysis reports provide information that allows you to analyze the current effectiveness of your SQL Servers. Click the links below for more information.
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.
Use the Top Servers report to identify your worst performing SQL Servers.
Use the Server Uptime report to review the uptime and downtime of your monitored SQL Server.
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 re port 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.
Use the Query Wait Statistics report to analyze different wait type categories on your SQL Server instance.
Use the Top Databases report to identify your worst performing databases.
Use the Database Statistics r eport to analyze and compare performance trends across two databases.
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.
Use the Top Tables by Growth report to identify the fastest growing tables.
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.
Use the Transaction Log Statistics report to analyze the use of your log files.
Use the Availability Group Statistics report to view the historical health of your availability groups, availability replicas, and availability databases.
Use the Session Statistics report to track key session and network performance metrics over time.
The Detailed Session report provides detailed session information on your selected SQL Server instance.
Use the CPU Statistics report to track key CPU performance metrics.
Use the Disk Details report to track key disk metrics.
Use the Disk Space Usage report to obtain an overview of the available disk space across your SQL Server environment.
Use the Disk Space History report to view the history of activity for a specific disk.
Use the Disk Statistics 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.
| | | | | | | |