Operational Defect Database
BugZero found this defect 1308 days ago.
Data sources
All data on this page is proprietary to BugZero® or gathered from public sources
Microsoft SQL Server | 11003402
KB4046022 - FIX: Automatic Tuning settings cannot be configured on ModelDB in SQL Server 2017 - Microsoft Support
Last update date:
7/21/2023
Affected products:
SQL Server 2017 on Windows (all editions)
Affected releases:
build lower than 14.0.3006.16
Fixed releases:
14.0.3006.16
Description:
Symptoms
Assume that you have installed an instance of SQL Server 2017. When you try to configure Automatic Tuning settings on ModelDB, you may notice that the ModelDB may not enable you to configure the settings. Therefore, Automatic Tuning settings won't be available on any newly created databases until you explicitly enable the settings.
Resolution
This issue is fixed in the following cumulative update for SQL Server: Cumulative Update 1 for SQL Server 2017
