sys.database_automatic_tuning_mode

Description

2017 (14.x) and later versions SQL database in Microsoft Fabric Returns the automatic tuning mode for this database. Refer to AUTOMATIC_TUNING (Transact-SQL) Desired state of the automatic tuning mode. Textual description of the desired operation mode of automatic Indicates the operation mode of automatic tuning mode. Textual description of the actual operation mode of automatic ALTER DATABASE SET AUTOMATIC_TUNING (Transact-SQL)

Permissions

Code Blocks

VIEW DATABASE STATE