Table of Contents

Class DatabasesAndFilesSchema.DatabaseAutomaticTuningOption

Namespace
LinqToDB.Tools.DataProvider.SqlServer.Schemas
Assembly
linq2db.Tools.dll

sys.database\_automatic\_tuning_options (Transact-SQL)

Applies to: √ SQL Server 2017 (14.x) and later √ Azure SQL Database √ Azure SQL Managed Instance

Returns the Automatic Tuning options for this database.


See sys.database_automatic_tuning_options.

[Table(Schema = "sys", Name = "database_automatic_tuning_options", IsView = true)]
public class DatabasesAndFilesSchema.DatabaseAutomaticTuningOption
Inheritance
DatabasesAndFilesSchema.DatabaseAutomaticTuningOption
Extension Methods

Properties

ActualState

Indicates the operation mode of Automatic Tuning option.
0 = OFF
1 = ON

[Column("actual_state")]
[Nullable]
public short? ActualState { get; set; }

Property Value

short?

ActualStateDesc

Textual description of the actual operation mode of Automatic Tuning option.
OFF
ON

[Column("actual_state_desc")]
[Nullable]
public string? ActualStateDesc { get; set; }

Property Value

string

DesiredState

Indicates the desired operation mode for Automatic Tuning option, explicitly set by user.
0 = OFF
1 = ON

[Column("desired_state")]
[Nullable]
public short? DesiredState { get; set; }

Property Value

short?

DesiredStateDesc

Textual description of the desired operation mode of Automatic Tuning option.
OFF
ON

[Column("desired_state_desc")]
[Nullable]
public string? DesiredStateDesc { get; set; }

Property Value

string

Name

The name of the automatic tuning option. Refer to ALTER DATABASE SET AUTOMATIC_TUNING (Transact-SQL) for available options.

[Column("name")]
[Nullable]
public string? Name { get; set; }

Property Value

string

Reason

Indicates why actual and desired states are different.
2 = DISABLED
11 = QUERY_STORE_OFF
12 = QUERY_STORE_READ_ONLY
13 = NOT_SUPPORTED

[Column("reason")]
[Nullable]
public short? Reason { get; set; }

Property Value

short?

ReasonDesc

Textual description of the reason why actual and desired states are different.
DISABLED = Option is disabled by system
QUERY_STORE_OFF = Query Store is turned off
QUERY_STORE_READ_ONLY = Query Store is in read-only mode
NOT_SUPPORTED = Available only in SQL Server Enterprise edition

[Column("reason_desc")]
[Nullable]
public string? ReasonDesc { get; set; }

Property Value

string