SAP ABAP Data Element MSSPGLATCHWAIT (Wait time per buffer page latch 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	MSSPGLATCHWAIT
Short Description	Wait time per buffer page latch 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	Write wait
Medium	20	Page write wait time
Long	20	Page write wait time
Heading	32	Wait time per page write request

Documentation

Definition

Average latch wait time in milli seconds to read a requested page from disk into the buffer.

This value is derived from dbcc SQLPERF(WAITSTATS) with the wait type PAGEIOLATCH_SH.

The wait time value per read request is built from the quotient (wait time) / (number of requests).

This counter is -somehow- related to the counter IOStallMS (IOStall per read in ST04) which is derived from ::fn_virtualfilestats. But both counters are calculated and maintained by different modules within SQL Server. IOStallMS is a counter from an I/O perspective (file system access time) whereas the latch wait time is rather a counter from the buffer management inside of the SQL Server engine.

Use

Dependencies

Example

History

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