SAP MSQ_STSERV table - data about sqlserver and the host its running on details in SAP

SAP MSQ_STSERV table summary

Object Name: MSQ_STSERV
Dictionary Type: Structure
Description: data about sqlserver and the host its running on

Field list for MSQ_STSERV table on an S/4 SAP system

Details

MSQ_STSERV-HOSTNAME table field - Hostname of the application server logged into SQL Server. ▼

Description: Hostname of the application server logged into SQL Server.
Field Name: HOSTNAME
Data Element: MSQHOSTNE
Data Type: CHAR
length (Dec): 128(0)
Check table:
Conversion Routine:
Domain Name: CHAR128
MemoryID:
AppClass: SPO
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HOSTNAME

MSQ_STSERV-SQLVERSION table field - Version of the database management system. ▼

Description: Version of the database management system.
Field Name: SQLVERSION
Data Element: MSQVERSN
Data Type: CHAR
length (Dec): 50(0)
Check table:
Conversion Routine:
Domain Name: CHAR50
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQLVERSION

MSQ_STSERV-SQLBUILDNM table field - SQL Server build number (corresponding to a Service Pack). ▼

Description: SQL Server build number (corresponding to a Service Pack).
Field Name: SQLBUILDNM
Data Element: MSQDBVER
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQLBUILDNM

MSQ_STSERV-SQLBUILDDT table field - Date the executable sqlservr.exe was created. ▼

Description: Date the executable sqlservr.exe was created.
Field Name: SQLBUILDDT
Data Element: MSQSSBLDDT
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: CHAR12
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQLBUILDDT

MSQ_STSERV-SQLSTARTTM table field - Date and time of last SQL Server start. ▼

Description: Date and time of last SQL Server start.
Field Name: SQLSTARTTM
Data Element: MSQDBUPTME
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: CHAR20
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQLSTARTTM

MSQ_STSERV-SQLEE table field - SQL Server edition: 'X' = Enterprise Ed., 'C' Cluster in use ▼

Description: SQL Server edition: 'X' = Enterprise Ed., 'C' Cluster in use
Field Name: SQLEE
Data Element: MSQSSSQLEE
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQLEE

MSQ_STSERV-NTEE table field - OS edition: A=Advanced Server, S=Server, D=Datacenter. ▼

Description: OS edition: A=Advanced Server, S=Server, D=Datacenter.
Field Name: NTEE
Data Element: MSQSSNTEE
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NTEE

MSQ_STSERV-DOMAINCTLR table field - X if the host running SQL Server is a domain controller. ▼

Description: X if the host running SQL Server is a domain controller.
Field Name: DOMAINCTLR
Data Element: MSQSSDOMC
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DOMAINCTLR

MSQ_STSERV-PARAMDIFF table field - Configuration options set differ from current values ( ='X') ▼

Description: Configuration options set differ from current values ( ='X')
Field Name: PARAMDIFF
Data Element: MSQSSPDIFF
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PARAMDIFF

MSQ_STSERV-DISKPERF table field - 'X' if diskperf -y has been set for db server ▼

Description: 'X' if diskperf -y has been set for db server
Field Name: DISKPERF
Data Element: MSQSSDSKPF
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DISKPERF

MSQ_STSERV-CHIP table field - Processor type being used on the host running SQL Server. ▼

Description: Processor type being used on the host running SQL Server.
Field Name: CHIP
Data Element: MSQSSCHIP
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: CHAR20
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CHIP

MSQ_STSERV-WINVER table field - Operating system version running on SQL Server host. ▼

Description: Operating system version running on SQL Server host.
Field Name: WINVER
Data Element: MSQSSWVER
Data Type: CHAR
length (Dec): 80(0)
Check table:
Conversion Routine:
Domain Name: CHAR80
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WINVER

MSQ_STSERV-NUMCPUS table field - Number of CPUs on the host which runs SQL Server. ▼

Description: Number of CPUs on the host which runs SQL Server.
Field Name: NUMCPUS
Data Element: MSQSSCPUS
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NUMCPUS

MSQ_STSERV-SQLCPUS table field - Maximum number of CPUs SQL Server is configured to use. ▼

Description: Maximum number of CPUs SQL Server is configured to use.
Field Name: SQLCPUS
Data Element: MSQSQLCPUS
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQLCPUS

MSQ_STSERV-MASK table field - Bitmask representing the CPUs available to Windows. ▼

Description: Bitmask representing the CPUs available to Windows.
Field Name: MASK
Data Element: MSQSSMASK
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: CHAR08
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MASK

MSQ_STSERV-PHYMEM table field - Amount of RAM on the server running SQL Server ▼

Description: Amount of RAM on the server running SQL Server
Field Name: PHYMEM
Data Element: MSQSSRAM
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PHYMEM

MSQ_STSERV-TRACEFLAGS table field - Trace flags which are currently set for SQL Server. ▼

Description: Trace flags which are currently set for SQL Server.
Field Name: TRACEFLAGS
Data Element: MSQSSTFLG
Data Type: CHAR
length (Dec): 255(0)
Check table:
Conversion Routine:
Domain Name: CHAR255
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TRACEFLAGS

MSQ_STSERV-MEMSETTING table field - Specifies how SQL Server memory parameters have been set ▼

Description: Specifies how SQL Server memory parameters have been set
Field Name: MEMSETTING
Data Element: MSQMEMSET
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: CHAR010
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MEMSETTING

View list of all SAP tables(S4H/ECC)

Select data from SAP table