CPU Usage - Top 10 Sessions

Overview

The CPU Usage - Top 10 Sessions report displays information related to the top 10 sessions that are currently using the largest numbers of CPU cycles. 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
CommandName of the command being executed
CPU %CPU time being used by the process as a percentage of the CPU time being used by all database processes
Physical I/OCumulative number of times the process executed read/write operations to disks
ProgramApplication program name
SPIDProcess ID
UserLogon name of the user who issued the command

Drilldown reports (field level)

Report nameDescription
Session DetailDisplays detailed information related to resource usage by each session. To display this report, click the CPU % field.