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

SAP MSD_STSERV table summary

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

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

Details

MSD_STSERV-HOSTNAME table field - MS SQL server - name of the workstation or server. ▼

Description: MS SQL server - name of the workstation or server.
Field Name: HOSTNAME
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HOSTNAME

MSD_STSERV-SQLVERSION table field - MSQ SQL server - version ▼

Description: MSQ SQL server - version
Field Name: SQLVERSION
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQLVERSION

MSD_STSERV-SQLBUILDNM table field - MS SQL server - database version ▼

Description: MS SQL server - database version
Field Name: SQLBUILDNM
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQLBUILDNM

MSD_STSERV-SQLBUILDDT table field - the date sqlserver.exe was created ▼

Description: the date sqlserver.exe was created
Field Name: SQLBUILDDT
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQLBUILDDT

MSD_STSERV-SQLSTARTTM table field - MS SQL server - time of last sql server startup ▼

Description: MS SQL server - time of last sql server startup
Field Name: SQLSTARTTM
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQLSTARTTM

MSD_STSERV-SQLEE table field - X if the enterprise edition of sql server is being used ▼

Description: X if the enterprise edition of sql server is being used
Field Name: SQLEE
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQLEE

MSD_STSERV-NTEE table field - X if the enterprise edition of NT is being used ▼

Description: X if the enterprise edition of NT is being used
Field Name: NTEE
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NTEE

MSD_STSERV-DOMAINCTLR table field - X if the server running SQLServer is a Domain Controller ▼

Description: X if the server running SQLServer is a Domain Controller
Field Name: DOMAINCTLR
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DOMAINCTLR

MSD_STSERV-PARAMDIFF table field - X if a diff. exists between the set and run values of SQL ▼

Description: X if a diff. exists between the set and run values of SQL
Field Name: PARAMDIFF
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PARAMDIFF

MSD_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:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DISKPERF

MSD_STSERV-CHIP table field - The processor type being used on the server running SQL ▼

Description: The processor type being used on the server running SQL
Field Name: CHIP
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CHIP

MSD_STSERV-WINVER table field - NT version being run on the host running SQL Server ▼

Description: NT version being run on the host running SQL Server
Field Name: WINVER
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WINVER

MSD_STSERV-NUMCPUS table field - the number of CPUS on the server which runs SQL Server ▼

Description: the number of CPUS on the server which runs SQL Server
Field Name: NUMCPUS
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NUMCPUS

MSD_STSERV-SQLCPUS table field - The number of cpus SQL Server is allowed to run on ▼

Description: The number of cpus SQL Server is allowed to run on
Field Name: SQLCPUS
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQLCPUS

MSD_STSERV-MASK table field - Bitmask which shows processors usable by NT ▼

Description: Bitmask which shows processors usable by NT
Field Name: MASK
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MASK

MSD_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:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PHYMEM

MSD_STSERV-TRACEFLAGS table field - Trace flags which are set for the SQLServer executable ▼

Description: Trace flags which are set for the SQLServer executable
Field Name: TRACEFLAGS
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TRACEFLAGS

MSD_STSERV-MEMSETTING table field - Relates how SQL Server memory parameters have been set ▼

Description: Relates how SQL Server memory parameters have been set
Field Name: MEMSETTING
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
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