SAP ABAP Data Element MSSOSCOMMITTRGMEM (Committed target memory)

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	MSSOSCOMMITTRGMEM
Short Description	Committed target memory

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	6	target
Medium	13	target memory
Long	26	Committed target memory MB
Heading	38	Committed target memory for SQL Server

Documentation

Definition

Committed target memory from sys.dm_os_sys_info.

This value represents the amount of memory, in megabytes (MB), which can be consumed by SQL Server memory manager. The target amount is calculated using a variety of inputs like:

·    the current state of the system including its load

·    the memory requested by current processes

·    the amount of memory installed on the computer

·    configuration parameters

If committed_target_kb is larger than committed_kb, the memory manager will try to obtain additional memory. If committed_target_kb is smaller than committed_kb, the memory manager will try to shrink the amount of memory committed. The committed_target_kb always includes stolen and reserved memory.

History

Last changed by/on	SAP	20140117
SAP Release Created in	740