SAP ABAP Table MSQ_DBCNFG (Contains the SQL server parameter values)
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
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 | MSQ_DBCNFG |
Table Relationship Diagram 
|
| Short Description | Contains the SQL server parameter values |
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 |  AFFMASK |
MSQCFAFMSK | INT4 | INT4 | 10 | 0 | Controls which processors SQL Server runs on | ||
| 2 | ALLOWUPDS |
MSQCFVALUE | INT4 | INT4 | 10 | 0 | A SQL Server configuration parameter value | ||
| 3 | COSTTHRPAL |
MSQCFVALUE | INT4 | INT4 | 10 | 0 | A SQL Server configuration parameter value | ||
| 4 | COSTTHRCUR |
MSQCFVALUE | INT4 | INT4 | 10 | 0 | A SQL Server configuration parameter value | ||
| 5 | DEFLTLANG |
MSQCFVALUE | INT4 | INT4 | 10 | 0 | A SQL Server configuration parameter value | ||
| 6 | DEFSORTORD |
MSQCFVALUE | INT4 | INT4 | 10 | 0 | A SQL Server configuration parameter value | ||
| 7 | EXTMEMSIZE |
MSQCFVALUE | INT4 | INT4 | 10 | 0 | A SQL Server configuration parameter value | ||
| 8 | SQLFILFACT |
MSQCFVALUE | INT4 | INT4 | 10 | 0 | A SQL Server configuration parameter value | ||
| 9 | INDXCREMEM |
MSQCFIDXCM | INT4 | INT4 | 10 | 0 | Controls the amount of memory used by index creation sorts | ||
| 10 | LANGINCACH |
MSQCFVALUE | INT4 | INT4 | 10 | 0 | A SQL Server configuration parameter value | ||
| 11 | FIBERMODE |
MSQCFFIBER | CHAR1 | CHAR | 1 | 0 | Controls whether SQL Server runs in fiber or thread mode | ||
| 12 | SQLLOCKS |
MSQCFLOCKS | INT4 | INT4 | 10 | 0 | Controls the maximum number of available locks | ||
| 13 | MAXASYNCIO |
MSQCFMASIO | INT4 | INT4 | 10 | 0 | Controls the maximum number of outstanding asynch disk I/Os | ||
| 14 | MAXDEGPARL |
MSQCFMDOP | INT4 | INT4 | 10 | 0 | Controls the number of threads to use in parallel plan exec. | ||
| 15 | MAXSVRMEM |
MSQCFMAXSM | INT4 | INT4 | 10 | 0 | Controls the maximum amount of memory allocated to SQL Servr | ||
| 16 | MAXTXTRSZ |
MSQCFVALUE | INT4 | INT4 | 10 | 0 | A SQL Server configuration parameter value | ||
| 17 | MAXWRKTHDS |
MSQCFWTHR | INT4 | INT4 | 10 | 0 | Controls the maximum number of worker threads avail to SQL | ||
| 18 | MEDIARETN |
MSQCFVALUE | INT4 | INT4 | 10 | 0 | A SQL Server configuration parameter value | ||
| 19 | MINSVRMEM |
MSQCFMINSM | INT4 | INT4 | 10 | 0 | Controls the minimum amount of memory allocated to SQL Servr | ||
| 20 | NESTTRIGS |
MSQCFVALUE | INT4 | INT4 | 10 | 0 | A SQL Server configuration parameter value | ||
| 21 | NETPACKSZ |
MSQCFNETPS | INT4 | INT4 | 10 | 0 | Controls the size data transfers between SQL Server/ clients | ||
| 22 | OPENOBJS |
MSQCFOPOBJ | INT4 | INT4 | 10 | 0 | The number of open objects in SQL Server at any time | ||
| 23 | PRIORTYBST |
MSQCFPRYBT | INT4 | INT4 | 10 | 0 | Controls whether SQL Server should run at a higher priority | ||
| 24 | QRYGOVCOST |
MSQCFVALUE | INT4 | INT4 | 10 | 0 | A SQL Server configuration parameter value | ||
| 25 | QUERYWAIT |
MSQCFVALUE | INT4 | INT4 | 10 | 0 | A SQL Server configuration parameter value | ||
| 26 | RECVRYINTL |
MSQCFRECIN | INT4 | INT4 | 10 | 0 | Maximum number of minutes that SQL Server recovers DB | ||
| 27 | REMOTACCES |
MSQCFVALUE | INT4 | INT4 | 10 | 0 | A SQL Server configuration parameter value | ||
| 28 | REMLOGTMOT |
MSQCFVALUE | INT4 | INT4 | 10 | 0 | A SQL Server configuration parameter value | ||
| 29 | REMPROCTRX |
MSQCFVALUE | INT4 | INT4 | 10 | 0 | A SQL Server configuration parameter value | ||
| 30 | REMQRYTMOT |
MSQCFVALUE | INT4 | INT4 | 10 | 0 | A SQL Server configuration parameter value | ||
| 31 | RESRCTMOUT |
MSQCFVALUE | INT4 | INT4 | 10 | 0 | A SQL Server configuration parameter value | ||
| 32 | SCANSUPROC |
MSQCFVALUE | INT4 | INT4 | 10 | 0 | A SQL Server configuration parameter value | ||
| 33 | WORKSETSZ |
MSQCFWSS | INT4 | INT4 | 10 | 0 | Reserves physical memory for SQL Server | ||
| 34 | SHOWADVOPS |
MSQCFADVOP | INT4 | INT4 | 10 | 0 | Controls whether advanced SQL Server options are shown | ||
| 35 | SPINCOUNTR |
MSQCFVALUE | INT4 | INT4 | 10 | 0 | A SQL Server configuration parameter value | ||
| 36 | TIMESLICE |
MSQCFVALUE | INT4 | INT4 | 10 | 0 | A SQL Server configuration parameter value | ||
| 37 | UNCMPSTYLE |
MSQCFVALUE | INT4 | INT4 | 10 | 0 | A SQL Server configuration parameter value | ||
| 38 | UNCLOCID |
MSQCFVALUE | INT4 | INT4 | 10 | 0 | A SQL Server configuration parameter value | ||
| 39 | USERCONNS |
MSQCFUSRCN | INT4 | INT4 | 10 | 0 | Controls the max number of simult. connections to SQL Servr | ||
| 40 | USEROPTINS |
MSQCFVALUE | INT4 | INT4 | 10 | 0 | A SQL Server configuration parameter value |
History
| Last changed by/on | SAP | 20110908 |
| SAP Release Created in |
