Process Detail (PD_PDET)
Function
The Process Detail (PD_PDET) record indicates detailed information on a particular database process, such as locks and I/O. One record is created for each database process. This is a multi-instance record.
Default and changeable values
Item | Default value | Changeable |
---|---|---|
Collection Interval | 60 | Y |
Collection Offset | 0 | Y |
Log | No | Y |
LOGIF | (Blank) | Y |
ODBC key field
PD_PDET_SPID
Lifetime
From the start until stop of a process
Record size
Fields
View name (Manager name) | Description | Summary | Format | Delta | Data source |
---|---|---|---|---|---|
Blocked Processes (BLOCKING) | Number of processes blocked by the process | -- | word | No | master..sysprocesses.blocked |
Blocking Process (BLOCKED) | Process ID of a blocking process, if any | -- | word | No | master..sysprocesses.blocked |
CPU % (PERC_CPU) | CPU time being used by the process, as a percentage of the CPU time being used by all database processes | -- | double | No | master..sysprocesses.cpu |
CPU Timeticks (CPU) | Cumulative CPU time of the process (in ticks) | -- | ulong | No | master..sysprocesses.cpu |
Command (COMMAND) | Name of the command executed | -- | string(33) | No | master..sysprocesses.cmd |
DB Name (DB_NAME) | Name of the database being used by the process at the time of record acquisition | -- | string(257) | No | db_name(master..sysprocesses.dbid) |
DBID (DBID) | Database ID being used by the process at the time of record acquisition | -- | word | No | master..sysprocesses.dbid |
GID (GID) | This field is reserved and cannot be used. | -- | -- | -- | -- |
Host (HOST) | Host computer name | -- | string(257) | No | master..sysprocesses.hostname |
Host PID (HOST_PID) | Host process ID | -- | long | No | master..sysprocesses.hostprocess |
Locks (LOCKS) | Number of locks being requested by the process at the time of record acquisition | -- | long | No | master..syslockinfo.req_spid |
Mem Usage (MEMUSAGE) | Number of procedure cache pages allocated to the process (1 page equals 8 kilobytes) | -- | double | No | master..sysprocesses.memusage |
Physical I/O (PHYSICAL_IO) | Cumulative number of times the process executed read/write operations to disks | -- | double | No | master..sysprocesses.physical_io |
Program (PROGRAM) | Application program name | -- | string(257) | No | master..sysprocesses.program_name |
Record Time (RECORD_TIME) | Interval end time (GMT format) | -- | time_t | No | Remote Monitor Collector |
Record Type (INPUT_RECORD_TYPE) | Record type (always PDET) | -- | char(8) | No | Remote Monitor Collector |
SPID (SPID) | Process ID | -- | word | No | master..sysprocesses.spid |
Start Time (START_TIME) | Interval start time (GMT format) | -- | time_t | No | Remote Monitor Collector |
Status (STATUS) | Process status | -- | string(61) | No | master..sysprocesses.status |
UID (UID) | User ID of the user who executed the command | -- | word | No | master..sysprocesses.uid |
User (USER) | Logon name of the user who issued the command. If information cannot be obtained from the syslogins system table of Microsoft SQL Server, it is obtained from the sysprocesses system table. If the logon name used is 61 characters or longer, the part exceeding 61 characters is cut off. | -- | string(257) | No | master..sysprocesses.sid, master..syslogins.name or master..sysprocesses.sid, master..sysprocesses.loginame |
VA DeviceID(VADEVICEID) | Device ID of virtual agent. | -- | string(256) | No | Remote Monitor Collector |