SMC_NAME_THREAD_MAX_USED  SMC_NAME_TIMESTAMP

Chapter 2: Data Items and Statistical Types

SMC_NAME_TIME_WAITED_ON_LOCK

Description

Reports the amount of time (in seconds) waited for a lock request to be granted.

Version compatibility

11.0 and later

Data item type

Result

Server level

No

Required keys

SMC_NAME_SPID, SMC_NAME_DB_ID, SMC_NAME_OBJ_ID, SMC_NAME_LOCK_STATUS

Optional keys

SMC_NAME_LOCK_TYPE, SMC_NAME_PAGE_NUM

Statistic types and datatypes

VALUE_ SAMPLE

VALUE_ SESSION

RATE_ SAMPLE

RATE_ SESSION

AVG_ SAMPLE

AVG_ SESSION

LONG



Copyright © 2005. Sybase Inc. All rights reserved. SMC_NAME_TIMESTAMP

View this book as PDF