SAP ABAP Table MSSPERFMEM (Display MSQSNAP table: 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
⤷ 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 | MSSPERFMEM | Table Relationship Diagram |
Short Description | Display MSQSNAP table: 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 | 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 | PHYMEM | MSQSSRAM | INT4 | INT4 | 10 | 0 | Amount of RAM on the server running SQL Server | ||
5 | TARSRVMEM | MSSPMTARSM | DEC | 23 | 0 | Amount of memory SQL Server is willing to consume in KB | |||
6 | MEMSETTING | MSQMEMSET | CHAR010 | CHAR | 10 | 0 | Specifies how SQL Server memory parameters have been set | ||
7 | NUMCPUS | MSQSSCPUS | INT4 | INT4 | 10 | 0 | Number of CPUs on the host which runs SQL Server. | ||
8 | SQLCPUS | MSQSQLCPUS | INT4 | INT4 | 10 | 0 | Maximum number of CPUs SQL Server is configured to use. | ||
9 | MASK | MSQSSMASK | CHAR08 | CHAR | 8 | 0 | Bitmask representing the CPUs available to Windows. | ||
10 | CPUBUSY | MSQDSCPUBY | INT4 | INT4 | 10 | 0 | Number of seconds CPUs have been busy (sum for all CPUs) . | ||
11 | CPUIDLE | MSQDSCPUID | INT4 | INT4 | 10 | 0 | Number of seconds CPUs have been idle (sum for all CPUs) . | ||
12 | IOBUSY | MSQDSIOBSY | INT4 | INT4 | 10 | 0 | Number of seconds SQL Server tasks were busy with IO. | ||
13 | PCTCPU | MSQDSCPPCT | INT4 | INT4 | 10 | 0 | Percent of time the CPUs have been busy. | ||
14 | PCTIO | MSQDSIOPCT | INT4 | INT4 | 10 | 0 | Percent of time SQL Server tasks have beeen busy whit IO. |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in | 610 |