Monitor reports

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 deadlockss on your SQL Server instance. By analyzing you can better determine where deadlocks are occrring and what changes can have the greatest performance impact.

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.