Class SqlServerAdvancedProperties

Namespace

CENTREL.XIA.Configuration.Types

Assembly

CENTREL.XIA.Configuration.Types.dll

Represents the server advanced properties of a SQL instance.

public class SqlServerAdvancedProperties : BypassSection

Inheritance

object

BaseTypeSection

BypassSection

SqlServerAdvancedProperties

Inherited Members

BypassSection.Complete()

BypassSection.IsComplete

BypassSection.IsComponentDisabled

BypassSection.IsFailed

BypassSection.IsBypassed

BypassSection.IsNotAvailableOnObject

BypassSection.IsNotAvailableOnPlatform

BypassSection.IsNotInstalled

BypassSection.Status

BypassSection.StatusString

Constructors

SqlServerAdvancedProperties()

Initializes a new instance of the CENTREL.XIA.Configuration.Types.SqlServerAdvancedProperties class.

public SqlServerAdvancedProperties()

Properties

BlockedProcessThreshold

Gets or sets the blocked process threshold.

public int BlockedProcessThreshold { get; set; }

Property Value

int

ContainmentEnabled

Gets or sets whether contained databases are enabled. This applies to SQL Server 2012 and above.

public BooleanOption ContainmentEnabled { get; set; }

Property Value

BooleanOption

CostThresholdForParallelism

Gets or sets the cost threshold for parallelism.

public int CostThresholdForParallelism { get; set; }

Property Value

int

CursorThreshold

Gets or sets the cursor threshold.

public int CursorThreshold { get; set; }

Property Value

int

DefaultFullTextLanguage

Gets or sets the default full text language.

public int DefaultFullTextLanguage { get; set; }

Property Value

int

DefaultLanguage

Gets or sets the default language LangID.

public int DefaultLanguage { get; set; }

Property Value

int

DefaultLanguageName

Gets or sets the name of the default language.

public string DefaultLanguageName { get; set; }

Property Value

string

FilestreamEffectiveLevel

Gets or sets the access level for the FILESTREAM feature. This only applies to on-premises SQL Server installations.

public SqlFilestreamAccessLevel FilestreamEffectiveLevel { get; set; }

Property Value

SqlFilestreamAccessLevel

FilestreamEffectiveLevelString

Gets the access level for the FILESTREAM feature as a human readable string. This only applies to on-premises SQL Server installations.

public string FilestreamEffectiveLevelString { get; set; }

Property Value

string

FilestreamShareName

Gets the filestream share name. This applies to on-premises SQL Server 2012 and above.

public string FilestreamShareName { get; set; }

Property Value

string

FullTextUpgradeOption

Gets or sets the full-text upgrade option.

public SqlFullTextCatalogUpgradeOption FullTextUpgradeOption { get; set; }

Property Value

SqlFullTextCatalogUpgradeOption

FullTextUpgradeOptionString

Gets the full-text upgrade option.

public string FullTextUpgradeOptionString { get; set; }

Property Value

string

LightweightPooling

Gets or sets whether to use Windows fibers (lightweight pooling).

public BooleanOption LightweightPooling { get; set; }

Property Value

BooleanOption

Locks

Gets or sets the maximum number of available locks.

public int Locks { get; set; }

Property Value

int

MaxDegreeOfParallelism

Gets or sets the maximum number of processors to use in parallel plan execution.

public int MaxDegreeOfParallelism { get; set; }

Property Value

int

NestedTriggers

Gets or sets whether to allow triggers to fire others.

public BooleanOption NestedTriggers { get; set; }

Property Value

BooleanOption

NetworkPacketSize

Gets or sets the network packet size.

public int NetworkPacketSize { get; set; }

Property Value

int

OptimizeAdhocWorkloads

Gets or sets whether the instance should be optimized for adhoc workloads.

public BooleanOption OptimizeAdhocWorkloads { get; set; }

Property Value

BooleanOption

PriorityBoost

Gets or sets whether to boost SQL server priority.

public BooleanOption PriorityBoost { get; set; }

Property Value

BooleanOption

QueryWait

Gets or sets the time in seconds that a query waits for resources before timing out.

public int QueryWait { get; set; }

Property Value

int

RemoteLoginTimeout

Gets or sets the remote login timeout.

public int RemoteLoginTimeout { get; set; }

Property Value

int

ReplicationMaxTextSize

Gets or sets the maximum text replication size.

public int ReplicationMaxTextSize { get; set; }

Property Value

int

ScanForStartupProcedures

Gets or sets whether to scan for startup procedures.

public BooleanOption ScanForStartupProcedures { get; set; }

Property Value

BooleanOption

TwoDigitYearCutoff

Gets or sets the two digit year cutoff value.

public int TwoDigitYearCutoff { get; set; }

Property Value

int

Methods

ToString()

Returns the advanced properties as a human readable string.

public override string ToString()

Returns

string

The advanced properties as a human readable string.