SAP ABAP Table MSQ_STSERV (data about sqlserver and the host its running on)
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 MSQ_STSERV   Table Relationship Diagram
Short Description data about sqlserver and the host its running on    
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 HOSTNAME MSQHOSTNE CHAR128 CHAR 128   0   Hostname of the application server logged into SQL Server.  
2 SQLVERSION MSQVERSN CHAR50 CHAR 50   0   Version of the database management system.  
3 SQLBUILDNM MSQDBVER INT4 INT4 10   0   SQL Server build number (corresponding to a Service Pack).  
4 SQLBUILDDT MSQSSBLDDT CHAR12 CHAR 12   0   Date the executable sqlservr.exe was created.  
5 SQLSTARTTM MSQDBUPTME CHAR20 CHAR 20   0   Date and time of last SQL Server start.  
6 SQLEE MSQSSSQLEE CHAR1 CHAR 1   0   SQL Server edition: 'X' = Enterprise Ed., 'C' Cluster in use  
7 NTEE MSQSSNTEE CHAR1 CHAR 1   0   OS edition: A=Advanced Server, S=Server, D=Datacenter.  
8 DOMAINCTLR MSQSSDOMC CHAR1 CHAR 1   0   X if the host running SQL Server is a domain controller.  
9 PARAMDIFF MSQSSPDIFF CHAR1 CHAR 1   0   Configuration options set differ from current values ( ='X')  
10 DISKPERF MSQSSDSKPF CHAR1 CHAR 1   0   'X' if diskperf -y has been set for db server  
11 CHIP MSQSSCHIP CHAR20 CHAR 20   0   Processor type being used on the host running SQL Server.  
12 WINVER MSQSSWVER CHAR80 CHAR 80   0   Operating system version running on SQL Server host.  
13 NUMCPUS MSQSSCPUS INT4 INT4 10   0   Number of CPUs on the host which runs SQL Server.  
14 SQLCPUS MSQSQLCPUS INT4 INT4 10   0   Maximum number of CPUs SQL Server is configured to use.  
15 MASK MSQSSMASK CHAR08 CHAR 8   0   Bitmask representing the CPUs available to Windows.  
16 PHYMEM MSQSSRAM INT4 INT4 10   0   Amount of RAM on the server running SQL Server  
17 TRACEFLAGS MSQSSTFLG CHAR255 CHAR 255   0   Trace flags which are currently set for SQL Server.  
18 MEMSETTING MSQMEMSET CHAR010 CHAR 10   0   Specifies how SQL Server memory parameters have been set  
History
Last changed by/on SAP  20110908 
SAP Release Created in