SQL Sentry Reports Menus

Accessing Reports

SQL Sentry offers a variety of built-in reports from the Reports menu.

Events Reports

Reports	Descriptions	Screenshots
Current Failures	The Current Failures report provides data about all failures that have occurred in the given time frame for any monitored objects in your SQL Sentry environment. The report includes various information about the associated failures including: name of the event, parent instance name, last step output, start and end times. Report parameters show either Open Failures only or All Failures. Any user notes added to the job failure instance are available on this report. Use the Current Failures report to identify object failures over the selected time frame.
Management Summary	The Management Summary report provides a high-level overview of the monitored servers in your SQL Sentry environment. The report includes a count of all monitored objects, and as applicable, the associated number of failures recorded for those objects, grouped in the following ranges: last 30 days, last 7 days, and last 24 hours. Use the Management Summary report to help you determine which servers are the most active in your  environment.
Performance Counters List	The Performance Counters List report provides data about Performance Counters currently associated with specific event objects or Custom Event Views within your SQL Sentry environment. Information about each Performance Counter is displayed for the specified time range, including the minimum, maximum, and average of the recorded metric. Use the Performance Counters List report to identify active Performance Counters in your environment.
Watched Object Summary	The Watched Object Summary report provides information about the different types of objects found on each watched instance. The report breaks down the watched and unwatched objects by instance type and event source. Counts for the number of child objects belonging to the instance that are enabled or disabled are also provided in this report. Use the Watched Object Summary report to identify the number of monitored objects on your watched instances.

Performance Analysis Reports

The Performance Analysis reports are the companion to SQL Sentry Performance Analysis. For more information about the various metrics contained in the Performance Analysis reports, see the Performance Metrics topic.

Performance 

Reports	Descriptions	Screenshots
Global Server Performance	The Global Server Performance report provides a summary of the performance metrics collected for each of the servers in your SQL Sentry environment. Use the Global Server Performance report in conjunction with the Performance Analysis Global view for a high-level understanding of server performance across your entire monitored environment.
Performance Counter Date Range Comparison	The Performance Counter Date Range Comparison report provides graphical and textual data for the selected Performance Counter(s) over the specified time range. Various parameters can be configured including: Server, Instance, Category, Counter, and Instance. This report is like the Performance Counter History report, except two different time ranges can be selected.
Performance Counter History	The Performance Counter History report provides both graphical and textual data for the selected Performance Counter(s) over the specified time range. Various parameters include: Server, Connection, Category, Counter, and Instance that can be configured.
SQL Server Performance	The SQL Server Performance report provides detailed SQL Server performance data for the instance over the selected time range.  Use the SQL Server Performance report in conjunction with the Performance Analysis dashboard to gain an understanding of SQL Server performance in your monitored environment.
SQL Server Transactions - Top Databases	The SQL Server Transactions - Top Databases report provides detailed data about transactions and log flushes for the selected instance over the specified time range. The report includes a minimum, maximum, average, and total column for each metric. The report includes the top 10 databases for the instance as determined by the total number of log flushes and transactions.
SQL Server Wait Stats Analysis	The SQL Server Wait Stats Analysis report provides detailed data about SQL Server waits for the instance over the selected time range. Several aggregate waits groupings are incorporated into the report, including waits by category, by class, and by type. Each grouping breaks down the waits data by Resource Waits, CPU Waits, and Total Waits. Metrics are displayed in milliseconds (MS).
SQL Server Wait Stats Analysis - By Resource and CPU Waits	The SQL Server Wait Stats Analysis - By Resource and CPU Waits report provides detailed data about SQL Server waits for the instance over the selected time range. Several aggregate waits groupings are incorporated into the report, including waits by category, by class (CPU or Resource), and by type (CPU or Resource). Metrics are displayed in milliseconds (MS).
SSAS Performance	The SSAS Performance report provides detailed graphical information regarding the SSAS performance for the selected instance over a given time range.
Windows + SQL Server Performance	The Windows + SQL Server Performance report provides detailed performance metrics for each instance on the selected server regarding Windows and SQL Server performance. Use the Windows + SQL Server Performance report in conjunction with the Performance Analysis dashboard to gain an insight into the performance of your monitored environment.
Windows Performance	The Windows Performance report provides detailed Windows performance data for the instance over the selected time range. Use the Windows Performance report in conjunction with the Performance Analysis dashboard to gain an understanding of Windows Performance in your monitored environment.

Disk / File Space

Use the Disk/File Space reports in conjunction with the Disk Activity and Disk Space tabs of Performance Analysis to identify data disk capacity issues and possible performance bottlenecks.

Reports	Descriptions	Screenshots
SQL Server File Growth -Top Files - All Servers	The SQL Server File Growth - Top Files - All Servers report provides data and log file growth over the selected time range for the Top N files, as selected in the report parameters, across your entire installation. There are representations for total size and used size over the selected time frame.
SQL Server File Utilization  - Top Files - By Logical Disk - By Database	The SQL Server File Utilization report provides data and log file growth over the selected time range for the Top 5 files on the specified instance. There are representations for total size and used size over the selected time frame. Each of the SQL Server File Utilization reports group the data by its respective category name.
Windows Disk Forecast	The Windows Disk Forecast report provides the amount of space you've already used and provides an example of to how to expand the volume of your disk space so that you don't run out in the future. All Servers—Displays all volumes that will run out of memory within a specified time frame.  Individual Servers—Capacity planning that provides a secondary chart with a forecasted amount of disk space.
Windows Disk Utilization - By Server	The Windows Disk Utilization -By Server report provides the amount of used and free space for the selected server over the specified time range. The report provides data for both Physical and Logical disk utilization.
Windows Disk Utilization - All Servers	The Windows Disk Utilization - All Servers report provides the disk size, used space, free space, and used space history for all the monitored servers within your SQL Sentry environment.
Misaligned Partitions  - By Server - All Servers	The Misaligned Partitions reports provides a summary of the misaligned partitions for the selected server.
High VLFs  - By Server - All Servers	The High VLFs reports provides data about transaction logs that have a high number of Virtual Log Files (VLFs).
Databases without Recent Backups	The Databases without Recent Backups report provides information about databases without a recent backup in your monitored environment. Information is included for both data and log files, including the Last Backup Time, Last Backup Type, and Used Size (MB). The default time range for this report covers the last 15 days, but is configurable. Transaction Log files aren't included in this report if the database is in simple recovery.

Top SQL

The Top SQL reports provide a summary of Top SQL data captured over the given time range. Top SQL contains high impact, worst performing stored procedures, batches, and statements. The information captured by Top SQL can be based on any combination of duration, CPU, reads, or writes. Use this data along with other metrics available in the Top SQL tab of Performance Analysis to identify and target problem areas. Each of the Top SQL reports group the Top SQL data by its respective category name.

Report	Description
- By User
- By Database
- By Application
- By Server
- All Servers

Blocking

The Blocking reports provide a summary of blocking data over the given time range. They are designed to aggregate by blocking query, blocked query, and wait resource for the selected time frame. Use this data along with other blocking-level metrics available in the Blocking SQL tab of Performance Analysis to identify and target problem areas.

Report	Description
- By Application
- By Application Matrix
- By User
- By SQL Server
- By Wait Resource
- By Wait Type

Deadlocks

The Deadlocks report provides information regarding Deadlocks in various ways over a specified time range. When used in conjunction with the Deadlocks tab in Performance Analysis, these reports can help track down problematic Deadlocks.

Report	Description
- By Application
- By Application Matrix
- By Resource
- By SQL Server
- By User

Fragmentation Manager 

Reports	Descriptions	Screenshots
Index Defragmentation Details - By Database	The Index Defragmentation Details report provides a summary of the defragmentation details for the indexes in your environment. Defragmentation metrics provided include fragmentation percentages, defrag method, fragmentation percentage post defrag, and start/end times.
Index Fragmentation And Usage	The Index Fragmentation and Usage report provides a graphical representation of the overall fragmentation, disk space usage, and buffer usage of the indexes in your environment.

General Reports

Report	Description	Screenshots
Action Counts	The Action Counts report provides a count, broken down by object and parent object, of actions that have taken place during the selected time range. This report gives you valuable information for adjusting alerts in your environment. Use the Action Counts report to quickly identify where the alerts in your environment are coming from, and then make adjustments as needed.
Active Settings List	The Active Settings List report provides details on every setting configured in your environment at all levels combined into one resource. This report gives you valuable information about how settings are effecting your configured actions and collection settings.
Configured Actions List	The Configured Actions List report provides a list on every action that's configured for a given condition, specifying at what level the action's configured.
Configured Notification List	The Configured Notification List report allows you to view all conditions that are specifically configured to send notifications by email or pager.
Downtime - By Server	The Downtime - By Server report provides a listing of all server downtime activity for the specified time range. Included in the reports are metrics such as total incidents, total downtime in seconds, average downtime per incident, uptime percentage, and first/last incident times.