Skip to content

Commit d44fc8d

Browse files
Ja-DunnJa-Dunn
authored
Merge pull request #3983 from pmasl/patch-22
Update sys-database-automatic-tuning-options-transact-sql.md
2 parents 4d6ff75 + 4368561 commit d44fc8d

1 file changed

Lines changed: 7 additions & 18 deletions

File tree

‎docs/relational-databases/system-catalog-views/sys-database-automatic-tuning-options-transact-sql.md‎

Lines changed: 7 additions & 18 deletions
Original file line numberDiff line numberDiff line change
@@ -37,28 +37,17 @@ ms.workload: "Inactive"
3737

3838
|Column name|Data type|Description|
3939
|-----------------|---------------|-----------------|
40-
|**name**|**nvarchar(128)**|The name of the automatic tuning option, for example, `FORCE_LAST_GOOD_PLAN`|
41-
|**desired_state**|**smallint**|Indicates the desired operation mode for Automatic Tuning option, explicitly set by user.|
42-
|**desired_state_desc**|**nvarchar(60)**|Textual description of the desired operation mode of Automatic Tuning option:<br />`OFF` (0)<br />`ON` (1)|
43-
|**actual_state**|**smallint**|Indicates the operation mode of Automatic Tuning option.|
44-
|**actual_state_desc**|**nvarchar(60)**|Textual description of the actual operation mode of Automatic Tuning option.<br />`OFF` (0)<br />`ON` (1)|
45-
|**reason**|**smallint**|Indicates why actual and desired states are different.|
46-
|**reason_desc**|**nvarchar(60)**|Textual description of the reason why actual and desired states are different.|
40+
|**name**|**nvarchar(128)**|The name of the automatic tuning option. Refer to [ALTER DATABASE SET AUTOMATIC_TUNING &#40;Transact-SQL&#41;](../../t-sql/statements/alter-database-transact-sql-set-options.md) for available options.|
41+
|**desired_state**|**smallint**|Indicates the desired operation mode for Automatic Tuning option, explicitly set by user.<br />0 = OFF<br />1 = ON|
42+
|**desired_state_desc**|**nvarchar(60)**|Textual description of the desired operation mode of Automatic Tuning option.<br />OFF<br />ON|
43+
|**actual_state**|**smallint**|Indicates the operation mode of Automatic Tuning option.<br />0 = OFF<br />1 = ON|
44+
|**actual_state_desc**|**nvarchar(60)**|Textual description of the actual operation mode of Automatic Tuning option.<br />OFF<br />ON|
45+
|**reason**|**smallint**|Indicates why actual and desired states are different.<br />2 = DISABLED<br />11 = QUERY_STORE_OFF<br />12 = QUERY_STORE_READ_ONLY<br />13 = NOT_SUPPORTED|
46+
|**reason_desc**|**nvarchar(60)**|Textual description of the reason why actual and desired states are different.<br />DISABLED = Option is disabled by system<br />QUERY_STORE_OFF = Query Store is turned off<br />QUERY_STORE_READ_ONLY = Query Store is in read-only mode<br />NOT_SUPPORTED = Available only in [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Enterprise edition|
4747

4848
## Permissions
4949
Requires the `VIEW DATABASE STATE` permission.
5050

51-
## Remarks
52-
The values in `reason` and `reason_desc` columns might be:
53-
54-
|reason|reason\_desc|Description|
55-
|-----------------|---------------|-----------------|
56-
| 2 | `DISABLED` | Option is disabled by system.|
57-
| 11 | `QUERY_STORE_OFF` | Query Store is turned off.|
58-
| 12 | `QUERY_STORE_READ_ONLY` | Query Store is in read-only mode.|
59-
| 13 | `NOT_SUPPORTED` | Available only in Enterprise edition of SQL Server.|
60-
61-
6251
## See Also
6352
[Automatic Tuning](../../relational-databases/automatic-tuning/automatic-tuning.md)
6453
[ALTER DATABASE SET AUTOMATIC_TUNING &#40;Transact-SQL&#41;](../../t-sql/statements/alter-database-transact-sql-set-options.md)

0 commit comments

Comments
 (0)