Table/Structure Field list used by SAP ABAP Function Module GET_SQLPERFMEMORY_MSS (retrieve data from sap_perfdb on memory usage)
SAP ABAP Function Module 
GET_SQLPERFMEMORY_MSS (retrieve data from sap_perfdb on memory usage) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 |  Table/Structure Field |
DBCON - CON_NAME | Logical name for a database connection | |
| 2 | Table/Structure Field |
DBCON - CON_NAME | Logical name for a database connection | SOURCE VALUE(CON_NAME) TYPE DBCON-CON_NAME DEFAULT 'DEFAULT' |
| 3 | Table/Structure Field |
MSSCOLLODESC - CNTR_NAME | MSSCOLLODESC-CNTR_NAME | |
| 4 | Table/Structure Field |
MSSCOLLODESC - OBJ_NAME | MSSCOLLODESC-OBJ_NAME | |
| 5 | Table/Structure Field |
MSSCOLLRESI - CNTR_NAME | MSSCOLLRESI-CNTR_NAME | |
| 6 | Table/Structure Field |
MSSCOLLRESI - CNTR_VALUE | MSSCOLLRESI-CNTR_VALUE | |
| 7 | Table/Structure Field |
MSSCOLLRESI - OBJ_NAME | MSSCOLLRESI-OBJ_NAME | |
| 8 | Table/Structure Field |
MSSCOLLRESI - SLOPE | MSSCOLLRESI-SLOPE | |
| 9 | Table/Structure Field |
MSS_PMEM - MAXWSPMEM | Maximum amount of memory available for executing SQL process | |
| 10 | Table/Structure Field |
MSS_PMEM - WRKPROCMEM | Amount of memory granted to executing processes in KB | |
| 11 | Table/Structure Field |
MSS_PMEM - TTLSRVMEM | Amount of memory SQL Server is currently using in KB. | |
| 12 | Table/Structure Field |
MSS_PMEM - TARSRVMEM | Amount of memory SQL Server is willing to consume in KB | |
| 13 | Table/Structure Field |
MSS_PMEM - STLPAGECNT | Number of buffer pages taken for other memory requirements | |
| 14 | Table/Structure Field |
MSS_PMEM - SQLCACMEM | Amount of memory being used for dynamic SQL cache in KB | |
| 15 | Table/Structure Field |
MSS_PMEM - OPTQRYMEM | Amount of memory SQL Server is using for query optimization | |
| 16 | Table/Structure Field |
MSS_PMEM - LOCKMEMORY | Amount of dynamic memory used for locks in KB | |
| 17 | Table/Structure Field |
MSS_PMEM - FREEBUFFER | Number of free pages available in cache. | |
| 18 | Table/Structure Field |
MSS_PMEM - DATACACHSZ | Size in KB of the data cache, including unused space | |
| 19 | Table/Structure Field |
MSS_PMEM - CONNECTMEM | Amount of dynamic memory the server is using for connections | |
| 20 | Table/Structure Field |
MSS_PMEM - CACHESIZE | Size in KB of the procedure cache, including unused space. | |
| 21 | Table/Structure Field |
MSS_PMEM - CACHEHIT | Percentage of pages found in the buffer cache | |
| 22 | Table/Structure Field |
SYST - MSGID | ABAP System Field: Message ID | |
| 23 | Table/Structure Field |
SYST - MSGNO | ABAP System Field: Message Number | |
| 24 | Table/Structure Field |
SYST - MSGTY | ABAP System Field: Message Type | |
| 25 | Table/Structure Field |
SYST - MSGV1 | ABAP System Field: Message Variable | |
| 26 | Table/Structure Field |
SYST - MSGV2 | ABAP System Field: Message Variable | |
| 27 | Table/Structure Field |
SYST - MSGV3 | ABAP System Field: Message Variable | |
| 28 | Table/Structure Field |
SYST - MSGV4 | ABAP System Field: Message Variable |
