---
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)
[!INCLUDE[sqlserver2017-asdb-asdbmi](../../includes/applies-to-version/sqlserver2017-asdb-asdbmi.md)]

  Returns the Automatic Tuning mode for this database. Refer to [ALTER DATABASE SET AUTOMATIC_TUNING (Transact-SQL)](../../t-sql/statements/alter-database-transact-sql-set-options.md#auto_tuning) 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](../../relational-databases/automatic-tuning/automatic-tuning.md)   
 - [ALTER DATABASE SET AUTOMATIC_TUNING (Transact-SQL)](../../t-sql/statements/alter-database-transact-sql-set-options.md)   
 - [sys.database_query_store_options (Transact-SQL)](../../relational-databases/system-catalog-views/sys-database-query-store-options-transact-sql.md)   
 - [sys.dm_db_tuning_recommendations (Transact-SQL)](../../relational-databases/system-dynamic-management-views/sys-dm-db-tuning-recommendations-transact-sql.md)   
 - [sys.database_automatic_tuning_options](../../relational-databases/system-catalog-views/sys-database-automatic-tuning-options-transact-sql.md)