Documentation forSQL Sentry

SQL Sentry Reports Menus

Accessing Reports

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

SQL Sentry Reports Menu

Events Reports

SQL Sentry Events Reports

Reports Descriptions
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

SQL Sentry 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.

Note:  On applicable reports, the Load Saved Parameters drop-down box allows the user to save the parameters for future use.

Performance 

SQL Sentry Performance Analysis Performance Reports

Reports Descriptions
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

SQL Sentry Performance Analysis Disk File Space Reports

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
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

SQL Sentry Performance Analysis Top SQL Reports

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 SQL Sentry Top SQL By User
- By Database SQL Sentry Top SQL By Database
- By Application Top SQL By Application
- By Server Top SQL By Server
- All Servers Top SQL All Servers

Blocking

SQL Sentry Performance Analysis Blocking Reports

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 SQL Sentry Blocking By Application
- By Application Matrix Blocking SQL By Application Matrix
- By User SQL Sentry Blocking By User
- By SQL Server Blocking By SQL Server
- By Wait Resource Blocking By Wait Resource
- By Wait Type Blocking By Wait Type

Deadlocks

SQL Sentry Performance Analysis Deadlocks Reports

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 SQL Sentry Deadlocks By Application
- By Application Matrix Blocking By Application
- By Resource Deadlocks By Resource
- By SQL Server Deadlocks By Server
- By User SQL Sentry Deadlocks By User

Fragmentation Manager 

SQL Sentry Performance Analysis Fragmentation Manager Reports

Reports Descriptions
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

SQL Sentry General Reports

Report Description
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 SettingsList 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.