SAP ABAP Table MSS_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 MSS_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 MSSHOSTNM_ TEXT30 CHAR 30   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 PRODLEVEL 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 NTVER MSQSSNTEE CHAR1 CHAR 1   0   OS edition: A=Advanced Server, S=Server, D=Datacenter.  
8 PARAMDIFF CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
9 DISKPERF CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
10 ISCLUSTER MSSISCLUSTER CHAR1 CHAR 1   0   Is SQL Server clustered 'Y' or 'N'  
11 IS3GB MSSIS3GB CHAR1 CHAR 1   0   Is SQL Server on machine with /3GB switch on 'Y' or 'N'  
12 ISPAE MSSISPAE CHAR1 CHAR 1   0   Is SQL Server on machine with PAE 'Y' or 'N'  
13 ISAWE MSSISAWE CHAR1 CHAR 1   0   Is SQL Server AWE enabled Y' or 'N'  
14 CHIP MSQSSCHIP CHAR20 CHAR 20   0   Processor type being used on the host running SQL Server.  
15 WINVER MSQSSWVER CHAR80 CHAR 80   0   Operating system version running on SQL Server host.  
16 NUMCPUS MSQSSCPUS INT4 INT4 10   0   Number of CPUs on the host which runs SQL Server.  
17 SQLCPUS MSQSQLCPUS INT4 INT4 10   0   Maximum number of CPUs SQL Server is configured to use.  
18 MASK MSQSSMASK CHAR08 CHAR 8   0   Bitmask representing the CPUs available to Windows.  
19 PHYMEM MSQSSRAM INT4 INT4 10   0   Amount of RAM on the server running SQL Server  
20 TRACEFLAGS MSQSSTFLG CHAR255 CHAR 255   0   Trace flags which are currently set for SQL Server.  
21 MEMSETTING MSQMEMSET CHAR010 CHAR 10   0   Specifies how SQL Server memory parameters have been set  
22 AGTLOGLOC MSSPATH MSSCSC255 CHAR 255   0   UNC path to a file used by SQL Server  
23 ERRLOGLOC MSSPATH MSSCSC255 CHAR 255   0   UNC path to a file used by SQL Server  
History
Last changed by/on SAP  20110908 
SAP Release Created in 620