SAP ABAP Table MSSPFMEUSG (Display MSQSNAP table: Internal memory usage)
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 MSSPFMEUSG   Table Relationship Diagram
Short Description Display MSQSNAP table: Internal memory usage    
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 DAYOW DAYOFWEEK CHAR7 CHAR 7   0   Day (for Collector)  
2 RECORDDATE DATUM DATUM DATS 8   0   Date  
3 RECORDTIME UZEIT UZEIT TIMS 6   0   Time  
4 DATACACHSZ MSSPBDATAC   DEC 23   0   Size in KB of the data cache, including unused space  
5 CACHEHIT MSSPBCACHT   DEC 13   3   Percentage of pages found in the buffer cache  
6 CACHESIZE MSSPBCACSZ   DEC 23   0   Size in KB of the procedure cache, including unused space.  
7 OBJECTCNT MSSPCOBJCT   DEC 23   0   Number of objects stored in the procedure cache.  
8 OBJPAGES MSSPCPAGES   DEC 23   0   Number of pages used by this object type in the cache.  
9 USECOUNTS MSSPCUSECT   DEC 23   0   Number of times an object of this type has been used.  
10 HITRATIO MSSPCRATIO   DEC 13   3   Procedure cache hit ratio as percentage.  
11 SQLCACMEM MSSPMCACM   DEC 23   0   Amount of memory being used for dynamic SQL cache in KB  
12 CONNECTMEM MSSPMCONN   DEC 23   0   Amount of dynamic memory the server is using for connections  
13 OPTQRYMEM MSSPMOPMEM   DEC 23   0   Amount of memory SQL Server is using for query optimization  
14 LOCKMEMORY MSSPMLCKM   DEC 23   0   Amount of dynamic memory used for locks in KB  
15 WRKPROCMEM MSSPMGWSPM   DEC 23   0   Amount of memory granted to executing processes in KB  
16 MAXWSPMEM MSSPMMWSPM   DEC 23   0   Maximum amount of memory available for executing SQL process  
17 BUFFCOMMIT MSSPBCOMIT   DEC 23   0   Number of committed pages in cache.  
18 STLPAGECNT MSSPBSTPCT   DEC 23   0   Number of buffer pages taken for other memory requirements  
History
Last changed by/on SAP  20130604 
SAP Release Created in 610