Data Element list used by SAP ABAP Table MSS_STSERV (data about sqlserver and the host its running on)
SAP ABAP Table
MSS_STSERV (data about sqlserver and the host its running on) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | CHAR1 | Single-Character Flag | ||
| 2 | CHAR1 | Single-Character Flag | ||
| 3 | MSQDBUPTME | Date and time of last SQL Server start. | ||
| 4 | MSQDBVER | SQL Server build number (corresponding to a Service Pack). | ||
| 5 | MSQMEMSET | Specifies how SQL Server memory parameters have been set | ||
| 6 | MSQSQLCPUS | Maximum number of CPUs SQL Server is configured to use. | ||
| 7 | MSQSSBLDDT | Date the executable sqlservr.exe was created. | ||
| 8 | MSQSSCHIP | Processor type being used on the host running SQL Server. | ||
| 9 | MSQSSCPUS | Number of CPUs on the host which runs SQL Server. | ||
| 10 | MSQSSMASK | Bitmask representing the CPUs available to Windows. | ||
| 11 | MSQSSNTEE | OS edition: A=Advanced Server, S=Server, D=Datacenter. | ||
| 12 | MSQSSRAM | Amount of RAM on the server running SQL Server | ||
| 13 | MSQSSSQLEE | SQL Server edition: 'X' = Enterprise Ed., 'C' Cluster in use | ||
| 14 | MSQSSTFLG | Trace flags which are currently set for SQL Server. | ||
| 15 | MSQSSWVER | Operating system version running on SQL Server host. | ||
| 16 | MSQVERSN | Version of the database management system. | ||
| 17 | MSSHOSTNM_ | Hostname of the application server logged into SQL Server | ||
| 18 | MSSIS3GB | Is SQL Server on machine with /3GB switch on 'Y' or 'N' | ||
| 19 | MSSISAWE | Is SQL Server AWE enabled Y' or 'N' | ||
| 20 | MSSISCLUSTER | Is SQL Server clustered 'Y' or 'N' | ||
| 21 | MSSISPAE | Is SQL Server on machine with PAE 'Y' or 'N' | ||
| 22 | MSSPATH | UNC path to a file used by SQL Server | ||
| 23 | MSSPATH | UNC path to a file used by SQL Server |