Session Detail

Overview

The Session Detail report displays detailed information related to resource usage in each session. This report is displayed as a list. It is a drilldown report. From the displayed drilldown report, you can display more detailed drilldown reports.

Storage location

Reports/RM SQLServer/Troubleshooting/Real-Time/Drilldown Only/

Record

Process Detail (PD_PDET)

Fields

Field nameDescription
Blocked ProcessesNumber of processes blocked by the process
Blocking ProcessProcess ID of a blocking process, if any
CommandName of the command executed
CPU %CPU time being used by the process, as a percentage of the CPU time being used by all database processes
DB NameName of the database being used by the process at the time of record acquisition
DBIDDatabase ID being used by the process at the time of record acquisition
GIDThis field is reserved and cannot be used.
HostHost computer name
Host PIDHost process ID
LocksNumber of locks being requested by the process at the time of record acquisition
Mem UsageNumber of procedure cache pages allocated to the process (1 page equals 8 kilobytes)
Physical I/OCumulative number of times the process executed read/write operations to disks
ProgramApplication program name
SPIDProcess ID
StatusProcess status
UIDUser ID of the user who executed the command
UserLogon name of the user who issued the command

Drilldown reports (field level)

Report nameDescription
Blocked SessionsDisplays the information related to sessions that are waiting for lock release by other sessions. To display this report, click the Blocked Processes field.
Database DetailDisplays detailed information related to a particular database on Microsoft SQL Server. To display this report, click the DB Name field.
Lock DetailDisplays detailed information related to each lock. To display this report, click the Blocking Process field.