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
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