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.
Select reports
In the Reports Deployment wizard check the box for each report you want to deploy to a Microsoft Reporting Services Server, then click Next.
Available Reports
You can generate reports from the following report categories:
Server Monitoring Reports
Report Name | Description |
|---|---|
Enterprise Summary | View the health of your SQL Servers. |
Server Summary | View the health details of a single SQL Server. |
Active Alerts | View the active alerts for all monitored SQL Servers. |
Mirroring Summary | View the health of your mirrored databases. |
Metric Thresholds | View all metric thresholds for a server. |
Availability Group Topology | View the current topology of your availability groups configuration. |
| Deadlock | View the deadlock trends across SQL Server database. |
Virtualization Monitoring Reports
Report Name | Description |
|---|---|
Virtualization Summary | View a summary of your virtualized environment. |
Virtualization Statistics | Analyze the performance trends of your virtual machines. |
Activity Monitoring Reports
Report Name | Description |
|---|---|
Change Log Summary | View a summary of all key actions performed in your SQLDM configuration. |
Server Analysis Reports
Report Name | Description |
|---|---|
Top Servers | Identify your worst performing SQL Servers. |
Server Statistics | Analyze and compare performance trends across two SQL Servers. |
Server Inventory | Find SQL Servers that share the same properties. |
Query Overview | Identify your worst performing queries. |
Top Queries | Find queries that are performing poorly or executing frequently. |
Alert History | Analyze the alert history for your SQL Servers. |
| Baseline Statistics | Analyze and compare performance baselines across two SQL Server instances. |
| Query Wait Statistics | Analyze different wait type categories on your SQL Server instance. |
Database Analysis Reports
Report Name | Description |
|---|---|
Top Databases | Identify your worst performing databases. |
Database Statistics | Analyze and compare performance trends across two databases. |
Top Database Applications | Find database applications that consume system resources. |
Mirroring History | 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. |
Tempdb Statistics | 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
Report Name | Description |
|---|---|
Session Statistics | Track key session and network performance metrics over time. |
CPU Statistics | Track key CPU performance metrics. |
Disk Details | Track key disk metrics for server. |
Disk Statistics | Track key disk performance metrics. |
Replication Statistics | Track key replication performance metrics. |
Memory Statistics | Track key memory performance metrics. |
| Disk Space Usage | Track the most recent snapshot of available disk space. |
| Disk Space History | Track the history of activity for your disk. |
Plan Reports
| Report Name | Description |
|---|---|
| Disk Space Usage | Predicts how much disk space may be needed in the future based on current and historical growth rate trends |
| Database Growth | Predicts how large selected databases may grow based on current and historical growth rate trends. |
| Table Growth | Predicts how large selected tables may grow based on current and historical growth rate trends. |