Physical I/O - Top 10 Sessions

Overview

The Physical I/O - Top 10 Sessions report displays information related to the top 10 sessions that are currently executing the largest number of disk read/write operations. This report is displayed as a bar graph. From the displayed report, you can display more detailed drilldown reports.

Storage location

Reports/RM SQLServer/Troubleshooting/Real-Time/

Record

Process Detail (PD_PDET)

Fields

Field nameDescription
Physical I/OCumulative number of times the process executed read/write operations to disks
ProgramApplication program name

Drilldown reports (field level)

Report nameDescription
Session DetailDisplays detailed information related to resource usage by each session. To display this report, click the Physical I/O field.