Skip to content

Commit ebad853

Browse files
PRMerger15PRMerger15
authored
Merge pull request MicrosoftDocs#6761 from danimir/master
Fixing formatting
2 parents febf157 + 3508681 commit ebad853

1 file changed

Lines changed: 38 additions & 38 deletions

File tree

‎docs/t-sql/statements/alter-database-transact-sql-set-options.md‎

Lines changed: 38 additions & 38 deletions
Original file line numberDiff line numberDiff line change
@@ -112,7 +112,7 @@ SET
112112
}
113113
}
114114
115-
<change_tracking_option_list> ::=
115+
<change_tracking_option_list> ::=
116116
{
117117
AUTO_CLEANUP = { ON | OFF }
118118
| CHANGE_RETENTION = retention_period { DAYS | HOURS | MINUTES }
@@ -1306,7 +1306,7 @@ SET
13061306
}
13071307
13081308
<automatic_tuning_option> ::=
1309-
{ AUTOMATIC_TUNING = { AUTO | INHERIT | CUSTOM }
1309+
{ AUTOMATIC_TUNING = { AUTO | INHERIT | CUSTOM }
13101310
| AUTOMATIC_TUNING ( CREATE_INDEX = { DEFAULT | ON | OFF } )
13111311
| AUTOMATIC_TUNING ( DROP_INDEX = { DEFAULT | ON | OFF } )
13121312
| AUTOMATIC_TUNING ( FORCE_LAST_GOOD_PLAN = { DEFAULT | ON | OFF } )
@@ -1322,7 +1322,7 @@ SET
13221322
}
13231323
}
13241324
1325-
<change_tracking_option_list> ::=
1325+
<change_tracking_option_list> ::=
13261326
{
13271327
AUTO_CLEANUP = { ON | OFF }
13281328
| CHANGE_RETENTION = retention_period { DAYS | HOURS | MINUTES }
@@ -1483,54 +1483,54 @@ For more information that describes when to use synchronous or asynchronous stat
14831483
<a name="auto_tuning"></a> **\<automatic_tuning_option> ::=**
14841484
**Applies to**: [!INCLUDE[sssqlv14-md](../../includes/sssqlv14-md.md)].
14851485

1486-
Controls automatic options for [automatic tuning](../../relational-databases/automatic-tuning/automatic-tuning.md).
1486+
Controls automatic options for [automatic tuning](../../relational-databases/automatic-tuning/automatic-tuning.md).
14871487

1488-
AUTOMATIC_TUNING = { AUTO | INHERIT | CUSTOM }
1489-
AUTO
1490-
Setting the automatic tuning value to AUTO will apply Azure configuration defaults for automatic tuning.
1488+
AUTOMATIC_TUNING = { AUTO | INHERIT | CUSTOM }
1489+
AUTO
1490+
Setting the automatic tuning value to AUTO will apply Azure configuration defaults for automatic tuning.
1491+
1492+
INHERIT
1493+
Using the value INHERIT will inherit the default configuration from the parent server. This is especially useful if you would like to customize automatic tuning configuration on a parent server, and have all the databases on such server INHERIT these custom settings. Please note that in order for the inheritance to work, the three individual tuning options FORCE_LAST_GOOD_PLAN, CREATE_INDEX and DROP_INDEX need to be set to DEFAULT on databases.
14911494

1492-
INHERIT
1493-
Using the value INHERIT will inherit the default configuration from the parent server. This is especially useful if you would like to customize automatic tuning configuration on a parent server, and have all the databases on such server INHERIT these custom settings. Please note that in order for the inheritance to work, the three individual tuning options FORCE_LAST_GOOD_PLAN, CREATE_INDEX and DROP_INDEX need to be set to DEFAULT on databases.
1494-
1495-
CUSTOM
1496-
Using the value CUSTOM, you will need to manually custom configure each of the automatic tuning options available on databases.
1495+
CUSTOM
1496+
Using the value CUSTOM, you will need to manually custom configure each of the automatic tuning options available on databases.
1497+
1498+
Enables or disables automatic index management `CREATE_INDEX` option of [automatic tuning](../../relational-databases/automatic-tuning/automatic-tuning.md).
14971499

1498-
Enables or disables automatic index management `CREATE_INDEX` option of [automatic tuning](../../relational-databases/automatic-tuning/automatic-tuning.md).
1499-
15001500
CREATE_INDEX = { DEFAULT | ON | OFF }
1501-
DEFALT
1502-
Inherits default settings from the server. In this case, options of enabling or disabling individual Automatic tuning features are defined at the server level.
1503-
1504-
ON
1501+
DEFALT
1502+
Inherits default settings from the server. In this case, options of enabling or disabling individual Automatic tuning features are defined at the server level.
1503+
1504+
ON
15051505
When enabled, missing indexes are automatically generated on a database. Following the index creation, gains to the performance of the workload are verified. When such created index no longer provides benefits to the workload performance, it is automatically reverted. Indexes automatically created are flagged as a system generated indexed.
1506-
1507-
OFF
1508-
Does not automatically generate missing indexes on the database.
1509-
1510-
Enables or disables automatic index management `DROP_INDEX` option of [automatic tuning](../../relational-databases/automatic-tuning/automatic-tuning.md).
1511-
1506+
1507+
OFF
1508+
Does not automatically generate missing indexes on the database.
1509+
1510+
Enables or disables automatic index management `DROP_INDEX` option of [automatic tuning](../../relational-databases/automatic-tuning/automatic-tuning.md).
1511+
15121512
DROP_INDEX = { DEFAULT | ON | OFF }
1513-
DEFALT
1514-
Inherits default settings from the server. In this case, options of enabling or disabling individual Automatic tuning features are defined at the server level.
1513+
DEFALT
1514+
Inherits default settings from the server. In this case, options of enabling or disabling individual Automatic tuning features are defined at the server level.
15151515

1516-
ON
1517-
Automatically drops duplicate or no longer useful indexes to the performance workload.
1516+
ON
1517+
Automatically drops duplicate or no longer useful indexes to the performance workload.
1518+
1519+
OFF
1520+
Does not automatically drop missing inexes on the database.
1521+
1522+
Enables or disables automatic plan correction `FORCE_LAST_GOOD_PLAN` option of [automatic tuning](../../relational-databases/automatic-tuning/automatic-tuning.md).
15181523

1519-
OFF
1520-
Does not automatically drop missing inexes on the database.
1521-
1522-
Enables or disables automatic plan correction `FORCE_LAST_GOOD_PLAN` option of [automatic tuning](../../relational-databases/automatic-tuning/automatic-tuning.md).
1523-
15241524
FORCE_LAST_GOOD_PLAN = { DEFAULT | ON | OFF }
1525-
DEFAULT
1526-
Inherits default settings from the server. In this case, options of enabling or disabling individual Automatic tuning features are defined at the server level.
1525+
DEFAULT
1526+
Inherits default settings from the server. In this case, options of enabling or disabling individual Automatic tuning features are defined at the server level.
15271527

15281528
ON
15291529
The [!INCLUDE[ssde_md](../../includes/ssde_md.md)] automatically forces the last known good plan on the [!INCLUDE[tsql_md](../../includes/tsql_md.md)] queries where new SQL plan causes performance regressions. The [!INCLUDE[ssde_md](../../includes/ssde_md.md)] continously monitors query performance of the [!INCLUDE[tsql_md](../../includes/tsql_md.md)] query with the forced plan. If there are performance gains, the [!INCLUDE[ssde_md](../../includes/ssde_md.md)] will keep using last known good plan. If performance gains are not detected, the [!INCLUDE[ssde_md](../../includes/ssde_md.md)] will produce a new SQL plan. The statement will fail if Query Store is not enabled or if it is not in *Read-Write* mode.
15301530

15311531
OFF
1532-
The [!INCLUDE[ssde_md](../../includes/ssde_md.md)] reports potential query performance regressions caused by SQL plan changes in [sys.dm_db_tuning_recommendations](../../relational-databases/system-dynamic-management-views/sys-dm-db-tuning-recommendations-transact-sql.md) view. However, these recommendations are not automatically applied. User can monitor active recomendations and fix identified problems by applying [!INCLUDE[tsql_md](../../includes/tsql_md.md)] scripts that are shown in the view. This is the default value.
1533-
1532+
The [!INCLUDE[ssde_md](../../includes/ssde_md.md)] reports potential query performance regressions caused by SQL plan changes in [sys.dm_db_tuning_recommendations](../../relational-databases/system-dynamic-management-views/sys-dm-db-tuning-recommendations-transact-sql.md) view. However, these recommendations are not automatically applied. User can monitor active recomendations and fix identified problems by applying [!INCLUDE[tsql_md](../../includes/tsql_md.md)] scripts that are shown in the view. This is the default value.
1533+
15341534
**\<change_tracking_option> ::=**
15351535

15361536
Controls change tracking options. You can enable change tracking, set options, change options, and disable change tracking. For examples, see the Examples section later in this article.
@@ -2092,7 +2092,7 @@ SET
20922092
}
20932093
}
20942094
2095-
<change_tracking_option_list> ::=
2095+
<change_tracking_option_list> ::=
20962096
{
20972097
AUTO_CLEANUP = { ON | OFF }
20982098
| CHANGE_RETENTION = retention_period { DAYS | HOURS | MINUTES }

0 commit comments

Comments
 (0)