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 option in the 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
|
Obsolete
|
|
SQLDMOConfig_FillFactor
|
109
|
fill factor Option
|
|
SQLDMOConfig_IndexCreateMem
|
1505
|
index create memory Option
|
|
SQLDMOConfig_LanguageInCache
|
125
|
Obsolete
|
|
SQLDMOConfig_LanguageNeutral
|
1126
|
default full-text language Option
|
|
SQLDMOConfig_LightweightPooling
|
1546
|
lightweight pooling Option
|
|
SQLDMOConfig_Locks
|
106
|
locks Option
|
|
SQLDMOConfig_MaxAsyncIO
|
502
|
Obsolete
|
|
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
|
Obsolete
|
|
SQLDMOConfig_SetWorkingSetSize
|
1532
|
set working set size Option
|
|
SQLDMOConfig_/ShowAdvancedOption
|
518
|
show advanced options Option
|
|
SQLDMOConfig_SpinCounter
|
1514
|
Obsolete
|
|
SQLDMOConfig_TimeSlice
|
1110
|
Obsolete
|
|
SQLDMOConfig_/TwoDigitYearCutoff
|
1127
|
two digit year cutoff Option
|
|
SQLDMOConfig_/UnicodeComparisonStyle
|
1125
|
Obsolete
|
|
SQLDMOConfig_UnicodeLocalID
|
1124
|
Obsolete
|
|
SQLDMOConfig_UserConnections
|
103
|
user connections Option
|
|
SQLDMOConfig_UserOptions
|
1534
|
user options Option
|
|
SQLDMOConfig_VLMSize
|
1542
|
Obsolete
|