SMC_NAME_PAGE_INDEX_LOGICAL_READ  SMC_NAME_PAGE_IO

Chapter 2: Data Items and Statistical Types

SMC_NAME_PAGE_INDEX_PHYSICAL_READ

Description

Reports the number of index page reads that could not be satisfied from the data cache.

Version compatibility

11.0 and later

Data item type

Result

Server level

No

Required keys

None

Optional keys

SMC_NAME_SPID, SMC_NAME_APPLICATION_NAME, SMC_NAME_DB_ID, SMC_NAME_OBJ_ID, SMC_NAME_ENGINE_NUM, [SMC_NAME_ACT_STP_DB_ID + SMC_NAME_ACT_STP_ID]

NoteSMC_NAME_SPID and SMC_NAME_APPLICATION_NAME are mutually exclusive.

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_PAGE_IO

View this book as PDF