SAP MSQ_PMEM table - Contains data from sysperfinfo on memory details in SAP


SAP MSQ_PMEM table summary

Object Name: MSQ_PMEM
Dictionary Type: Structure
Description: Contains data from sysperfinfo on memory


Field list for MSQ_PMEM table on an S/4 SAP system

Details
MSQ_PMEM-CONNECTMEM table field - Amount of dynamic memory the server is using for connections

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

See all SAP tables containing field CONNECTMEM

MSQ_PMEM-WRKPROCMEM table field - Amount of memory granted to executing processes in KB

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

See all SAP tables containing field WRKPROCMEM

MSQ_PMEM-LOCKMEMORY table field - Amount of dynamic memory used for locks in KB

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

See all SAP tables containing field LOCKMEMORY

MSQ_PMEM-MAXWSPMEM table field - Maximum amount of memory available for executing SQL process

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

See all SAP tables containing field MAXWSPMEM

MSQ_PMEM-OPTQRYMEM table field - Amount of memory SQL Server is using for query optimization

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

See all SAP tables containing field OPTQRYMEM

MSQ_PMEM-SQLCACMEM table field - Amount of memory being used for dynamic SQL cache in KB

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

See all SAP tables containing field SQLCACMEM

MSQ_PMEM-TARSRVMEM table field - Amount of memory SQL Server is willing to consume in KB

Description: Amount of memory SQL Server is willing to consume in KB
Field Name: TARSRVMEM
Data Element: MSQPMTARSM
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TARSRVMEM

MSQ_PMEM-TTLSRVMEM table field - Amount of memory SQL Server is currently using in KB.

Description: Amount of memory SQL Server is currently using in KB.
Field Name: TTLSRVMEM
Data Element: MSQPMTTLSM
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TTLSRVMEM

MSQ_PMEM-USERCONCTS table field - Number of user connections to the SQL Server system

Description: Number of user connections to the SQL Server system
Field Name: USERCONCTS
Data Element: MSQPSUSCON
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field USERCONCTS

MSQ_PMEM-CACHEHIT table field - Percentage of pages found in the buffer cache

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

See all SAP tables containing field CACHEHIT

MSQ_PMEM-DATACACHSZ table field - Size in KB of the data cache, including unused space

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

See all SAP tables containing field DATACACHSZ

MSQ_PMEM-CACHESIZE table field - Size in KB of the procedure cache, including unused space.

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

See all SAP tables containing field CACHESIZE

MSQ_PMEM-BUFFCOMMIT table field - Number of committed pages in cache.

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

See all SAP tables containing field BUFFCOMMIT

MSQ_PMEM-FREEBUFFER table field - Number of free pages available in cache.

Description: Number of free pages available in cache.
Field Name: FREEBUFFER
Data Element: MSQPBFREBF
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FREEBUFFER

MSQ_PMEM-STLPAGECNT table field - Number of buffer pages taken for other memory requirements

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

See all SAP tables containing field STLPAGECNT


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table