Class DatabasesAndFilesSchema.DatabaseAutomaticTuningMode

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

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

Returns the Automatic Tuning mode for this database. Refer to ALTER DATABASE SET AUTOMATIC_TUNING (Transact-SQL) for available options.

[Table(Schema = "sys", Name = "database_automatic_tuning_mode", IsView = true)]
public class DatabasesAndFilesSchema.DatabaseAutomaticTuningMode

Properties

Indicates the operation mode of Automatic Tuning mode.

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

Textual description of the actual operation mode of Automatic Tuning.

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

Desired state of the Automatic Tuning mode.

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

Textual description of the desired operation mode of Automatic Tuning.

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