SAP MSSPFMEUSG table - Display MSQSNAP table: Internal memory usage details in SAP

Description: Day (for Collector)
Field Name: DAYOW
Data Element: DAYOFWEEK
Data Type: CHAR
length (Dec): 7(0)
Check table:
Conversion Routine:
Domain Name: CHAR7
MemoryID:
AppClass: SDIN
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DAYOW

Description: Date
Field Name: RECORDDATE
Data Element: DATUM
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RECORDDATE

Description: Time
Field Name: RECORDTIME
Data Element: UZEIT
Data Type: TIMS
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: UZEIT
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RECORDTIME

Description: Size in KB of the data cache, including unused space
Field Name: DATACACHSZ
Data Element: MSSPBDATAC
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DATACACHSZ

Description: Percentage of pages found in the buffer cache
Field Name: CACHEHIT
Data Element: MSSPBCACHT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CACHEHIT

Description: Size in KB of the procedure cache, including unused space.
Field Name: CACHESIZE
Data Element: MSSPBCACSZ
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CACHESIZE

Description: Number of objects stored in the procedure cache.
Field Name: OBJECTCNT
Data Element: MSSPCOBJCT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OBJECTCNT

Description: Number of pages used by this object type in the cache.
Field Name: OBJPAGES
Data Element: MSSPCPAGES
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OBJPAGES

Description: Number of times an object of this type has been used.
Field Name: USECOUNTS
Data Element: MSSPCUSECT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field USECOUNTS

Description: Procedure cache hit ratio as percentage.
Field Name: HITRATIO
Data Element: MSSPCRATIO
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HITRATIO

Description: Amount of memory being used for dynamic SQL cache in KB
Field Name: SQLCACMEM
Data Element: MSSPMCACM
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQLCACMEM

Description: Amount of dynamic memory the server is using for connections
Field Name: CONNECTMEM
Data Element: MSSPMCONN
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CONNECTMEM

Description: Amount of memory SQL Server is using for query optimization
Field Name: OPTQRYMEM
Data Element: MSSPMOPMEM
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OPTQRYMEM

Description: Amount of dynamic memory used for locks in KB
Field Name: LOCKMEMORY
Data Element: MSSPMLCKM
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOCKMEMORY

Description: Amount of memory granted to executing processes in KB
Field Name: WRKPROCMEM
Data Element: MSSPMGWSPM
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WRKPROCMEM

Description: Maximum amount of memory available for executing SQL process
Field Name: MAXWSPMEM
Data Element: MSSPMMWSPM
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MAXWSPMEM

Description: Number of committed pages in cache.
Field Name: BUFFCOMMIT
Data Element: MSSPBCOMIT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BUFFCOMMIT

Description: Number of buffer pages taken for other memory requirements
Field Name: STLPAGECNT
Data Element: MSSPBSTPCT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STLPAGECNT