Hitachi

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


Cache Usage (6.0)

Organization of this page

Overview

The Cache Usage (6.0) report displays cache statistics information for I/O buffers on a minute-by-minute basis over the past hour. The information is displayed as a line graph. From the displayed report, you can display more detailed drilldown reports.

Storage location

Reports/RM SQLServer/Troubleshooting/Recent Past/

Record

Server Overview (PI_SERV)

Field

Field name

Description

Cache Hit %

Rate at which data pages were found inside the data cache

Drilldown reports (report level)

Report name

Description

Physical I/O - Top 10 Sessions (6.0)

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