Data Element list used by SAP ABAP Table MSQ_PMEM (Contains data from sysperfinfo on memory)
SAP ABAP Table
MSQ_PMEM (Contains data from sysperfinfo on memory) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | MSQPBCACHT | Percentage of pages found in the buffer cache | ||
| 2 | MSQPBCACSZ | Size in KB of the procedure cache, including unused space. | ||
| 3 | MSQPBCOMIT | Number of committed pages in cache. | ||
| 4 | MSQPBDATAC | Size in KB of the data cache, including unused space | ||
| 5 | MSQPBFREBF | Number of free pages available in cache. | ||
| 6 | MSQPBSTPCT | Number of buffer pages taken for other memory requirements | ||
| 7 | MSQPMCACM | Amount of memory being used for dynamic SQL cache in KB | ||
| 8 | MSQPMCONN | Amount of dynamic memory the server is using for connections | ||
| 9 | MSQPMGWSPM | Amount of memory granted to executing processes in KB | ||
| 10 | MSQPMLCKM | Amount of dynamic memory used for locks in KB | ||
| 11 | MSQPMMWSPM | Maximum amount of memory available for executing SQL process | ||
| 12 | MSQPMOPMEM | Amount of memory SQL Server is using for query optimization | ||
| 13 | MSQPMTARSM | Amount of memory SQL Server is willing to consume in KB | ||
| 14 | MSQPMTTLSM | Amount of memory SQL Server is currently using in KB. | ||
| 15 | MSQPSUSCON | Number of user connections to the SQL Server system |