Configuration Class
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Instance class encapsulating SQL Server Configuration object
public class Configuration : Microsoft.SqlServer.Management.Smo.ConfigurationBasetype Configuration = class
inherit ConfigurationBasePublic Class Configuration
Inherits ConfigurationBase- Inheritance
Properties
| AdHocDistributedQueriesEnabled | |
| Affinity64IOMask |
Binds SQL Server disk I/O to a specified subset of CPUs. |
| Affinity64Mask | |
| AffinityIOMask | |
| AffinityMask | |
| AgentXPsEnabled | |
| AllowUpdates | |
| AweEnabled | |
| BlockedProcessThreshold |
The blocked process threshold option specifies the threshold, in seconds, at which blocked process reports are generated. The threshold can be set from 0 to 86,400. By default, no blocked process reports are produced. |
| C2AuditMode | |
| CommonCriteriaComplianceEnabled |
The "common criteria compliance enabled" server option |
| ContainmentEnabled |
Gets a ConfigProperty object that is used to enable or disable contained databases and authentication across the service instance. |
| CostThresholdForParallelism | |
| CrossDBOwnershipChaining | |
| CursorThreshold | |
| DatabaseMailEnabled | |
| DefaultBackupChecksum |
This public property gets or sets the default backup checksum value and returns a ConfigProperty object representing 'backup checksum default' server configuration. |
| DefaultBackupCompression |
This public property gets or sets the default backup compression value and returns a ConfigProperty object representing ‘backup compression default’ server configuration. |
| DefaultFullTextLanguage | |
| DefaultLanguage | |
| DefaultTraceEnabled | |
| DisallowResultsFromTriggers |
Use the disallow results from triggers option to control whether triggers return result sets. Triggers that return result sets may cause unexpected behavior in applications that are not designed to work with them. When set to 1, the disallow results from triggers option is set to ON. The default setting for this option is 0 (OFF). |
| ExtensibleKeyManagementEnabled |
The "EKM provider enabled" option is to enable creation of Cryptographic Providers |
| FilestreamAccessLevel |
This public property gets or sets the filestream access level and returns a ConfigProperty object representing 'filestream access level' server configuration. |
| FillFactor | |
| FullTextCrawlBandwidthMax |
Use the FullTextCrawlBandwidth[min,max] options to specify the size to which the pool of large memory buffers can grow. Large memory buffers are 4 megabytes (MB) in size. The FullTextCrawlBandwidthMax maximum number of buffers that the full-text memory manager should maintain in a large buffer pool. If the max value is zero, then there is no upper limit to the number of buffers that can be in a large buffer pool. |
| FullTextCrawlBandwidthMin |
Use FullTextCrawlBandwidth[min,max] options to specify the size to which the pool of large memory buffers can grow. Large memory buffers are 4 megabytes (MB) in size. The FullTextCrawlBandwidthMin parameter specifies the minimum number of memory buffers that must be maintained in the pool of large memory buffers. If, however, the min value specified is zero, then all memory buffers are released. |
| FullTextCrawlRangeMax |
Use the max full-text crawl range option to optimize CPU utilization, which improves crawl performance during a full crawl. Using this option, you can specify the number of partitions that Microsoft SQL Server should use during a full index crawl. For example, if there are many CPUs and their utilization is not optimal, you can increase the maximum value of this option. In addition to this option, SQL Server uses a number of other factors, such as the number of rows in the table and the number of CPUs, to determine the actual number of partitions used. |
| FullTextNotifyBandwidthMax |
Use the FullTextNotifyBandwidth[min, max] options to specify the size to which the pool of small memory buffers can grow. Small memory buffers are 64 kilobytes (KB) in size. The FullTextNotifyBandwidthMax parameter value specifies the maximum number of buffers that the full-text memory manager should maintain in a small buffer pool. If the max value is zero, then there is no upper limit to the number of buffers that can be in a small buffer pool. |
| FullTextNotifyBandwidthMin |
Use the FullTextNotifyBandwidth[min, max] options to specify the size to which the pool of small memory buffers can grow. Small memory buffers are 64 kilobytes(KB) in size. The FullTextNotifyBandwidthMin parameter specifies the minimum number of memory buffers that must be maintained in the pool of small memory buffers. Upon request from the Microsoft SQL Server memory manager, all extra buffer pools will be released but this minimum number of buffers will be maintained. If, however, the min value specified is zero, then all memory buffers are released. |
| IndexCreateMemory | |
| InDoubtTransactionResolution |
Use the in-doubt xact resolution option to control the default outcome of transactions that the Microsoft Distributed Transaction Coordinator (MS DTC) is unable to resolve. Inability to resolve transactions may be related to the MS DTC down time or an unknown transaction outcome at the time of recovery. 0 - No presumption. Recovery fails if MS DTC cannot resolve any in-doubt transactions. 1 - Presume commit. Any MS DTC in-doubt transactions are presumed to have committed. 2 - Presume abort. Any MS DTC in-doubt transactions are presumed to have aborted. |
| IsSqlClrEnabled | |
| LightweightPooling | |
| Locks | |
| MaxDegreeOfParallelism | |
| MaxServerMemory | |
| MaxWorkerThreads | |
| MediaRetention | |
| MinMemoryPerQuery | |
| MinServerMemory | |
| NestedTriggers | |
| NetworkPacketSize | |
| OleAutomationProceduresEnabled | |
| OpenObjects | |
| OptimizeAdhocWorkloads |
This public property gets or sets the optimize for ad hoc workloads and returns a ConfigProperty object representing 'optimize for ad hoc workloads' server configuration. |
| Parent | (Inherited from ConfigurationBase) |
| PrecomputeRank | |
| PriorityBoost | |
| Properties | |
| ProtocolHandlerTimeout | |
| QueryGovernorCostLimit | |
| QueryWait | |
| RecoveryInterval | |
| RemoteAccess | |
| RemoteDacConnectionsEnabled | |
| RemoteDataArchiveEnabled |
Use the remote data archive option to check whether databases and tables on the server can be enabled for Stretch https://msdn.microsoft.com/en-us/library/mt143175.aspx |
| RemoteLoginTimeout | |
| RemoteProcTrans | |
| RemoteQueryTimeout | |
| ReplicationMaxTextSize | |
| ReplicationXPsEnabled | |
| ScanForStartupProcedures | |
| ServerTriggerRecursionEnabled |
Use the server trigger recursion option to specify whether to allow server-level triggers to fire recursively. When this option is set to 1 (ON), server-level triggers will be allowed to fire recursively. When set to 0 (OFF), server-level triggers cannot be fired recursively. Only direct recursion is prevented when the server trigger recursion option is set to 0 (OFF). (To disable indirect recursion, set the nested triggers option to 0.) The default value for this option is 1 (ON). |
| SetWorkingSetSize | |
| ShowAdvancedOptions | |
| SmoAndDmoXPsEnabled | |
| SqlMailXPsEnabled | |
| TransformNoiseWords | |
| TwoDigitYearCutoff | |
| UserConnections | |
| UserInstancesEnabled |
The user instance enabled option that you can access through sp_configure is not supported in Microsoft SQL Server 2005. This option works only with SQL Server 2005 Express Edition (SQL Server Express). |
| UserInstanceTimeout |
The User Instance Timeout option that you can access through sp_configure is not supported in Microsoft SQL Server 2005. This option works only with SQL Server 2005 Express Edition (SQL Server Express). |
| UserOptions | |
| WebXPsEnabled | |
| XPCmdShellEnabled | |
Methods
| Alter() | (Inherited from ConfigurationBase) |
| Alter(Boolean) | (Inherited from ConfigurationBase) |
| Refresh() | (Inherited from ConfigurationBase) |