SAP ABAP Data Element MSSIDXLOAD (Total anticipated cumulative improvement)

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	MSSIDXLOAD
Short Description	Total anticipated cumulative improvement

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	15
Decimal Places	0
Output Length	19
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	Load
Medium	20	Load improvement
Long	38	Anticipated improvement
Heading	50	Anticipated cumulative improvement

Documentation

Definition

Statement load: This value is calculated from several fields in the sys.dm_db_missing_index_group_stats dynamic management view. See also books on-line for SQL Server.

The calculation is done as follows:

statement_load =

avg_total_user_cost * (avg_user_impact/100) * (user_seeks + user_scans) +

avg_total_system_cost * (avg_system_impact/100) * (system_seeks + system_scans)

This means the total expected improvements in user and system queries that could be expected by building the suggested index.

History

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