SAP ABAP Table MSS_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
Basic Data
Table Category INTTAB    Structure 
Structure MSS_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 MSSPMCONN   DEC 23   0   Amount of dynamic memory the server is using for connections  
2 WRKPROCMEM MSSPMGWSPM   DEC 23   0   Amount of memory granted to executing processes in KB  
3 LOCKMEMORY MSSPMLCKM   DEC 23   0   Amount of dynamic memory used for locks in KB  
4 MAXWSPMEM MSSPMMWSPM   DEC 23   0   Maximum amount of memory available for executing SQL process  
5 OPTQRYMEM MSSPMOPMEM   DEC 23   0   Amount of memory SQL Server is using for query optimization  
6 SQLCACMEM MSSPMCACM   DEC 23   0   Amount of memory being used for dynamic SQL cache in KB  
7 TARSRVMEM MSSPMTARSM   DEC 23   0   Amount of memory SQL Server is willing to consume in KB  
8 TTLSRVMEM MSSPMTTLSM   DEC 23   0   Amount of memory SQL Server is currently using in KB.  
9 USERCONCTS MSSPSUSCON   DEC 23   0   Number of user connections to the SQL Server system  
10 CACHEHIT MSSPBCACHT   DEC 13   3   Percentage of pages found in the buffer cache  
11 DATACACHSZ MSSPBDATAC   DEC 23   0   Size in KB of the data cache, including unused space  
12 CACHESIZE MSSPBCACSZ   DEC 23   0   Size in KB of the procedure cache, including unused space.  
13 BUFFCOMMIT MSSPBCOMIT   DEC 23   0   Number of committed pages in cache.  
14 FREEBUFFER MSSPBFREBF   DEC 23   0   Number of free pages available in cache.  
15 STLPAGECNT MSSPBSTPCT   DEC 23   0   Number of buffer pages taken for other memory requirements  
History
Last changed by/on SAP  20110908 
SAP Release Created in 630