Session Detail (6.0)
- Organization of this page
Overview
The Session Detail (6.0) 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 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 |
|
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 |
Logon name of the user who issued the command |
Drilldown reports (field level)
Report name |
Description |
---|---|
Blocked Sessions (6.0) |
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 (6.0) |
Displays detailed information related to a particular database on Microsoft SQL Server. To display this report, click the DB Name field. |
Lock Detail (6.0) |
Displays detailed information related to each lock. To display this report, click the Blocking Process field. |