Monitor reports give you overview information for your monitored SQL Server instances and the virtual machines on which the monitored SQL Server instances are running. In addition, oversee overall activity in your SQL Diagnostic Manager environment through the Activity Monitor Reports.
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 SQLDM Console.
Server Monitor Reports
Enterprise Summary
Use the Enterprise Summary report to view the health of your SQL Servers.
Server Summary
Use the Server Summary report to view the health of a single SQL Server.
Active Alerts
Use the Active Alerts report to identify the currently active alerts for all monitored SQL Servers.
Mirroring Summary
Use the Mirroring Summary report to view the health of your mirrored databases.
Metric Thresholds
Use the Metric Thresholds report to view all metric thresholds for a SQL Server instance.
Availability Group Topology
Use the Availability Group Topology report to view the current topology of an AlwaysOn Availability Groups configuration.
Deadlock Report
The Deadlock Report lets you analyze deadlocks on your SQL Server instance. By analyzing you can better determine where deadlocks are occurring and what changes can have the greatest performance impact.
Alert Template Report
The Alert Template Report displays the list of instances with Alert Template assigned per instance.
Alert Threshold Report
The Alert Threshold Report displays all the metrics thresholds of the selected server.
Template Comparison
The Template Comparison report displays all the metrics thresholds differences between the Source and the Target Template.
Virtualization Monitor Reports
Virtualization Summary
Use the Virtualization Summary report to view a summary of your virtualized environment.
Virtualization Statistics
Use the Virtualization Statistics report to view an analysis of your virtualization performance trends for a virtualized machine.
Activity Monitor Reports
Change Log Summary
Use the Change Log Summary report to view a list of all actions and configuration changes performed in your SQL Diagnostic Manager environment over a specified period of time.