SAP ABAP Data Element MSSCACHESZ (Size of whole SQL Server procedure cache)
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 MSSCACHESZ
Short Description Size of whole SQL Server procedure cache  
Data Type
Category of Dictionary Type D   Domain
Type of Object Referenced     No Information
Domain / Name of Reference Type MSSCOLLMEMSIZE    
Data Type DEC   Counter or amount field with comma and sign 
Length 16    
Decimal Places 1    
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 MB 
Medium 15 Cache size 
Long 23 Procedure cache size MB 
Heading 23 Procedure cache size MB 
Documentation

Definition

Size of the SQL Server Procedure Cache.

This value will be displayed as a decimal instead of an integer value because on some smaller databases the cache size can become smaller than 1 MB. Therefore pay attention if you put this value in relation to all other buffer sizes which are displayed as integers.

Use

Dependencies

Example

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