Configuration Configuration Configuration Class

Definition

Instance class encapsulating SQL Server Configuration object

public class Configuration : Microsoft.SqlServer.Management.Smo.ConfigurationBase
type Configuration = class
    inherit ConfigurationBase
Public Class Configuration
Inherits ConfigurationBase
Inheritance

Properties

AdHocDistributedQueriesEnabled AdHocDistributedQueriesEnabled AdHocDistributedQueriesEnabled
Affinity64IOMask Affinity64IOMask Affinity64IOMask

Binds SQL Server disk I/O to a specified subset of CPUs.
Use AffinityIOMask to bind the first 32 processors, and use Affinity64IOMask to bind the remaining processors on the computer. Only available on 64-bit version of SQL Server.

Affinity64Mask Affinity64Mask Affinity64Mask
AffinityIOMask AffinityIOMask AffinityIOMask
AffinityMask AffinityMask AffinityMask
AgentXPsEnabled AgentXPsEnabled AgentXPsEnabled
AllowUpdates AllowUpdates AllowUpdates
AweEnabled AweEnabled AweEnabled
BlockedProcessThreshold BlockedProcessThreshold 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 C2AuditMode C2AuditMode
CommonCriteriaComplianceEnabled CommonCriteriaComplianceEnabled CommonCriteriaComplianceEnabled

The "common criteria compliance enabled" server option

ContainmentEnabled ContainmentEnabled ContainmentEnabled

Gets a ConfigProperty object that is used to enable or disable contained databases and authentication across the service instance.

CostThresholdForParallelism CostThresholdForParallelism CostThresholdForParallelism
CrossDBOwnershipChaining CrossDBOwnershipChaining CrossDBOwnershipChaining
CursorThreshold CursorThreshold CursorThreshold
DatabaseMailEnabled DatabaseMailEnabled DatabaseMailEnabled
DefaultBackupCompression DefaultBackupCompression DefaultBackupCompression

This public property gets or sets the default backup compression value and returns a ConfigProperty object representing ‘backup compression default’ server configuration.

DefaultFullTextLanguage DefaultFullTextLanguage DefaultFullTextLanguage
DefaultLanguage DefaultLanguage DefaultLanguage
DefaultTraceEnabled DefaultTraceEnabled DefaultTraceEnabled
DisallowResultsFromTriggers DisallowResultsFromTriggers 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 ExtensibleKeyManagementEnabled ExtensibleKeyManagementEnabled

The "EKM provider enabled" option is to enable creation of Cryptographic Providers

FilestreamAccessLevel FilestreamAccessLevel FilestreamAccessLevel

This public property gets or sets the filestream access level and returns a ConfigProperty object representing 'filestream access level' server configuration.

FillFactor FillFactor FillFactor
FullTextCrawlBandwidthMax FullTextCrawlBandwidthMax 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 FullTextCrawlBandwidthMin 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 FullTextCrawlRangeMax 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 FullTextNotifyBandwidthMax 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 FullTextNotifyBandwidthMin 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 IndexCreateMemory IndexCreateMemory
InDoubtTransactionResolution InDoubtTransactionResolution 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 IsSqlClrEnabled IsSqlClrEnabled
LightweightPooling LightweightPooling LightweightPooling
Locks Locks Locks
MaxDegreeOfParallelism MaxDegreeOfParallelism MaxDegreeOfParallelism
MaxServerMemory MaxServerMemory MaxServerMemory
MaxWorkerThreads MaxWorkerThreads MaxWorkerThreads
MediaRetention MediaRetention MediaRetention
MinMemoryPerQuery MinMemoryPerQuery MinMemoryPerQuery
MinServerMemory MinServerMemory MinServerMemory
NestedTriggers NestedTriggers NestedTriggers
NetworkPacketSize NetworkPacketSize NetworkPacketSize
OleAutomationProceduresEnabled OleAutomationProceduresEnabled OleAutomationProceduresEnabled
OpenObjects OpenObjects OpenObjects
OptimizeAdhocWorkloads OptimizeAdhocWorkloads 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 Parent Parent Inherited from ConfigurationBase
PrecomputeRank PrecomputeRank PrecomputeRank
PriorityBoost PriorityBoost PriorityBoost
Properties Properties Properties
ProtocolHandlerTimeout ProtocolHandlerTimeout ProtocolHandlerTimeout
QueryGovernorCostLimit QueryGovernorCostLimit QueryGovernorCostLimit
QueryWait QueryWait QueryWait
RecoveryInterval RecoveryInterval RecoveryInterval
RemoteAccess RemoteAccess RemoteAccess
RemoteDacConnectionsEnabled RemoteDacConnectionsEnabled RemoteDacConnectionsEnabled
RemoteDataArchiveEnabled RemoteDataArchiveEnabled 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 RemoteLoginTimeout RemoteLoginTimeout
RemoteProcTrans RemoteProcTrans RemoteProcTrans
RemoteQueryTimeout RemoteQueryTimeout RemoteQueryTimeout
ReplicationMaxTextSize ReplicationMaxTextSize ReplicationMaxTextSize
ReplicationXPsEnabled ReplicationXPsEnabled ReplicationXPsEnabled
ScanForStartupProcedures ScanForStartupProcedures ScanForStartupProcedures
ServerTriggerRecursionEnabled ServerTriggerRecursionEnabled 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 SetWorkingSetSize SetWorkingSetSize
ShowAdvancedOptions ShowAdvancedOptions ShowAdvancedOptions
SmoAndDmoXPsEnabled SmoAndDmoXPsEnabled SmoAndDmoXPsEnabled
SqlMailXPsEnabled SqlMailXPsEnabled SqlMailXPsEnabled
TransformNoiseWords TransformNoiseWords TransformNoiseWords
TwoDigitYearCutoff TwoDigitYearCutoff TwoDigitYearCutoff
UserConnections UserConnections UserConnections
UserInstancesEnabled UserInstancesEnabled 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 UserInstanceTimeout 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 UserOptions UserOptions
WebXPsEnabled WebXPsEnabled WebXPsEnabled
XPCmdShellEnabled XPCmdShellEnabled XPCmdShellEnabled

Methods

Alter() Alter() Alter() Inherited from ConfigurationBase
Alter(Boolean) Alter(Boolean) Alter(Boolean) Inherited from ConfigurationBase
Refresh() Refresh() Refresh() Inherited from ConfigurationBase

Applies to