Processes
(spid, login_time, login_time_ms)
| Name | Data Type | Description |
|---|---|---|
| cputicks | long | CPU time, in milliseconds |
| cpusecs | double | CPU time, in seconds |
| physical_io | double | Number of physical I/O operations (disk reads + writes) |
| memusage | long | Memory usage, in pages (pagesize is 8 KB) |
| spid | long | Session ID |
| loginame | string(516) | Login name |
| status | string(124) | Status:
|
| blkby | long | Blocker session ID, if applicable; may be negative in special circumstances |
| time_blocked | double | Duration of time blocked, in milliseconds |
| dbname | string(260) | Database name |
| cmd | string(68) | General command type being executed |
| program_name | string(516) | Application name |
| hostname | string(516) | Client host name |
| hostprocess | string(36) | Client OS PID |
| kpid | long | Thread ID |
| waitstatus | string(132) | if blocked: Blocked by <spid>; if not blocked: <status> or <lastwaittype> |
| waittimesecs | double | Duration of time waiting, in seconds |
| lastwaittype | string(132) | Current or last wait event name |
| waitresource | string(260) | Text description of the wait resource; for example, a description of the RID that is locked |
| login_time | time | Time of login, with second resolution |
| login_time_ms | long | Millisecond component of login time |
| logintime | string(36) | Text description of login time |
| logintimesecs | long | Duration of time connected, in seconds |
| lastbatchtime | string(36) | Text description of last batch statement time |
| lastbatchtimesecs | long | Duration of time since last batch statement, in seconds |
| open_tran | long | Number of open transactions |
| nt_domain | string(68) | Windows domain of the client |
| nt_username | string(68) | Windows user name of the client |
| MERGESTATUS | long | Internal-use merge status; created by Surveillance |
| CPUPCT | double | CPU % Used (1 CPU), in interval |
| CPUPCT_AVG | double | Average CPU % Used (1 CPU), since collection started |
| CPUPCT_MAX | double | Maximum CPU % Used (1 CPU), since collection started |
| PHYSICAL_IO_RATE | double | Number of physical I/O operations per second, in interval |
| PHYS_IO_RATE_AVG | double | Average number of physical I/O operations per second, since collection started |
| PHYS_IO_RATE_MAX | double | Maximum number of physical I/O operations per second, since collection started |
| Attributes: | None |
|---|---|
| Minimum database version: | 8.0 |