Class SqlDatabaseQueryStoreSettings

Namespace

CENTREL.XIA.Configuration.Types

Assembly

CENTREL.XIA.Configuration.Types.dll

The query store settings for the database. This applies to Azure and on-premises SQL Server 2016 and above.

public class SqlDatabaseQueryStoreSettings : BypassSection

Inheritance

object

BaseTypeSection

BypassSection

SqlDatabaseQueryStoreSettings

Inherited Members

BypassSection.Complete()

BypassSection.IsComplete

BypassSection.IsComponentDisabled

BypassSection.IsFailed

BypassSection.IsBypassed

BypassSection.IsNotAvailableOnObject

BypassSection.IsNotAvailableOnPlatform

BypassSection.IsNotInstalled

BypassSection.Status

BypassSection.StatusString

Constructors

SqlDatabaseQueryStoreSettings()

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

public SqlDatabaseQueryStoreSettings()

Properties

CaptureMode

Gets or sets the query store capture mode.

public SqlDatabaseQueryStoreCaptureMode CaptureMode { get; set; }

Property Value

SqlDatabaseQueryStoreCaptureMode

CaptureModeString

Gets or sets the query store capture mode as a human readable string.

public string CaptureModeString { get; set; }

Property Value

string

DataFlushInterval

Gets or sets the data flush interval in minutes.

public int DataFlushInterval { get; set; }

Property Value

int

MaxPlansPerQuery

Gets or sets the maximum number of plans per query.

public long MaxPlansPerQuery { get; set; }

Property Value

long

MaxStorageSize

Gets or sets the maximum storage size in MB.

public long MaxStorageSize { get; set; }

Property Value

long

OperationModeActual

Gets or sets the actual query store operation mode.

public SqlDatabaseQueryStoreOperationMode OperationModeActual { get; set; }

Property Value

SqlDatabaseQueryStoreOperationMode

OperationModeActualString

Gets the actual query store operation mode as a human readable string.

public string OperationModeActualString { get; set; }

Property Value

string

OperationModeRequested

Gets or sets the requested query store operation mode.

public SqlDatabaseQueryStoreOperationMode OperationModeRequested { get; set; }

Property Value

SqlDatabaseQueryStoreOperationMode

OperationModeRequestedString

Gets the requested query store operation mode as a human readable string.

public string OperationModeRequestedString { get; set; }

Property Value

string

SizeBasedCleanupMode

Gets or sets the sized based clean up mode.

public SqlDatabaseQueryStoreSizeBasedCleanupMode SizeBasedCleanupMode { get; set; }

Property Value

SqlDatabaseQueryStoreSizeBasedCleanupMode

SizeBasedCleanupModeString

Gets the sized based clean up mode as a human readable string.

public string SizeBasedCleanupModeString { get; set; }

Property Value

string

StaleQueryThreshold

Gets or sets the stale query threshold in days.

public long StaleQueryThreshold { get; set; }

Property Value

long

StatisticsCollectionInterval

Gets or sets the statistics collection interval in minutes.

public long StatisticsCollectionInterval { get; set; }

Property Value

long

StatisticsCollectionIntervalString

Gets the statistics collection interval as a human readable string.

public string StatisticsCollectionIntervalString { get; set; }

Property Value

string

Methods

FromXml(string)

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

public static SqlDatabaseQueryStoreSettings FromXml(string xml)

Parameters

xml string

The XML representation of the object.

Returns

SqlDatabaseQueryStoreSettings

A CENTREL.XIA.Configuration.Types.SqlDatabaseQueryStoreSettings class.

ToString()

Returns the query store settings as a human readable string.

public override string ToString()

Returns

string

The query store settings as a human readable string.