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 |
|
| 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 | |
DAYOFWEEK | CHAR7 | CHAR | 7 | 0 | Day (for Collector) | ||
| 2 | |
DATUM | DATUM | DATS | 8 | 0 | Date | ||
| 3 | |
UZEIT | UZEIT | TIMS | 6 | 0 | Time | ||
| 4 | |
MSSPBDATAC | DEC | 23 | 0 | Size in KB of the data cache, including unused space | |||
| 5 | |
MSSPBCACHT | DEC | 13 | 3 | Percentage of pages found in the buffer cache | |||
| 6 | |
MSSPBCACSZ | DEC | 23 | 0 | Size in KB of the procedure cache, including unused space. | |||
| 7 | |
MSSPCOBJCT | DEC | 23 | 0 | Number of objects stored in the procedure cache. | |||
| 8 | |
MSSPCPAGES | DEC | 23 | 0 | Number of pages used by this object type in the cache. | |||
| 9 | |
MSSPCUSECT | DEC | 23 | 0 | Number of times an object of this type has been used. | |||
| 10 | |
MSSPCRATIO | DEC | 13 | 3 | Procedure cache hit ratio as percentage. | |||
| 11 | |
MSSPMCACM | DEC | 23 | 0 | Amount of memory being used for dynamic SQL cache in KB | |||
| 12 | |
MSSPMCONN | DEC | 23 | 0 | Amount of dynamic memory the server is using for connections | |||
| 13 | |
MSSPMOPMEM | DEC | 23 | 0 | Amount of memory SQL Server is using for query optimization | |||
| 14 | |
MSSPMLCKM | DEC | 23 | 0 | Amount of dynamic memory used for locks in KB | |||
| 15 | |
MSSPMGWSPM | DEC | 23 | 0 | Amount of memory granted to executing processes in KB | |||
| 16 | |
MSSPMMWSPM | DEC | 23 | 0 | Maximum amount of memory available for executing SQL process | |||
| 17 | |
MSSPBCOMIT | DEC | 23 | 0 | Number of committed pages in cache. | |||
| 18 | |
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 |