Class SqlDatabaseScopedConfigurationOptions

Namespace

CENTREL.XIA.Configuration.Types

Assembly

CENTREL.XIA.Configuration.Types.dll

Represents the database scoped options for a SQL database. These settings apply to SQL Server 2016 and above.

public class SqlDatabaseScopedConfigurationOptions : BypassSection

Inheritance

object

BaseTypeSection

BypassSection

SqlDatabaseScopedConfigurationOptions

Inherited Members

BypassSection.Complete()

BypassSection.IsComplete

BypassSection.IsComponentDisabled

BypassSection.IsFailed

BypassSection.IsBypassed

BypassSection.IsNotAvailableOnObject

BypassSection.IsNotAvailableOnPlatform

BypassSection.IsNotInstalled

BypassSection.Status

BypassSection.StatusString

Constructors

SqlDatabaseScopedConfigurationOptions()

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

public SqlDatabaseScopedConfigurationOptions()

Properties

LegacyCardinalityEstimation

Gets or sets the legacy cardinality estimation mode. This applies to SQL Server 2016 and above.

public SqlDatabaseScopedParameterValue LegacyCardinalityEstimation { get; set; }

Property Value

SqlDatabaseScopedParameterValue

LegacyCardinalityEstimationForSecondary

Gets or sets the legacy cardinality estimation mode for secondary. This applies to SQL Server 2016 and above.

public SqlDatabaseScopedParameterValue LegacyCardinalityEstimationForSecondary { get; set; }

Property Value

SqlDatabaseScopedParameterValue

LegacyCardinalityEstimationForSecondaryString

Gets the legacy cardinality estimation mode for secondary as a human readable string. This applies to SQL Server 2016 and above.

public string LegacyCardinalityEstimationForSecondaryString { get; set; }

Property Value

string

LegacyCardinalityEstimationString

Gets the legacy cardinality estimation mode as a human readable string. This applies to SQL Server 2016 and above.

public string LegacyCardinalityEstimationString { get; set; }

Property Value

string

MaxDop

Gets or sets the maximum degree of parallelism for the database. This applies to SQL Server 2016 and above.

public int MaxDop { get; set; }

Property Value

int

MaxDopForSecondary

Gets or sets the maximum degree of parallelism for secondary for the database. This applies to SQL Server 2016 and above.

public int MaxDopForSecondary { get; set; }

Property Value

int

ParameterSniffing

Gets or sets the parameter sniffing setting. This applies to SQL Server 2016 and above.

public SqlDatabaseScopedParameterValue ParameterSniffing { get; set; }

Property Value

SqlDatabaseScopedParameterValue

ParameterSniffingForSecondary

Gets or sets the parameter sniffing setting for secondary. This applies to SQL Server 2016 and above.

public SqlDatabaseScopedParameterValue ParameterSniffingForSecondary { get; set; }

Property Value

SqlDatabaseScopedParameterValue

ParameterSniffingForSecondaryString

Gets the parameter sniffing setting for secondary as a human readable string. This applies to SQL Server 2016 and above.

public string ParameterSniffingForSecondaryString { get; set; }

Property Value

string

ParameterSniffingString

Gets the parameter sniffing setting as a human readable string. This applies to SQL Server 2016 and above.

public string ParameterSniffingString { get; set; }

Property Value

string

QueryOptimizerHotfixes

Gets or sets the query optimizer hotfixes setting. This applies to SQL Server 2016 and above.

public SqlDatabaseScopedParameterValue QueryOptimizerHotfixes { get; set; }

Property Value

SqlDatabaseScopedParameterValue

QueryOptimizerHotfixesForSecondary

Gets or sets the query optimizer hotfixes setting for secondary. This applies to SQL Server 2016 and above.

public SqlDatabaseScopedParameterValue QueryOptimizerHotfixesForSecondary { get; set; }

Property Value

SqlDatabaseScopedParameterValue

QueryOptimizerHotfixesForSecondaryString

Gets the query optimizer hotfixes setting for secondary as a human readable string. This applies to SQL Server 2016 and above.

public string QueryOptimizerHotfixesForSecondaryString { get; set; }

Property Value

string

QueryOptimizerHotfixesString

Gets the query optimizer hotfixes setting as a human readable string. This applies to SQL Server 2016 and above.

public string QueryOptimizerHotfixesString { get; set; }

Property Value

string

Methods

FromXml(string)

Returns a CENTREL.XIA.Configuration.Types.SqlDatabaseScopedConfigurationOptions class from the specified XML.

public static SqlDatabaseScopedConfigurationOptions FromXml(string xml)

Parameters

xml string

The XML representation of the object.

Returns

SqlDatabaseScopedConfigurationOptions

A CENTREL.XIA.Configuration.Types.SqlDatabaseScopedConfigurationOptions class.

ToString()

Returns the database scoped options as a human readable string.

public override string ToString()

Returns

string

The database scoped options as a human readable string.