SAP ABAP Table MSSPFNTOPS (Display MSQSNAP table: Server set)
Hierarchy
☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-CCM-MON-TUN (Application Component) Performance Monitors (TCC)
     ⤷ STUN (Package) DBA: All the rest in English
Basic Data
Table Category INTTAB    Structure 
Structure MSSPFNTOPS   Table Relationship Diagram
Short Description Display MSQSNAP table: Server set    
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 SQLVERSION MSQVERSN CHAR50 CHAR 50   0   Version of the database management system.  
5 SQLBUILDNM MSQDBVER INT4 INT4 10   0   SQL Server build number (corresponding to a Service Pack).  
6 SQLEE MSQSSSQLEE CHAR1 CHAR 1   0   SQL Server edition: 'X' = Enterprise Ed., 'C' Cluster in use  
7 TRACEFLAGS MSQSSTFLG CHAR255 CHAR 255   0   Trace flags which are currently set for SQL Server.  
8 PARAMDIFF MSQSSPDIFF CHAR1 CHAR 1   0   Configuration options set differ from current values ( ='X')  
9 HOSTNAME MSQHOSTNE CHAR128 CHAR 128   0   Hostname of the application server logged into SQL Server.  
10 SQLSTARTTM MSQDBUPTME CHAR20 CHAR 20   0   Date and time of last SQL Server start.  
11 USERCONCTS MSSPSUSCON   DEC 23   0   Number of user connections to the SQL Server system  
12 WINVER MSQSSWVER CHAR80 CHAR 80   0   Operating system version running on SQL Server host.  
13 CHIP MSQSSCHIP CHAR20 CHAR 20   0   Processor type being used on the host running SQL Server.  
14 SQLUPTIME MSQDSSQLSC INT4 INT4 10   0   Number of seconds SQL Server has been running.  
15 PRODLEVEL MSQSSBLDDT CHAR12 CHAR 12   0   Date the executable sqlservr.exe was created.  
16 NTVER MSQSSNTEE CHAR1 CHAR 1   0   OS edition: A=Advanced Server, S=Server, D=Datacenter.  
17 ISCLUSTER MSSISCLUSTER CHAR1 CHAR 1   0   Is SQL Server clustered 'Y' or 'N'  
18 IS3GB MSSIS3GB CHAR1 CHAR 1   0   Is SQL Server on machine with /3GB switch on 'Y' or 'N'  
19 ISPAE MSSISPAE CHAR1 CHAR 1   0   Is SQL Server on machine with PAE 'Y' or 'N'  
20 ISAWE MSSISAWE CHAR1 CHAR 1   0   Is SQL Server AWE enabled Y' or 'N'  
History
Last changed by/on SAP  20130604 
SAP Release Created in 610