sys-database-automatic-tuning-mode-transact-sql.md

title	sys.database_automatic_tuning_mode (Transact-SQL)
description	Learn how to view automatic tuning mode on SQL Server or Azure SQL Database.
author	danimir
ms.author	danil
ms.reviewer	wiassaf
ms.date	07/06/2021
ms.prod	sql
ms.prod_service	database-engine, sql-database
ms.technology	system-objects
ms.topic	reference
f1_keywords	database_automatic_tuning_mode_tsql database_automatic_tuning_mode sys.database_automatic_tuning_mode_tsql sys.database_automatic_tuning_mode
helpviewer_keywords	database_automatic_tuning_mode catalog view sys.database_automatic_tuning_mode catalog view
dev_langs	TSQL
monikerRange	=azuresqldb-current||>=sql-server-2017||>=sql-server-linux-2017||=azuresqldb-mi-current

sys.database_automatic_tuning_mode (Transact-SQL)

[!INCLUDEsqlserver2017-asdb-asdbmi]

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

Column name	Data type	Description
desired_state	smallint	Desired state of the Automatic Tuning mode.
desired_state_desc	nvarchar(60)	Textual description of the desired operation mode of Automatic Tuning.
actual_state	smallint	Indicates the operation mode of Automatic Tuning mode.
actual_state_desc	nvarchar(60)	Textual description of the actual operation mode of Automatic Tuning.

Permissions

Requires the VIEW DATABASE STATE permission.

See also

• Automatic Tuning
• ALTER DATABASE SET AUTOMATIC_TUNING (Transact-SQL)
• sys.database_query_store_options (Transact-SQL)
• sys.dm_db_tuning_recommendations (Transact-SQL)
• sys.database_automatic_tuning_options