List of reports

Job Management Partner 1 Version 10, Job Management Partner 1/Performance Management - Remote Monitor for Microsoft(R) SQL Server Description, User's Guide and Reference

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/