SAP ABAP Data Element MSSWAITFACTOR (Elapsed time/CPU time)

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	MSSWAITFACTOR
Short Description	Elapsed time/CPU time

Data Type

Category of Dictionary Type		Direct Type Entry
Type of Object Referenced		No Information
Domain / Name of Reference Type
Data Type	DEC	Counter or amount field with comma and sign
Length	20
Decimal Places	0
Output Length	26
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	Wait ratio
Medium	11	Wait ratio
Long	40	Wait ratio: elapsed/CPU time
Heading	0

Documentation

Definition

The wait factor is a measure of how much time is spent waiting for resources (locks or latches or IO) vs. consuming CPU time.

It is calculated using total_elapsed_time/total_worker_time from the sys.dm_exec_query_stats management view.

Use

Dependencies

Example

History

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