SAP MSQ_DBCNFG table - Contains the SQL server parameter values details in SAP

SAP MSQ_DBCNFG table summary

Object Name: MSQ_DBCNFG
Dictionary Type: Structure
Description: Contains the SQL server parameter values

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

Details

MSQ_DBCNFG-AFFMASK table field - Controls which processors SQL Server runs on ▼

Description: Controls which processors SQL Server runs on
Field Name: AFFMASK
Data Element: MSQCFAFMSK
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 AFFMASK

MSQ_DBCNFG-ALLOWUPDS table field - A SQL Server configuration parameter value ▼

Description: A SQL Server configuration parameter value
Field Name: ALLOWUPDS
Data Element: MSQCFVALUE
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 ALLOWUPDS

MSQ_DBCNFG-COSTTHRPAL table field - A SQL Server configuration parameter value ▼

Description: A SQL Server configuration parameter value
Field Name: COSTTHRPAL
Data Element: MSQCFVALUE
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 COSTTHRPAL

MSQ_DBCNFG-COSTTHRCUR table field - A SQL Server configuration parameter value ▼

Description: A SQL Server configuration parameter value
Field Name: COSTTHRCUR
Data Element: MSQCFVALUE
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 COSTTHRCUR

MSQ_DBCNFG-DEFLTLANG table field - A SQL Server configuration parameter value ▼

Description: A SQL Server configuration parameter value
Field Name: DEFLTLANG
Data Element: MSQCFVALUE
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 DEFLTLANG

MSQ_DBCNFG-DEFSORTORD table field - A SQL Server configuration parameter value ▼

Description: A SQL Server configuration parameter value
Field Name: DEFSORTORD
Data Element: MSQCFVALUE
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 DEFSORTORD

MSQ_DBCNFG-EXTMEMSIZE table field - A SQL Server configuration parameter value ▼

Description: A SQL Server configuration parameter value
Field Name: EXTMEMSIZE
Data Element: MSQCFVALUE
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 EXTMEMSIZE

MSQ_DBCNFG-SQLFILFACT table field - A SQL Server configuration parameter value ▼

Description: A SQL Server configuration parameter value
Field Name: SQLFILFACT
Data Element: MSQCFVALUE
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 SQLFILFACT

MSQ_DBCNFG-INDXCREMEM table field - Controls the amount of memory used by index creation sorts ▼

Description: Controls the amount of memory used by index creation sorts
Field Name: INDXCREMEM
Data Element: MSQCFIDXCM
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 INDXCREMEM

MSQ_DBCNFG-LANGINCACH table field - A SQL Server configuration parameter value ▼

Description: A SQL Server configuration parameter value
Field Name: LANGINCACH
Data Element: MSQCFVALUE
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 LANGINCACH

MSQ_DBCNFG-FIBERMODE table field - Controls whether SQL Server runs in fiber or thread mode ▼

Description: Controls whether SQL Server runs in fiber or thread mode
Field Name: FIBERMODE
Data Element: MSQCFFIBER
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 FIBERMODE

MSQ_DBCNFG-SQLLOCKS table field - Controls the maximum number of available locks ▼

Description: Controls the maximum number of available locks
Field Name: SQLLOCKS
Data Element: MSQCFLOCKS
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 SQLLOCKS

MSQ_DBCNFG-MAXASYNCIO table field - Controls the maximum number of outstanding asynch disk I/Os ▼

Description: Controls the maximum number of outstanding asynch disk I/Os
Field Name: MAXASYNCIO
Data Element: MSQCFMASIO
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 MAXASYNCIO

MSQ_DBCNFG-MAXDEGPARL table field - Controls the number of threads to use in parallel plan exec. ▼

Description: Controls the number of threads to use in parallel plan exec.
Field Name: MAXDEGPARL
Data Element: MSQCFMDOP
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 MAXDEGPARL

MSQ_DBCNFG-MAXSVRMEM table field - Controls the maximum amount of memory allocated to SQL Servr ▼

Description: Controls the maximum amount of memory allocated to SQL Servr
Field Name: MAXSVRMEM
Data Element: MSQCFMAXSM
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 MAXSVRMEM

MSQ_DBCNFG-MAXTXTRSZ table field - A SQL Server configuration parameter value ▼

Description: A SQL Server configuration parameter value
Field Name: MAXTXTRSZ
Data Element: MSQCFVALUE
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 MAXTXTRSZ

MSQ_DBCNFG-MAXWRKTHDS table field - Controls the maximum number of worker threads avail to SQL ▼

Description: Controls the maximum number of worker threads avail to SQL
Field Name: MAXWRKTHDS
Data Element: MSQCFWTHR
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 MAXWRKTHDS

MSQ_DBCNFG-MEDIARETN table field - A SQL Server configuration parameter value ▼

Description: A SQL Server configuration parameter value
Field Name: MEDIARETN
Data Element: MSQCFVALUE
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 MEDIARETN

MSQ_DBCNFG-MINSVRMEM table field - Controls the minimum amount of memory allocated to SQL Servr ▼

Description: Controls the minimum amount of memory allocated to SQL Servr
Field Name: MINSVRMEM
Data Element: MSQCFMINSM
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 MINSVRMEM

MSQ_DBCNFG-NESTTRIGS table field - A SQL Server configuration parameter value ▼

Description: A SQL Server configuration parameter value
Field Name: NESTTRIGS
Data Element: MSQCFVALUE
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 NESTTRIGS

MSQ_DBCNFG-NETPACKSZ table field - Controls the size data transfers between SQL Server/ clients ▼

Description: Controls the size data transfers between SQL Server/ clients
Field Name: NETPACKSZ
Data Element: MSQCFNETPS
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 NETPACKSZ

MSQ_DBCNFG-OPENOBJS table field - The number of open objects in SQL Server at any time ▼

Description: The number of open objects in SQL Server at any time
Field Name: OPENOBJS
Data Element: MSQCFOPOBJ
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 OPENOBJS

MSQ_DBCNFG-PRIORTYBST table field - Controls whether SQL Server should run at a higher priority ▼

Description: Controls whether SQL Server should run at a higher priority
Field Name: PRIORTYBST
Data Element: MSQCFPRYBT
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 PRIORTYBST

MSQ_DBCNFG-QRYGOVCOST table field - A SQL Server configuration parameter value ▼

Description: A SQL Server configuration parameter value
Field Name: QRYGOVCOST
Data Element: MSQCFVALUE
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 QRYGOVCOST

MSQ_DBCNFG-QUERYWAIT table field - A SQL Server configuration parameter value ▼

Description: A SQL Server configuration parameter value
Field Name: QUERYWAIT
Data Element: MSQCFVALUE
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 QUERYWAIT

MSQ_DBCNFG-RECVRYINTL table field - Maximum number of minutes that SQL Server recovers DB ▼

Description: Maximum number of minutes that SQL Server recovers DB
Field Name: RECVRYINTL
Data Element: MSQCFRECIN
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 RECVRYINTL

MSQ_DBCNFG-REMOTACCES table field - A SQL Server configuration parameter value ▼

Description: A SQL Server configuration parameter value
Field Name: REMOTACCES
Data Element: MSQCFVALUE
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 REMOTACCES

MSQ_DBCNFG-REMLOGTMOT table field - A SQL Server configuration parameter value ▼

Description: A SQL Server configuration parameter value
Field Name: REMLOGTMOT
Data Element: MSQCFVALUE
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 REMLOGTMOT

MSQ_DBCNFG-REMPROCTRX table field - A SQL Server configuration parameter value ▼

Description: A SQL Server configuration parameter value
Field Name: REMPROCTRX
Data Element: MSQCFVALUE
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 REMPROCTRX

MSQ_DBCNFG-REMQRYTMOT table field - A SQL Server configuration parameter value ▼

Description: A SQL Server configuration parameter value
Field Name: REMQRYTMOT
Data Element: MSQCFVALUE
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 REMQRYTMOT

MSQ_DBCNFG-RESRCTMOUT table field - A SQL Server configuration parameter value ▼

Description: A SQL Server configuration parameter value
Field Name: RESRCTMOUT
Data Element: MSQCFVALUE
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 RESRCTMOUT

MSQ_DBCNFG-SCANSUPROC table field - A SQL Server configuration parameter value ▼

Description: A SQL Server configuration parameter value
Field Name: SCANSUPROC
Data Element: MSQCFVALUE
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 SCANSUPROC

MSQ_DBCNFG-WORKSETSZ table field - Reserves physical memory for SQL Server ▼

Description: Reserves physical memory for SQL Server
Field Name: WORKSETSZ
Data Element: MSQCFWSS
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 WORKSETSZ

MSQ_DBCNFG-SHOWADVOPS table field - Controls whether advanced SQL Server options are shown ▼

Description: Controls whether advanced SQL Server options are shown
Field Name: SHOWADVOPS
Data Element: MSQCFADVOP
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 SHOWADVOPS

MSQ_DBCNFG-SPINCOUNTR table field - A SQL Server configuration parameter value ▼

Description: A SQL Server configuration parameter value
Field Name: SPINCOUNTR
Data Element: MSQCFVALUE
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 SPINCOUNTR

MSQ_DBCNFG-TIMESLICE table field - A SQL Server configuration parameter value ▼

Description: A SQL Server configuration parameter value
Field Name: TIMESLICE
Data Element: MSQCFVALUE
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 TIMESLICE

MSQ_DBCNFG-UNCMPSTYLE table field - A SQL Server configuration parameter value ▼

Description: A SQL Server configuration parameter value
Field Name: UNCMPSTYLE
Data Element: MSQCFVALUE
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 UNCMPSTYLE

MSQ_DBCNFG-UNCLOCID table field - A SQL Server configuration parameter value ▼

Description: A SQL Server configuration parameter value
Field Name: UNCLOCID
Data Element: MSQCFVALUE
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 UNCLOCID

MSQ_DBCNFG-USERCONNS table field - Controls the max number of simult. connections to SQL Servr ▼

Description: Controls the max number of simult. connections to SQL Servr
Field Name: USERCONNS
Data Element: MSQCFUSRCN
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 USERCONNS

MSQ_DBCNFG-USEROPTINS table field - A SQL Server configuration parameter value ▼

Description: A SQL Server configuration parameter value
Field Name: USEROPTINS
Data Element: MSQCFVALUE
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 USEROPTINS

View list of all SAP tables(S4H/ECC)

Select data from SAP table