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.
Column name | Data type | Description |
---|---|---|
name | nvarchar(128) | The name of the automatic tuning option. Refer to ALTER DATABASE SET AUTOMATIC_TUNING (Transact-SQL) for available options. |
desired_state | smallint | Indicates the desired operation mode for automatic tuning option, explicitly set by user. 0 = OFF 1 = ON 2 = DEFAULT |
desired_state_desc | nvarchar(60) | Textual description of the desired operation mode of automatic tuning option. OFF ON DEFAULT |
actual_state | smallint | Indicates the operation mode of automatic tuning option. 0 = OFF 1 = ON |
actual_state_desc | nvarchar(60) | Textual description of the actual operation mode of automatic tuning option. OFF ON |
reason | smallint | Indicates why actual and desired states are different. 2 = DISABLED 11 = QUERY_STORE_OFF 12 = QUERY_STORE_READ_ONLY 13 = NOT_SUPPORTED |
reason_desc | nvarchar(60) | 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 |
Permissions
Requires the VIEW DATABASE STATE
permission.
See also
Σχόλια
https://aka.ms/ContentUserFeedback.
Σύντομα διαθέσιμα: Καθ' όλη τη διάρκεια του 2024 θα καταργήσουμε σταδιακά τα ζητήματα GitHub ως μηχανισμό ανάδρασης για το περιεχόμενο και θα το αντικαταστήσουμε με ένα νέο σύστημα ανάδρασης. Για περισσότερες πληροφορίες, ανατρέξτε στο θέμα:Υποβολή και προβολή σχολίων για