SAP ABAP Table MSQ_PMEM (Contains data from sysperfinfo on memory)
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
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
| Table Category | INTTAB | Structure |
| Structure | MSQ_PMEM |
Table Relationship Diagram 
|
| Short Description | Contains data from sysperfinfo on memory |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | ||
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
 |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  CONNECTMEM |
MSQPMCONN | INT4 | INT4 | 10 | 0 | Amount of dynamic memory the server is using for connections | ||
| 2 | WRKPROCMEM |
MSQPMGWSPM | INT4 | INT4 | 10 | 0 | Amount of memory granted to executing processes in KB | ||
| 3 | LOCKMEMORY |
MSQPMLCKM | INT4 | INT4 | 10 | 0 | Amount of dynamic memory used for locks in KB | ||
| 4 | MAXWSPMEM |
MSQPMMWSPM | INT4 | INT4 | 10 | 0 | Maximum amount of memory available for executing SQL process | ||
| 5 | OPTQRYMEM |
MSQPMOPMEM | INT4 | INT4 | 10 | 0 | Amount of memory SQL Server is using for query optimization | ||
| 6 | SQLCACMEM |
MSQPMCACM | INT4 | INT4 | 10 | 0 | Amount of memory being used for dynamic SQL cache in KB | ||
| 7 | TARSRVMEM |
MSQPMTARSM | INT4 | INT4 | 10 | 0 | Amount of memory SQL Server is willing to consume in KB | ||
| 8 | TTLSRVMEM |
MSQPMTTLSM | INT4 | INT4 | 10 | 0 | Amount of memory SQL Server is currently using in KB. | ||
| 9 | USERCONCTS |
MSQPSUSCON | INT4 | INT4 | 10 | 0 | Number of user connections to the SQL Server system | ||
| 10 | CACHEHIT |
MSQPBCACHT | INT4 | INT4 | 10 | 0 | Percentage of pages found in the buffer cache | ||
| 11 | DATACACHSZ |
MSQPBDATAC | INT4 | INT4 | 10 | 0 | Size in KB of the data cache, including unused space | ||
| 12 | CACHESIZE |
MSQPBCACSZ | INT4 | INT4 | 10 | 0 | Size in KB of the procedure cache, including unused space. | ||
| 13 | BUFFCOMMIT |
MSQPBCOMIT | INT4 | INT4 | 10 | 0 | Number of committed pages in cache. | ||
| 14 | FREEBUFFER |
MSQPBFREBF | INT4 | INT4 | 10 | 0 | Number of free pages available in cache. | ||
| 15 | STLPAGECNT |
MSQPBSTPCT | INT4 | INT4 | 10 | 0 | Number of buffer pages taken for other memory requirements |
History
| Last changed by/on | SAP | 20110908 |
| SAP Release Created in |
