# List of Server Parameters

Parameter | Value | Description
--- | --- | ---
affinity I/O mask | 0 | affinity I/O mask
affinity mask | 0 | affinity mask
affinity64 I/O mask | 0 | affinity64 I/O mask
affinity64 mask | 0 | affinity64 mask
cross db ownership chaining | 0 | Allow cross db ownership chaining
server trigger recursion | 1 | Allow recursion for server level triggers
remote access | 1 | Allow remote access
nested triggers | 1 | Allow triggers to be invoked within triggers
allow updates | 0 | Allow updates to system tables
awe enabled | 0 | AWE enabled in the server
blocked process threshold (s) | 0 | Blocked process reporting threshold
c2 audit mode | 0 | c2 audit mode
clr enabled | 0 | CLR user code execution enabled in the server
common criteria compliance enabled | 0 | Common Criteria compliance mode enabled
cost threshold for parallelism | 5 | cost threshold for parallelism
remote proc trans | 0 | Create DTC transaction for remote procedures
cursor threshold | -1 | cursor threshold
PH timeout (s) | 60 | DB connection timeout for full-text protocol handler (s)
remote admin connections | 0 | Dedicated Admin Connections are allowed from remote clients
fill factor (%) | 0 | Default fill factor percentage
default full-text language | 1033 | default full-text language
access check cache bucket count | 0 | Default hash bucket count for the access check result security cache
default language | 0 | default language
access check cache quota | 0 | Default quota for the access check result security cache
disallow results from triggers | 0 | Disallow returning results from triggers
backup compression default | 0 | Enable compression of backups by default
Ad Hoc Distributed Queries | 0 | Enable or disable Ad Hoc Distributed Queries
Agent XPs | 1 | Enable or disable Agent XPs
xp_cmdshell | 0 | Enable or disable command shell
Database Mail XPs | 0 | Enable or disable Database Mail XPs
EKM provider enabled | 0 | Enable or disable EKM provider
Ole Automation Procedures | 0 | Enable or disable Ole Automation Procedures
Replication XPs | 0 | Enable or disable Replication XPs
SMO and DMO XPs | 1 | Enable or disable SMO and DMO XPs
SQL Mail XPs | 0 | Enable or disable SQL Mail XPs
default trace enabled | 1 | Enable or disable the default trace
ft crawl bandwidth (max) | 100 | Max number of full-text crawl buffers
ft notify bandwidth (max) | 100 | Max number of full-text notifications buffers
max full-text crawl range | 4 | Maximum crawl ranges allowed in full-text indexing
max degree of parallelism | 0 | maximum degree of parallelism
query governor cost limit | 0 | Maximum estimated cost allowed by query governor
recovery interval (min) | 0 | Maximum recovery interval in minutes
max text repl size (B) | 65536 | Maximum size of a text field in replication.
max server memory (MB) | 2147483647 | Maximum size of server memory (MB)
query wait (s) | -1 | maximum time to wait for query memory (s)
max worker threads | 0 | Maximum worker threads
index create memory (KB) | 0 | Memory for index create sorts (kBytes)
min memory per query (KB) | 1024 | minimum memory per query (kBytes)
min server memory (MB) | 16 | Minimum size of server memory (MB)
network packet size (B) | 4096 | Network packet size
locks | 0 | Number of locks for all users
open objects | 0 | Number of open database objects
ft crawl bandwidth (min) | 0 | Number of reserved full-text crawl buffers
ft notify bandwidth (min) | 0 | Number of reserved full-text notifications buffers
user connections | 0 | Number of user connections allowed
priority boost | 0 | Priority boost
in-doubt xact resolution | 0 | Recovery policy for DTC transactions with unknown outcome
remote login timeout (s) | 20 | remote login timeout
remote query timeout (s) | 600 | remote query timeout
scan for startup procs | 0 | scan for startup stored procedures
set working set size | 0 | set working set size
filestream access level | 2 | Sets the FILESTREAM access level
show advanced options | 1 | show advanced options
media retention | 0 | Tape retention period in days
transform noise words | 0 | Transform noise words for full-text query
two digit year cutoff | 2049 | two digit year cutoff
precompute rank | 0 | Use precomputed rank for full-text query
lightweight pooling | 0 | User mode scheduler uses lightweight pooling
user options | 0 | user options
optimize for ad hoc workloads | 0 | When this option is set, plan cache size is further reduced for single-use adhoc OLTP workload.

#### See also

List of Server Properties