Chapter 2: Data Items and Statistical Types

SMC_NAME_CUR_PROC_STATE

Description

Reports the current state of a process. The possible states are:

None
Alarm Sleep
Background
Bad Status
Infected
Lock Sleep
Received Sleep
Remote I/O
Runnable
Running
Send Sleep
Sleeping
Stopped
Sync Sleep
Terminating
Yielding

Version compatibility

11.0 and later

Data item type

Result

Server level

No

Required keys

SMC_NAME_SPID

Optional keys

None

Statistic types and datatypes

VALUE_ SAMPLE	VALUE_ SESSION	RATE_ SAMPLE	RATE_ SESSION	AVG_ SAMPLE	AVG_ SESSION
ENUMS

Enum

SMC_PROC_STATE

Copyright © 2005. Sybase Inc. All rights reserved.

SMC_NAME_CUR_STMT_ACT_STP_DB_ID

View this book as PDF