Cache Usage
Overview
The Cache Usage 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 | Displays information related to the top 10 sessions that are currently executing the largest number of disk read/write operations |