SMC_NAME_PAGE_LOGICAL_READ  SMC_NAME_PAGE_PHYSICAL_READ

Chapter 2: Data Items and Statistical Types

SMC_NAME_PAGE_NUM

Description

Reports the number of the data page for a given lock or lock request.

Version compatibility

11.0 and later

Data item type

Key

Server level

No

Result data items that require this key

None

Result data items for which this key is optional

SMC_NAME_BLOCKING_SPID

SMC_NAME_DEMAND_LOCK

SMC_NAME_LOCKS_BEING_BLOCKED_CNT

SMC_NAME_TIME_WAITED_ON_LOCK

Statistic types and datatypes

VALUE_ SAMPLE

VALUE_ SESSION

RATE_ SAMPLE

RATE_ SESSION

AVG_ SAMPLE

AVG_ SESSION

LONG



Copyright © 2001. Sybase Inc. All rights reserved. SMC_NAME_PAGE_PHYSICAL_READ

View this book as PDF