Supported SQL Server Configuration Options

From DBArtisan
Jump to: navigation, search

Go Up to Parameters, Arguments, Options, and Variables Appendix

The following options are available from the Explorer’s Configuration node. For information on working with these options, see Working with Configuration/initialization Parameters.

access check cache bucket count

access check cache quota

Ad Hoc Distributed Queries

affinity I/O mask

affinity mask

Agent XPs

allow updates

awe enabled

backup compression default

blocked process threshold

c2 audit mode

clr enabled

common criteria compliance enabled

cost threshold for parallelism

cross db ownership chaining

cursor threshold

Database Mail XPs 0 0 0 1 Yes

default full-text language

default language

default trace enabled

disallow results from triggers

EKM provider enabled

filestream access level

fill factor (%)

ft crawl bandwidth (max)

ft crawl bandwidth (min)

ft notify bandwidth (max)

ft notify bandwidth (min)

index create memory (KB)

in-doubt xact resolution

lightweight pooling 0 0 0 1 No

locks 0 0 5000 2147483647 No

max degree of parallelism

max full-text crawl range

max server memory (MB)

max text repl size (B)

max worker threads

media retention

min memory per query (KB)

min server memory (MB

nested triggers

network packet size (B)

Ole Automation Procedures

open objects

optimize for ad hoc workloads

PH timeout (s)

precompute rank

priority boost

query governor cost limit

query wait (s)

recovery interval (min)

remote access

remote admin connections

remote login timeout (s)

remote proc trans

remote query timeout (s)

Replication XPs

scan for startup procs

server trigger recursion

set working set size

show advanced options


SQL Mail XPs 0 0 0 1

transform noise words 0 0 0 1

two digit year cutoff

user connections

user options