Hitachi

JP1 Version 12 JP1/Performance Management - Agent Option for Microsoft(R) SQL Server


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

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

Reports/SQL/Troubleshooting/Real-Time/

Blocking Locks (8.0)

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

Reports/SQL/Troubleshooting/Real-Time/

Cache Usage (8.0)

Cache statistics information for I/O buffers on a minute-by-minute basis over the past hour

Reports/SQL/Troubleshooting/Recent Past/

Cache Usage Trend(Multi-Agent) (8.0)

Cache statistics information for I/O buffers on an hour-by-hour basis over the past 24 hours

Reports/SQL/Status Reporting/Daily Trend/

Cache Usage Trend(Multi-Agent) (8.0)

Cache statistics information for I/O buffers on a day-by-day basis over the past month

Reports/SQL/Monthly Trend/

CPU Usage - Top 10 Sessions (8.0)

Information related to the top 10 sessions that are currently using the largest numbers of CPU cycles

Reports/SQL/Troubleshooting/Real-Time/

Database Detail (8.0)

Detailed information related to a particular database in Microsoft SQL Server

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

Database Space Usage (9.0)

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

Reports/SQL/Status Reporting/Real-Time/

Database Space Usage Detail (9.0)

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

Reports/SQL/Status Reporting/Real-Time/Drilldown Only/

Database Summary (8.0)

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

Reports/SQL/Troubleshooting/Real-Time/

Errorlog Detail

Actual error messages recorded in the Microsoft SQL Server error log file

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

Errorlog Overview

Overview of all errors that occurred in Microsoft SQL Server in the last interval

Reports/SQL/Troubleshooting/Real-Time/

Lock Detail (8.0)

Detailed information related to each lock

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

Lock Overview (8.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/SQL/Troubleshooting/Real-Time/

Lock Usage - Top 10 Sessions (8.0)

Information related to the top 10 sessions that currently have the largest numbers of locks on database objects

Reports/SQL/Troubleshooting/Real-Time/

Log I/O Activity (8.0)

Statistics information related to log entries by server on a minute-by-minute basis over the past hour

Reports/SQL/Troubleshooting/Recent Past/

Log I/O Activity 2 (8.0)

Statistics related to log entries created by the server for each minute over the past hour

Reports/SQL/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/SQL/Troubleshooting/Real-Time/

Memory Usage - Top 10 Sessions (8.0)

Information related to the top 10 sessions that are currently using the largest amounts of memory

Reports/SQL/Troubleshooting/Real-Time/

Network Activity

Statistics information related to network activities on a minute-by-minute basis over the past hour

Reports/SQL/Troubleshooting/Recent Past/

Network Activity Trend

Statistics information related to network activities on an hour-by hour basis over the past 24 hours

Reports/SQL/Status Reporting/Daily Trend/

Network Activity Trend

Statistics information related to network activities on a day-by-day basis over the past month

Reports/SQL/Monthly Trend/

Pending I/O (8.0)

This report is reserved and cannot be used.

Reports/SQL/Troubleshooting/Recent Past/

Physical I/O - Top 10 Sessions (8.0)

Information related to the top 10 sessions that are currently executing the largest number of disk read/write operations

Reports/SQL/Troubleshooting/Real-Time/

Physical Write Activity (8.0)

Statistics information related to write activities on a minute-by-minute basis over the past hour

Reports/SQL/Troubleshooting/Recent Past/

Physical Write Activity 2 (8.0)

Statistics related to write activities for each minute over the past hour

Reports/SQL/Troubleshooting/Recent Past/

Server Configuration Status

Information related to environment setting parameter values for Microsoft SQL Server

Reports/SQL/Status Reporting/Real-Time/

Server CPU Trend

Statistics information on CPU usage on an hour-by-hour basis over the past 24 hours

This report cannot display correct value.

Reports/SQL/Status Reporting/Daily Trend/

Server CPU Trend

Statistics information on CPU usage on a day-by-day basis over the past month

This report cannot display correct value.

Reports/SQL/Monthly Trend/

Server Space Trend(Multi-Agent)

Statistics information on available space on an hour-by-hour basis over the past 24 hours

Reports/SQL/Status Reporting/Daily Trend/

Server Space Trend(Multi-Agent)

Statistics information on available space on a day-by-day basis over the past month

Reports/SQL/Monthly Trend/

Server Space Usage (9.0)

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

Reports/SQL/Status Reporting/Real-Time/

Session Detail (8.0)

Detailed information related to resource usage in each session

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

Sessions (8.0)

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

Reports/SQL/Troubleshooting/Real-Time/

System Overview (9.0)

Detailed information related to Microsoft SQL Server

Reports/SQL/Status Reporting/Real-Time/