List of reports

The following table lists the reports defined in the monitoring template in alphabetical order.

Table 4-2 TableList of reports

Report nameDisplayed informationStorage location
Blocked SessionsInformation related to sessions that are waiting for lock release by other sessionsReports/RM SQLServer/Troubleshooting/Real-Time/
Blocking LocksInformation related to sessions that have locks that are blocking other sessionsReports/RM SQLServer/Troubleshooting/Real-Time/
Cache UsageCache statistics information for I/O buffers on a minute-by-minute basis over the past hourReports/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 hoursReports/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 monthReports/RM SQLServer/Monthly Trend/
CPU Usage - Top 10 SessionsInformation related to the top 10 sessions that are currently using the largest numbers of CPU cyclesReports/RM SQLServer/Troubleshooting/Real-Time/
Database DetailDetailed information related to a particular database in Microsoft SQL ServerReports/RM SQLServer/Troubleshooting/Real-Time/Drilldown Only/
Database Space UsageInformation related to space usage in each database in Microsoft SQL ServerReports/RM SQLServer/Status Reporting/Real-Time/
Database Space Usage DetailDetailed information related to space usage in each database in Microsoft SQL ServerReports/RM SQLServer/Status Reporting/Real-Time/Drilldown Only/
Database SummaryDetailed information related to the statuses of all databases in Microsoft SQL ServerReports/RM SQLServer/Troubleshooting/Real-Time/
Lock DetailDetailed information related to each lockReports/SQL/Troubleshooting/Real-Time/Drilldown Only/
Lock OverviewOverview of locks in the entire instance (total number of database locks being maintained)Reports/SQL/Troubleshooting/Real-Time/
Lock Overview by Lock TypeOverview 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 SessionsInformation related to the top 10 sessions that currently have the largest numbers of locks on database objectsReports/RM SQLServer/Troubleshooting/Real-Time/
Log I/O ActivityStatistics information related to log entries by server on a minute-by-minute basis over the past hourReports/RM SQLServer/Troubleshooting/Recent Past/
Log Space Usage - Top 10 DatabasesInformation related to the top 10 databases that are currently consuming the largest amounts of log spaceReports/RM SQLServer/Troubleshooting/Real-Time/
Memory Usage - Top 10 SessionsInformation related to the top 10 sessions that are currently using the largest amounts of memoryReports/RM SQLServer/Troubleshooting/Real-Time/
Network ActivityStatistics information related to network activities on a minute-by-minute basis over the past hourReports/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 hoursReports/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 monthReports/RM SQLServer/Monthly Trend/
Pending I/OThis report is reserved and cannot be used.Reports/RM SQLServer/Troubleshooting/Recent Past/
Physical I/O - Top 10 SessionsInformation related to the top 10 sessions that are currently executing the largest number of disk read/write operationsReports/RM SQLServer/Troubleshooting/Real-Time/
Physical Write ActivityStatistics information related to write activities on a minute-by-minute basis over the past hourReports/RM SQLServer/Troubleshooting/Recent Past/
Server Configuration StatusInformation related to environment setting parameter values for Microsoft SQL ServerReports/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 hoursReports/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 monthReports/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 hoursReports/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 monthReports/RM SQLServer/Monthly Trend/
Server Space UsageStatistics information related to the overall space usage in Microsoft SQL ServerReports/RM SQLServer/Status Reporting/Real-Time/
Session DetailDetailed information related to resource usage in each sessionReports/RM SQLServer/Troubleshooting/Real-Time/Drilldown Only/
SessionsInformation related to the statuses of all processes connected to Microsoft SQL ServerReports/RM SQLServer/Troubleshooting/Real-Time/
System OverviewDetailed information related to Microsoft SQL ServerReports/RM SQLServer/Status Reporting/Real-Time/