Configuration value constants are returned by the ID property of the ConfigValue object, providing unique identification of a Microsoft® SQL Server™ configurable option, such as the resource timeout period.
For more information about setting options, see Setting Configuration Options.
In the table, the constant description is matched to content describing the option specified by the constant. For a description of the option and its maximum, minimum, and default running values, see the referenced content in SQL Server documentation.
| Constant | Value | Reference |
|---|---|---|
| SQLDMOConfig_AllowUpdates | 102 | allow updates Option |
| SQLDMOConfig_ CostThresholdForParallelism |
1538 | cost threshold for parallelism Option |
| SQLDMOConfig_CursorThreshold | 1531 | cursor threshold Option |
| SQLDMOConfig_DefaultLanguage | 124 | default language Option |
| SQLDMOConfig_DefaultSortorderId | 1123 | default sortorder id Option |
| SQLDMOConfig_FillFactor | 109 | fill factor Option |
| SQLDMOConfig_IndexCreateMem | 1505 | index create memory Option |
| SQLDMOConfig_LanguageInCache | 125 | language in cache Option |
| SQLDMOConfig_LanguageNeutral | 1126 | language neutral full-text Option |
| SQLDMOConfig_LightweightPooling | 1546 | lightweight pooling Option |
| SQLDMOConfig_Locks | 106 | locks Option |
| SQLDMOConfig_MaxAsyncIO | 502 | max async IO Option |
| SQLDMOConfig_ MaxDegreeOfParallelism |
1539 | max degree of parallelism Option |
| SQLDMOConfig_MaxMemory | 1544 | Server Memory Options |
| SQLDMOConfig_MaxTextReplSize | 1536 | max text repl size Option |
| SQLDMOConfig_MaxWorkerThreads | 503 | max worker threads Option |
| SQLDMOConfig_MediaRetention | 1537 | media retention Option |
| SQLDMOConfig_ MinMemoryPerQuery |
1540 | min memory per query Option |
| SQLDMOConfig_MinMemory | 1543 | Server Memory Options |
| SQLDMOConfig_NestedTriggers | 115 | nested triggers Option |
| SQLDMOConfig_NetworkPacketSize | 505 | network packet size Option |
| SQLDMOConfig_OpenObjects | 107 | open objects Option |
| SQLDMOConfig_PriorityBoost | 1517 | priority boost Option |
| SQLDMOConfig_ ProcessorAffinityMask |
1535 | affinity mask Option |
| SQLDMOConfig_QueryMaxTime | 1545 | query governor cost limit Option |
| SQLDMOConfig_QueryWait | 1541 | query wait Option |
| SQLDMOConfig_RecoveryInterval | 101 | recovery interval Option |
| SQLDMOConfig_RemoteAccess | 117 | remote access Option |
| SQLDMOConfig_ RemoteConnTimeout |
543 | Obsolete. |
| SQLDMOConfig_ RemoteLoginTimeout |
1519 | remote login timeout Option |
| SQLDMOConfig_RemoteProcTrans | 542 | remote proc trans Option |
| SQLDMOConfig_ RemoteQueryTimeout |
1520 | remote query timeout Option |
| SQLDMOConfig_ResourceTimeout | 1533 | resource timeout Option |
| SQLDMOConfig_SetWorkingSetSize | 1532 | set working set size Option |
| SQLDMOConfig_ ShowAdvancedOption |
518 | show advanced options Option |
| SQLDMOConfig_SpinCounter | 1514 | spin counter Option |
| SQLDMOConfig_TimeSlice | 1110 | time slice Option |
| SQLDMOConfig_TwoDigitYearCutoff | 1127 | two digit year cutoff Option |
| SQLDMOConfig_ UnicodeComparisonStyle |
1125 | Unicode comparison style Option |
| SQLDMOConfig_UnicodeLocalID | 1124 | Unicode locale ID Option |
| SQLDMOConfig_UserConnections | 103 | user connections Option |
| SQLDMOConfig_UserOptions | 1534 | user options Option |
| SQLDMOConfig_VLMSize | 1542 | extended memory size Option |