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
Configuration

Properties

AdHocDistributedQueriesEnabled
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
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)

Applies to