SMC_NAME_SPID

Description

Reports the process identification number. Views that contain SMC_NAME_SPID only report on processes that are active as of the end of the sample period. SMC_NAME_SPID is mutually exclusive with SMC_NAME_APPLICATION_NAME in a view.

Version compatibility

11.0 and later

Data item type

Key

Server level

No

Result data items that require this key

SMC_NAME_BLOCKING_SPID

SMC_NAME_CONNECT_TIME

SMC_NAME_CPU_PCT

SMC_NAME_CPU_TIME

SMC_NAME_CUR_APP_NAME

SMC_NAME_CUR_ENGINE

SMC_NAME_CUR_EXECUTION_CLASS

SMC_NAME_CUR_PROC_STATE

SMC_NAME_CUR_STMT_ACT_STP_DB_NAME

SMC_NAME_CUR_STMT_ACT_STP_NAME

SMC_NAME_CUR_STMT_ACT_STP_OWNER_NAME

SMC_NAME_CUR_STMT_ACT_STP_TEXT

SMC_NAME_CUR_STMT_BATCH_TEXT

SMC_NAME_CUR_STMT_CPU_TIME

SMC_NAME_CUR_STMT_ELAPSED_TIME

SMC_NAME_CUR_STMT_LINE_NUM

SMC_NAME_CUR_STMT_LOCKS_GRANTED_IMMED

SMC_NAME_CUR_STMT_LOCKS_GRANTED_WAITED

SMC_NAME_CUR_STMT_LOCKS_NOT_GRANTED

SMC_NAME_CUR_STMT_PAGE_IO_CNT

SMC_NAME_CUR_STMT_PAGE_CACHE_READ_CNT

SMC_NAME_CUR_STMT_PAGE_PHYSICAL_READ_CNT

SMC_NAME_CUR_STMT_PAGE_WRITE_CNT

SMC_NAME_CUR_STMT_QUERY_PLAN_TEXT

SMC_NAME_CUR_STMT_START_TIME

SMC_NAME_CUR_STMT_TEXT_BYTE_OFFSET

SMC_NAME_DEMAND_LOCK

SMC_NAME_HOST_NAME

SMC_NAME_KPID

SMC_NAME_LOCKS_BEING_BLOCKED_CNT

SMC_NAME_LOGIN_NAME

SMC_NAME_TIME_WAITED_ON_LOCK

Result data items for which this key is optional

SMC_NAME_LOCK_CNT

SMC_NAME_LOCKS_GRANTED_IMMED

SMC_NAME_LOCKS_GRANTED_WAITED

SMC_NAME_LOCKS_NOT_GRANTED

SMC_NAME_PAGE_INDEX_LOGICAL_READ

SMC_NAME_PAGE_INDEX_PHYSICAL_READ

SMC_NAME_PAGE_LOGICAL_READ

SMC_NAME_PAGE_PHYSICAL_READ

SMC_NAME_PAGE_WRITE

SMC_NAME_STP_CPU_TIME

SMC_NAME_STP_NUM_TIMES_EXECUTED

Statistic types and datatypes

VALUE_ SAMPLE

VALUE_ SESSION

RATE_ SAMPLE

RATE_ SESSION

AVG_ SAMPLE

AVG_ SESSION

LONG