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.

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

Process Detail (PD_PDET)

Field name	Description
Blocked Processes	Number of processes blocked by the process
Blocking Process	Process ID of a blocking process, if any
Command	Name 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 Name	Name of the database being used by the process at the time of record acquisition
DBID	Database ID being used by the process at the time of record acquisition
GID	This field is reserved and cannot be used.
Host	Host computer name
Host PID	Host process ID
Locks	Number of locks being requested by the process at the time of record acquisition
Mem Usage	Number of procedure cache pages allocated to the process (1 page equals 8 kilobytes)
Physical I/O	Cumulative number of times the process executed read/write operations to disks
Program	Application program name
SPID	Process ID
Status	Process status
UID	User ID of the user who executed the command
User	Logon name of the user who issued the command

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