Cumulative Update #3 for SQL Server 2017 RTM

Published Mar 23 2019 05:23 PM 188 Views
Microsoft

First published on MSDN on Jan 10, 2018
The 3rd cumulative update release for SQL Server 2017 RTM is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates.
To learn more about the release, please visit:



Starting with SQL Server 2017, we are adopting a new modern servicing model. Please refer to our blog for more details on Modern Servicing Model for SQL Server

 



NOTE (1/30/2016):

We have found an issue where if you are using Query Store feature with SQL Server 2017 CU2, and later upgrade to SQL Server 2017 CU3 (or higher when available), an attempt to use the stored showplan fails. This includes the ability to force a specific plan captured by Query Store while SQL Server 2017 CU2 (14.0.3008.27) was installed, while already running with CU3 (14.0.3015.40) or a newer build.

As such, to assist DBAs in removing any of the affected plans collected while SQL Server 2017 CU2 was installed, we have created this T-SQL script to remove only the affected plans in Query Store. Execute it immediately after upgrading from SQL Server 2017 CU2 to SQL Server 2017 CU3 or a newer CU. If you are upgrading already from SQL Server 2017 CU3 or a newer build, executing the script is not needed.


The respective KB articles for SQL Server 2017 CU2 and CU3 are updated to reflect this recommendation.

Note: Any query plans captured by Query Store in versions prior to 14.0.3008.27 are not affected. Only plans captured in 14.0.3008.27. Therefore the script will only remove plans from the Query Store that match SQL Server 2017 CU2 (build 14.0.3008.27).


Note 2: While Query Store is also available in SQL Server 2016, this version is not affected in any build.

Version history
Last update:
‎Apr 10 2020 06:19 PM
Updated by: