Hitachi

JP1 Version 12 JP1/Performance Management - Agent Option for Microsoft(R) SQL Server


CPU Usage - Top 10 Sessions (8.0)

Organization of this page

Overview

The CPU Usage - Top 10 Sessions (8.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/SQL/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 (8.0)

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