SMC_NAME_KPID  SMC_NAME_LOCK_HIT_PCT

Chapter 2: Data Items and Statistical Types

SMC_NAME_LOCK_CNT

Description

Reports the number of locks. This is an accumulated value.

Version compatibility

11.0 and later

Data item type

Result

Server level

Yes

Required keys

None

Optional keys

SMC_NAME_SPID, SMC_NAME_LOCK_TYPE, SMC_NAME_LOCK_RESULT, SMC_NAME_LOCK_RESULT_SUMMARY

Statistic types and datatypes

VALUE_ SAMPLE

VALUE_ SESSION

RATE_ SAMPLE

RATE_ SESSION

AVG_ SAMPLE

AVG_ SESSION

LONG

LONG

DOUBLE

DOUBLE



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

View this book as PDF