| 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. |