SAP ABAP Data Element MSSIOSTALLREAD (IOStall per read request)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-MSS (Application Component) Microsoft SQL Server
     ⤷ STUN_MSS (Package) Package for new SQL Server monitoring objects

Basic Data

Data Element	MSSIOSTALLREAD
Short Description	IOStall per read request

Data Type

Category of Dictionary Type	D	Domain
Type of Object Referenced		No Information
Domain / Name of Reference Type	MSSCOLLSLOPE
Data Type	DEC	Counter or amount field with comma and sign
Length	16
Decimal Places	3
Output Length	21
Value Table

Further Characteristics

Search Help: Name
Search Help: Parameters
Parameter ID
Default Component name
Change document	☐
No Input History	☐
Basic direction is set to LTR	☐
No BIDI Filtering	☐

Field Label

	Length	Field Label
Short	10	IOStall
Medium	16	IOStall per read
Long	20	IOStall per read
Heading	21	IOStall per read

Documentation

Definition

IOStall is the average waiting time (in milli seconds) for the end of an I/O operation. In SQL 2000 (8.0) this counter represents read and write stalls. On Yukon (9.0) read and write will be available separately. But since most write operations are done asynchronously (except of log) the waiting part will be mainly dominated by read operations anyway.

The value is derived from ::fn_virtualfilestats. The counter is related to the latch wait time counter since both counters reflect I/O wait times. But both counters are maintained in different parts of the SQL Server engine and therefore the values are different.

Use

Dependencies

Example

History

Last changed by/on	SAP	20110908
SAP Release Created in	640