List of reports
The following table lists the reports defined in the monitoring template in alphabetical order.
Table 4-2 TableList of reports
Report name | Displayed information | Storage location |
---|---|---|
Blocked Sessions | Information related to sessions that are waiting for lock release by other sessions | Reports/RM SQLServer/Troubleshooting/Real-Time/ |
Blocking Locks | Information related to sessions that have locks that are blocking other sessions | Reports/RM SQLServer/Troubleshooting/Real-Time/ |
Cache Usage | Cache statistics information for I/O buffers on a minute-by-minute basis over the past hour | Reports/RM SQLServer/Troubleshooting/Recent Past/ |
Cache Usage Trend(Multi-Agent)(historical report past 24 hours) | Cache statistics information for I/O buffers on an hour-by-hour basis over the past 24 hours | Reports/RM SQLServer/Status Reporting/Daily Trend/ |
Cache Usage Trend(Multi-Agent) (historical report past month) | Cache statistics information for I/O buffers on a day-by-day basis over the past month | Reports/RM SQLServer/Monthly Trend/ |
CPU Usage - Top 10 Sessions | Information related to the top 10 sessions that are currently using the largest numbers of CPU cycles | Reports/RM SQLServer/Troubleshooting/Real-Time/ |
Database Detail | Detailed information related to a particular database in Microsoft SQL Server | Reports/RM SQLServer/Troubleshooting/Real-Time/Drilldown Only/ |
Database Space Usage | Information related to space usage in each database in Microsoft SQL Server | Reports/RM SQLServer/Status Reporting/Real-Time/ |
Database Space Usage Detail | Detailed information related to space usage in each database in Microsoft SQL Server | Reports/RM SQLServer/Status Reporting/Real-Time/Drilldown Only/ |
Database Summary | Detailed information related to the statuses of all databases in Microsoft SQL Server | Reports/RM SQLServer/Troubleshooting/Real-Time/ |
Lock Detail | Detailed information related to each lock | Reports/SQL/Troubleshooting/Real-Time/Drilldown Only/ |
Lock Overview | Overview of locks in the entire instance (total number of database locks being maintained) | Reports/SQL/Troubleshooting/Real-Time/ |
Lock Overview by Lock Type | Overview of locks in the entire instance (total numbers of database locks being maintained by lock type) | Reports/RM SQLServer/Troubleshooting/Real-Time/ |
Lock Usage - Top 10 Sessions | Information related to the top 10 sessions that currently have the largest numbers of locks on database objects | Reports/RM SQLServer/Troubleshooting/Real-Time/ |
Log I/O Activity | Statistics information related to log entries by server on a minute-by-minute basis over the past hour | Reports/RM SQLServer/Troubleshooting/Recent Past/ |
Log Space Usage - Top 10 Databases | Information related to the top 10 databases that are currently consuming the largest amounts of log space | Reports/RM SQLServer/Troubleshooting/Real-Time/ |
Memory Usage - Top 10 Sessions | Information related to the top 10 sessions that are currently using the largest amounts of memory | Reports/RM SQLServer/Troubleshooting/Real-Time/ |
Network Activity | Statistics information related to network activities on a minute-by-minute basis over the past hour | Reports/RM SQLServer/Troubleshooting/Recent Past/ |
Network Activity Trend(historical report past 24 hours) | Statistics information related to network activities on an hour-by hour basis over the past 24 hours | Reports/RM SQLServer/Status Reporting/Daily Trend/ |
Network Activity Trend(historical report past month) | Statistics information related to network activities on a day-by-day basis over the past month | Reports/RM SQLServer/Monthly Trend/ |
Pending I/O | This report is reserved and cannot be used. | Reports/RM SQLServer/Troubleshooting/Recent Past/ |
Physical I/O - Top 10 Sessions | Information related to the top 10 sessions that are currently executing the largest number of disk read/write operations | Reports/RM SQLServer/Troubleshooting/Real-Time/ |
Physical Write Activity | Statistics information related to write activities on a minute-by-minute basis over the past hour | Reports/RM SQLServer/Troubleshooting/Recent Past/ |
Server Configuration Status | Information related to environment setting parameter values for Microsoft SQL Server | Reports/RM SQLServer/Status Reporting/Real-Time/ |
Server CPU Trend(historical report past 24 hours) | Statistics information on CPU usage on an hour-by-hour basis over the past 24 hours | Reports/RM SQLServer/Status Reporting/Daily Trend/ |
Server CPU Trend(historical report past month) | Statistics information on CPU usage on a day-by-day basis over the past month | Reports/RM SQLServer/Monthly Trend/ |
Server Space Trend(Multi-Agent)(historical report past 24 hours) | Statistics information on available space on an hour-by-hour basis over the past 24 hours | Reports/RM SQLServer/Status Reporting/Daily Trend/ |
Server Space Trend(Multi-Agent)(historical report past month) | Statistics information on available space on a day-by-day basis over the past month | Reports/RM SQLServer/Monthly Trend/ |
Server Space Usage | Statistics information related to the overall space usage in Microsoft SQL Server | Reports/RM SQLServer/Status Reporting/Real-Time/ |
Session Detail | Detailed information related to resource usage in each session | Reports/RM SQLServer/Troubleshooting/Real-Time/Drilldown Only/ |
Sessions | Information related to the statuses of all processes connected to Microsoft SQL Server | Reports/RM SQLServer/Troubleshooting/Real-Time/ |
System Overview | Detailed information related to Microsoft SQL Server | Reports/RM SQLServer/Status Reporting/Real-Time/ |