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.

Note:
PFM - RM for SQL Server collects performance data of the record field size from Microsoft SQL Server. Therefore, if Microsoft SQL Server contains data that exceeds the field size of User field, the last character of the performance data might be unreadable.

Default and changeable values

ItemDefault valueChangeable
Collection Interval60Y
Collection Offset0Y
LogNoY
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)
DescriptionSummaryFormatDeltaData source
Blocked Processes
(BLOCKING)
Number of processes blocked by the process--wordNomaster..sysprocesses.blocked
Blocking Process
(BLOCKED)
Process ID of a blocking process, if any--wordNomaster..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--doubleNomaster..sysprocesses.cpu
CPU Timeticks
(CPU)
Cumulative CPU time of the process (in ticks)--ulongNomaster..sysprocesses.cpu
Command
(COMMAND)
Name of the command executed--string(33)Nomaster..sysprocesses.cmd
DB Name
(DB_NAME)
Name of the database being used by the process at the time of record acquisition--string(257)Nodb_name(master..sysprocesses.dbid)
DBID
(DBID)
Database ID being used by the process at the time of record acquisition--wordNomaster..sysprocesses.dbid
GID
(GID)
This field is reserved and cannot be used.--------
Host
(HOST)
Host computer name--string(257)Nomaster..sysprocesses.hostname
Host PID
(HOST_PID)
Host process ID--longNomaster..sysprocesses.hostprocess
Locks
(LOCKS)
Number of locks being requested by the process at the time of record acquisition--longNomaster..syslockinfo.req_spid
Mem Usage
(MEMUSAGE)
Number of procedure cache pages allocated to the process (1 page equals 8 kilobytes)--doubleNomaster..sysprocesses.memusage
Physical I/O
(PHYSICAL_IO)
Cumulative number of times the process executed read/write operations to disks--doubleNomaster..sysprocesses.physical_io
Program
(PROGRAM)
Application program name--string(257)Nomaster..sysprocesses.program_name
Record Time
(RECORD_TIME)
Interval end time (GMT format)--time_tNoRemote Monitor Collector
Record Type
(INPUT_RECORD_TYPE)
Record type (always PDET)--char(8)NoRemote Monitor Collector
SPID
(SPID)
Process ID--wordNomaster..sysprocesses.spid
Start Time
(START_TIME)
Interval start time (GMT format)--time_tNoRemote Monitor Collector
Status
(STATUS)
Process status--string(61)Nomaster..sysprocesses.status
UID
(UID)
User ID of the user who executed the command--wordNomaster..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)Nomaster..sysprocesses.sid, master..syslogins.name or master..sysprocesses.sid, master..sysprocesses.loginame
VA DeviceID(VADEVICEID)Device ID of virtual agent.--string(256)NoRemote Monitor Collector