CPU Usage - Top 10 Sessions (6.0)
- Organization of this page
Overview
The CPU Usage - Top 10 Sessions (6.0) 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 name |
Description |
---|---|
Command |
Name 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/O |
Cumulative number of times the process executed read/write operations to disks |
Program |
Application program name |
SPID |
Process ID |
User |
Logon name of the user who issued the command |
Drilldown reports (field level)
Report name |
Description |
---|---|
Session Detail (6.0) |
Displays detailed information related to resource usage by each session. To display this report, click the CPU % field. |