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.

DeadlockView 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 StatisticsAnalyze and compare performance baselines across two SQL Server instances.
Query Wait StatisticsAnalyze 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 FragmentationIdentify 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 UsageTrack the most recent snapshot of available disk space.
Disk Space HistoryTrack the history of activity for your disk.

Plan Reports

Report NameDescription
Disk Space UsagePredicts how much disk space may be needed in the future based on current and historical growth rate trends
Database GrowthPredicts how large selected databases may grow based on current and historical growth rate trends.
Table GrowthPredicts how large selected tables may grow based on current and historical growth rate trends.



IDERAProductsPurchase | Support | Community | Resources | About Us | Legal