Hitachi

JP1 Version 12 JP1/Performance Management - Remote Monitor for Microsoft(R) SQL Server Description, User's Guide and Reference


List of reports

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

Table 4‒2: :List of reports

Report name

Displayed information

Storage location

Blocked Sessions (6.0)

Information related to sessions that are waiting for lock release by other sessions

Reports/RM SQLServer/Troubleshooting/Real-Time/

Blocking Locks (6.0)

Information related to sessions that have locks that are blocking other sessions

Reports/RM SQLServer/Troubleshooting/Real-Time/

Cache Usage (6.0)

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) (6.0) (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) (6.0) (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 (6.0)

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 (6.0)

Detailed information related to a particular database in Microsoft SQL Server

Reports/RM SQLServer/Troubleshooting/Real-Time/Drilldown Only/

Database Space Usage (7.0)

Information related to space usage in each database in Microsoft SQL Server

Reports/RM SQLServer/Status Reporting/Real-Time/

Database Space Usage Detail (7.0)

Detailed information related to space usage in each database in Microsoft SQL Server

Reports/RM SQLServer/Status Reporting/Real-Time/Drilldown Only/

Database Summary (6.0)

Detailed information related to the statuses of all databases in Microsoft SQL Server

Reports/RM SQLServer/Troubleshooting/Real-Time/

Lock Detail (6.0)

Detailed information related to each lock

Reports/SQL/Troubleshooting/Real-Time/Drilldown Only/

Lock Overview (6.0)

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 (6.0)

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 (6.0)

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 (6.0)

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 (6.0)

This report is reserved and cannot be used.

Reports/RM SQLServer/Troubleshooting/Recent Past/

Physical I/O - Top 10 Sessions (6.0)

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 (6.0)

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

This report cannot display correct value.

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

This report cannot display correct value.

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 (7.0)

Statistics information related to the overall space usage in Microsoft SQL Server

Reports/RM SQLServer/Status Reporting/Real-Time/

Session Detail (6.0)

Detailed information related to resource usage in each session

Reports/RM SQLServer/Troubleshooting/Real-Time/Drilldown Only/

Sessions (6.0)

Information related to the statuses of all processes connected to Microsoft SQL Server

Reports/RM SQLServer/Troubleshooting/Real-Time/

System Overview (7.0)

Detailed information related to Microsoft SQL Server

Reports/RM SQLServer/Status Reporting/Real-Time/