SQL Diagnostic Manager includes built-in reports that are specially designed to generate commonly-requested metrics reports using the SQL Server data collected in the repository.
In the Next.wizard check the box for each report you want to deploy to a Microsoft Reporting Services Server, then click
You can generate reports from the following report categories:
Server Monitoring Reports
View the health of your SQL Servers.
View the health details of a single SQL Server.
View the active alerts for all monitored SQL Servers.
View the health of your mirrored databases.
View all metric thresholds for a server.
Availability Group Topology
View the current topology of your availability groups configuration.
Virtualization Monitoring Reports
View a summary of your virtualized environment.
Analyze the performance trends of your virtual machines.
Activity Monitoring Reports
Change Log Summary
View a summary of all key actions performed in your SQLdm configuration.
Server Analysis Reports
Identify your worst performing SQL Servers.
Analyze and compare performance trends across two SQL Servers.
Find SQL Servers that share the same properties.
Identify your worst performing queries.
Find queries that are performing poorly or executing frequently.
Analyze the alert history for your SQL Servers.
|Baseline Statistics||Analyze and compare performance baselines across two SQL Server instances.|
Database Analysis Reports
Identify your worst performing databases.
Analyze and compare performance trends across two databases.
Top Database Applications
Find database applications that consume system resources.
Analyze the event history for a mirrored database.
Top Tables by Growth
Identify the fastest growing tables.
|Top Tables by Fragmentation||Identify the most fragmented tables.|
Analyze the performance trends of your tempdb database.
Transaction Log Statistics
Analyze the database transaction log.
Availability Group Statistics
View the historical health of your availability groups, availability replicas, and availability databases. Plus view additional information through the Availability Group Database Statistics sub-report.
Resource Analysis Reports
Track key session and network performance metrics over time.
Track key CPU performance metrics.
Track key disk metrics for server.
Track key disk performance metrics.
Track key replication performance metrics.
Track key memory performance metrics.