Table of contents
×

Release Date:

12/5/2017

Version:

14.0.3008.27

Summary

This article describes Cumulative Update package 2 (CU2) for Microsoft SQL Server 2017. This update contains 34 fixes that are issued after the release of SQL Server 2017 Cumulative Update 1, and updates components to the following builds.

  • SQL Server - Product version: 14.0.3008.27, file version: 2017.140.3008.27

  • Analysis Services - Product version: 14.0.1.440, file version: 2017.140.1.440

Known issues with this update

If you use the Query Store feature, do not install this Cumulative Update 2 (CU2) (14.0.3008.27). Instead, install CU3 (14.0.3015.40).

If you have already installed CU2,  after installing CU3 or higher, you must immediately execute the following script to delete all plans collected by Query Store while CU2 was installed:

SET NOCOUNT ON;
DROP TABLE IF EXISTS #tmpUserDBs;

SELECT [database_id], 0 AS [IsDone]
INTO #tmpUserDBs
FROM master.sys.databases
WHERE [database_id] > 4
AND [state] = 0 -- must be ONLINE
AND is_read_only = 0 -- cannot be READ_ONLY
AND [database_id] NOT IN (SELECT dr.database_id FROM sys.dm_hadr_database_replica_states dr -- Except all local Always On secondary replicas
INNER JOIN sys.dm_hadr_availability_replica_states rs ON dr.group_id = rs.group_id
INNER JOIN sys.databases d ON dr.database_id = d.database_id
WHERE rs.role = 2 -- Is Secondary
AND dr.is_local = 1
AND rs.is_local = 1)

DECLARE @userDB sysname;

WHILE (SELECT COUNT([database_id]) FROM #tmpUserDBs WHERE [IsDone] = 0) > 0
BEGIN
SELECT TOP 1 @userDB = DB_NAME([database_id]) FROM #tmpUserDBs WHERE [IsDone] = 0

-- PRINT 'Working on database ' + @userDB

EXEC ('USE [' + @userDB + '];
DECLARE @clearPlan bigint, @clearQry bigint;
IF EXISTS (SELECT [actual_state] FROM sys.database_query_store_options WHERE [actual_state] IN (1,2))
BEGIN
IF EXISTS (SELECT plan_id FROM sys.query_store_plan WHERE engine_version = ''14.0.3008.27'')
BEGIN
DROP TABLE IF EXISTS #tmpclearPlans;

SELECT plan_id, query_id, 0 AS [IsDone]
INTO #tmpclearPlans
FROM sys.query_store_plan WHERE engine_version = ''14.0.3008.27''

WHILE (SELECT COUNT(plan_id) FROM #tmpclearPlans WHERE [IsDone] = 0) > 0
BEGIN
SELECT TOP 1 @clearPlan = plan_id, @clearQry = query_id FROM #tmpclearPlans WHERE [IsDone] = 0
EXECUTE sys.sp_query_store_unforce_plan @clearQry, @clearPlan;
EXECUTE sys.sp_query_store_remove_plan @clearPlan;

UPDATE #tmpclearPlans
SET [IsDone] = 1
WHERE plan_id = @clearPlan AND query_id = @clearQry
END;

PRINT ''- Cleared possibly affected plans in database [' + @userDB + ']''
END
ELSE
BEGIN
PRINT ''- No affected plans in database [' + @userDB + ']''
END
END
ELSE
BEGIN
PRINT ''- Query Store not enabled in database [' + @userDB + ']''
END')
UPDATE #tmpUserDBs
SET [IsDone] = 1
WHERE [database_id] = DB_ID(@userDB)
END

Improvements and fixes included in this cumulative update

A downloadable Excel workbook that contains a summary list of builds, together with their current support lifecycle, is available. The Excel file also contains detailed fix lists for SQL Server 2019 and SQL Server 2017. Click to download this Excel file now.

Note: Individual entries in the following table can be referenced directly via a bookmark. If you click on any bug reference ID in the table, you will notice that a bookmark tag is added to the URL using this format #bkmk_NNNNNNNN. You can then share this URL to others so they can directly jump to the desired fix in the table.

Bug reference

KB article number

Description

Fix area

Platform

11076653

4052129

Update for manual change tracking cleanup procedure in SQL Server 2017

SQL Engine

All

11076285

4052126

Update adds a new extended event "marked_transaction_latch_trace" in SQL Server 2017 on Linux and Windows

SQL Engine

All

11123810

4052122

Performance improvement for Spatial Intermediate Filter in SQL Server 2017

SQL Engine

All

11129098

4052338

FIX: Excessive PREMPTIVE_OS_CREATEDIRECTORY waits during a workload that compiles or recompiles memory-optimized tables or table-types

SQL Engine

Linux

11008401

4035062

FIX: Memory use with many databases greater in SQL Server 2016 than earlier versions

SQL Engine

All

11078705

4039592

FIX: Cannot change the password for a SQL Server 2014 service account when additional LSA protection is enabled

Management Tools

Windows

11078715

4042232

FIX: Access violation when you cancel a pending query if the missing indexes feature is enabled in SQL Server

SQL performance

All

11078719

4043947

FIX: Bookmarks functionality does not work completely when you open a report in MHTML format through Outlook in SSRS

Reporting Services

All

11128807

4052697

FIX: TLS cipher suites with PFS don't work for secure connections in SQL Server 2017 on Linux

SQL Engine

Linux

11182963

4052969

FIX: Minimum memory limit set to 2GB to install or start SQL Server 2017

SQL Engine

Linux

11128694

4052984

FIX: Error when you backup database with memory-optimized tables in SQL Server 2017

In-Memory OLTP

All

11183519

4053291

FIX: "sys.dm_exec_query_profiles" DMV returns wrong "estimate_row_count" in SQL Server 2017 on Linux and Windows

SQL performance

All

11186915

4053329

FIX: Deadlock when multiple PREDICT T-SQL functions run concurrently

SQL Engine

Windows

11179675

4053349

FIX: "sys.external_libraries" catalog views are empty for non-dbo users in SQL Server

SQL Engine

Windows

11179674

4053348

FIX: External R library is installed or uninstalled repeatedly in SQL Server

SQL Engine

Windows

11192144

4053386

FIX: Using ALTER TABLE on an in-memory optimized table crashes SQL Server 2017

In-Memory OLTP

Windows

11188014

4053393

FIX: SQL Server 2017 on Linux does not listen to the nondefault IP address specified by the mssql-conf script

SQL Engine

Linux

11188013

4053392

FIX: Name resolution error occurs when IPv6 is disabled in SQL Server 2017 on Linux

SQL Engine

Linux

11133453

4053407

FIX: SQL Server 2017 cannot decrypt data encrypted by earlier versions of SQL Server by using the same symmetric key

SQL Engine

All

11195748

4053447

FIX: Incorrect warning message that asks to restart SQL Server when it is not required in SQL Server 2017 on Linux

Management Tools

Linux

11133452

4037454

Policy-Based Management policy not working after you install CU2 for SQL Server 2016 SP1

Management Tools

All

11187256

4052625

FIX: Data retrieval queries using non-clustered index seek take much longer in SQL Server

SQL Engine

Windows

10966006

4037412

FIX: Error 156 when SQL Server replication article contains either GEOGRAPHY_AUTO_GRID or GEOMETRY_AUTO_GRID

SQL Engine

All

10970440

4042962

FIX: "An unknown error" for "Show More Members" on Entity Dependencies explorer page in SQL Server 2016 Master Data Services

Data Quality Services (DQS)

All

11003332

4046102

FIX: ForceLastGoodPlan recommendation state is falsely reported as Expired if it is applied manually in SQL Server 2017

SQL Engine

All

11078729

4045814

FIX: "Message 611" error when you use BULK INSERT or INSERT SELECT to insert data into a clustered columnstore index

SQL Engine

Windows

11076441

4046858

FIX: A parallel query execution plan that contains a "merge join" operator takes longer to execute in Cumulative Update 3, 4 or 5 for SQL Server 2016 Service Pack 1

SQL performance

All

11057322

4052134

FIX: Errors 33111 and 3013 when you back up a TDE encrypted database in SQL Server

SQL Engine

All

11195379

4046056

FIX: Assertion occurs on accessing memory-optimized table through MARS

SQL Engine

Windows

11195380

4054037

FIX: Fatal error when a natively compiled stored procedure is executed to access memory-optimized tables in SQL Server 2017

In-Memory OLTP

Windows

11195381

4054035

FIX: Error 213 when you merge or split a partition of a partitioned graph table in SQL Server 2017 on Linux or Windows

SQL Engine

All

11195382

4054036

FIX: Error 8624 when you execute a query that contains a SELECT DISTINCT statement on a graph column in SQL Server 2017 on Linux or Windows

SQL Engine

All

11229737

4054842

Improvement: General improvements to the change tracking cleanup process in SQL Server 2017

SQL Engine

Windows

11281561

4055758

FIX: Inconsistent behavior for returning trailing blanks at the end of CHAR and BINARY data in SQL Server

SQL Engine

All

How to obtain or download this or latest cumulative update package

The following update is available from the Microsoft Download Center:

Download icon Download the latest cumulative update package for SQL Server 2017 now

If the download page does not appear, contact Microsoft Customer Service and Support to obtain the cumulative update package.

Note: After future cumulative updates are released for SQL Server 2017, this and all previous CUs can be downloaded from the Microsoft Update Catalog. However, we recommend that you always install the latest cumulative update that is available.

The following update is available from the Microsoft Update Catalog:

Download icon Download the cumulative update package for SQL Server 2017 CU 2 now

To update Linux to the latest CU, you must first have the Cumulative Update repository configured. Then, update your SQL Server packages by using the appropriate platform-specific update command.

For installation instructions and direct links to the CU package downloads, see the release notes.

File information

You can verify the download by computing the hash of the SQLServer2017-KB4052574-x64.exe file via the following command:

certutil -hashfile SQLServer2017-KB4052574-x64.exe SHA256

File name

SHA256 hash

SQLServer2017-KB4052574-x64.exe

1ABAD43EF6F320485A5A55008FCC5A2510F93252D8446369B8597A0F0F7E2E42

The English version of this package has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.

x64-based versions

SQL Server 2017 Analysis Services

File name

File version

File size

Date

Time

Platform

Asplatformhost.dll

2017.140.1.440

266400

08-Nov-2017

12:55

x64

Microsoft.analysisservices.minterop.dll

14.0.1.440

741024

08-Nov-2017

12:57

x86

Microsoft.analysisservices.server.core.dll

14.0.1.440

1380512

08-Nov-2017

12:55

x86

Microsoft.analysisservices.server.tabular.dll

14.0.1.440

984224

08-Nov-2017

12:55

x86

Microsoft.analysisservices.server.tabular.json.dll

14.0.1.440

521376

08-Nov-2017

12:55

x86

Microsoft.data.mashup.dll

2.49.4831.201

174816

25-Oct-2017

03:11

x86

Microsoft.data.mashup.oledb.dll

2.49.4831.201

36576

25-Oct-2017

03:11

x86

Microsoft.data.mashup.preview.dll

2.49.4831.201

48864

25-Oct-2017

03:11

x86

Microsoft.data.mashup.providercommon.dll

2.49.4831.201

105184

25-Oct-2017

03:11

x86

Microsoft.hostintegration.connectors.dll

2.49.4831.201

5167328

25-Oct-2017

03:11

x86

Microsoft.mashup.container.exe

2.49.4831.201

26336

25-Oct-2017

03:11

x64

Microsoft.mashup.container.netfx40.exe

2.49.4831.201

26848

25-Oct-2017

03:11

x64

Microsoft.mashup.container.netfx45.exe

2.49.4831.201

26848

25-Oct-2017

03:11

x64

Microsoft.mashup.eventsource.dll

2.49.4831.201

159456

25-Oct-2017

03:11

x86

Microsoft.mashup.oauth.dll

2.49.4831.201

82656

25-Oct-2017

03:11

x86

Microsoft.mashup.oledbprovider.dll

2.49.4831.201

67296

25-Oct-2017

03:11

x86

Microsoft.mashup.shims.dll

2.49.4831.201

25824

25-Oct-2017

03:11

x86

Microsoft.mashup.storage.xmlserializers.dll

1.0.0.0

151264

25-Oct-2017

03:11

x86

Microsoft.mashupengine.dll

2.49.4831.201

13032160

25-Oct-2017

03:11

x86

Microsoft.powerbi.adomdclient.dll

14.0.1.484

1044672

25-Oct-2017

03:11

x86

Msmdctr.dll

2017.140.1.440

40088

08-Nov-2017

12:57

x64

Msmdlocal.dll

2017.140.1.440

59898528

08-Nov-2017

12:57

x64

Msmdlocal.dll

2017.140.1.440

40357024

08-Nov-2017

12:57

x86

Msmdpump.dll

2017.140.1.440

8544416

08-Nov-2017

12:57

x64

Msmdredir.dll

2017.140.1.440

7091872

08-Nov-2017

12:57

x86

Msmdsrv.exe

2017.140.1.440

60590752

08-Nov-2017

12:57

x64

Msmgdsrv.dll

2017.140.1.440

8208544

08-Nov-2017

12:57

x64

Msmgdsrv.dll

2017.140.1.440

7310496

08-Nov-2017

12:57

x86

Msolap.dll

2017.140.1.440

7776416

08-Nov-2017

12:56

x86

Msolap.dll

2017.140.1.440

9468064

08-Nov-2017

12:57

x64

Msolui.dll

2017.140.1.440

310944

08-Nov-2017

12:57

x64

Msolui.dll

2017.140.1.440

287392

08-Nov-2017

12:57

x86

Powerbiextensions.dll

2.49.4831.201

5316832

25-Oct-2017

03:11

x64

Sql_as_keyfile.dll

2017.140.3008.27

100512

16-Nov-2017

18:31

x64

Sqlboot.dll

2017.140.3008.27

195232

16-Nov-2017

18:31

x64

Sqlceip.exe

14.0.3008.27

249504

16-Nov-2017

19:19

x86

Sqldumper.exe

2017.140.3008.27

118944

16-Nov-2017

18:28

x86

Sqldumper.exe

2017.140.3008.27

140448

16-Nov-2017

19:04

x64

SQL Server 2017 Database Services Common Core

File name

File version

File size

Date

Time

Platform

Instapi140.dll

2017.140.3008.27

61088

16-Nov-2017

17:54

x86

Instapi140.dll

2017.140.3008.27

70304

16-Nov-2017

18:31

x64

Microsoft.analysisservices.adomdclient.dll

14.0.1.440

1088672

08-Nov-2017

12:55

x86

Microsoft.analysisservices.adomdclient.dll

14.0.1.440

1088672

08-Nov-2017

12:57

x86

Microsoft.analysisservices.core.dll

14.0.1.440

1381536

08-Nov-2017

12:57

x86

Microsoft.analysisservices.xmla.dll

14.0.1.440

741536

08-Nov-2017

12:55

x86

Microsoft.analysisservices.xmla.dll

14.0.1.440

741536

08-Nov-2017

12:57

x86

Microsoft.sqlserver.edition.dll

14.0.3008.27

37024

16-Nov-2017

19:18

x86

Msasxpress.dll

2017.140.1.440

36000

08-Nov-2017

12:57

x64

Msasxpress.dll

2017.140.1.440

31904

08-Nov-2017

12:57

x86

Pbsvcacctsync.dll

2017.140.3008.27

82080

16-Nov-2017

19:17

x64

Pbsvcacctsync.dll

2017.140.3008.27

67744

16-Nov-2017

19:19

x86

Sql_common_core_keyfile.dll

2017.140.3008.27

100512

16-Nov-2017

18:31

x64

Sqldumper.exe

2017.140.3008.27

118944

16-Nov-2017

18:28

x86

Sqldumper.exe

2017.140.3008.27

140448

16-Nov-2017

19:04

x64

Sqlftacct.dll

2017.140.3008.27

62112

16-Nov-2017

19:17

x64

Sqlftacct.dll

2017.140.3008.27

54432

16-Nov-2017

19:19

x86

Sqlmgmprovider.dll

2017.140.3008.27

415904

16-Nov-2017

19:15

x64

Sqlmgmprovider.dll

2017.140.3008.27

372384

16-Nov-2017

19:18

x86

Sqlsvcsync.dll

2017.140.3008.27

356000

16-Nov-2017

18:31

x64

Sqlsvcsync.dll

2017.140.3008.27

273056

16-Nov-2017

18:32

x86

Svrenumapi140.dll

2017.140.3008.27

1173152

16-Nov-2017

18:31

x64

Svrenumapi140.dll

2017.140.3008.27

893600

16-Nov-2017

19:19

x86

SQL Server 2017 sql_dreplay_client

File name

File version

File size

Date

Time

Platform

Dreplayclient.exe

2017.140.3008.27

120992

16-Nov-2017

19:18

x86

Dreplaycommon.dll

2017.140.3008.27

697504

16-Nov-2017

19:18

x86

Dreplayutil.dll

2017.140.3008.27

309920

16-Nov-2017

19:18

x86

Instapi140.dll

2017.140.3008.27

70304

16-Nov-2017

18:31

x64

Sql_dreplay_client_keyfile.dll

2017.140.3008.27

100512

16-Nov-2017

18:31

x64

SQL Server 2017 sql_dreplay_controller

File name

File version

File size

Date

Time

Platform

Dreplaycommon.dll

2017.140.3008.27

697504

16-Nov-2017

19:18

x86

Dreplaycontroller.exe

2017.140.3008.27

350368

16-Nov-2017

19:18

x86

Dreplayprocess.dll

2017.140.3008.27

171168

16-Nov-2017

19:18

x86

Instapi140.dll

2017.140.3008.27

70304

16-Nov-2017

18:31

x64

Sql_dreplay_controller_keyfile.dll

2017.140.3008.27

100512

16-Nov-2017

18:31

x64

SQL Server 2017 Database Services Core Instance

File name

File version

File size

Date

Time

Platform

Datacollectorcontroller.dll

2017.140.3008.27

225952

16-Nov-2017

19:15

x64

Fssres.dll

2017.140.3008.27

89248

16-Nov-2017

19:17

x64

Hadrres.dll

2017.140.3008.27

187552

16-Nov-2017

19:17

x64

Hkcompile.dll

2017.140.3008.27

1421984

16-Nov-2017

19:17

x64

Hkengine.dll

2017.140.3008.27

5858472

16-Nov-2017

19:17

x64

Hkruntime.dll

2017.140.3008.27

161952

16-Nov-2017

19:17

x64

Microsoft.analysisservices.applocal.xmla.dll

14.0.1.440

741024

08-Nov-2017

12:55

x86

Microsoft.sqlautoadmin.autobackupagent.dll

14.0.3008.27

237216

16-Nov-2017

19:15

x86

Microsoft.sqlautoadmin.sqlautoadmin.dll

14.0.3008.27

79520

16-Nov-2017

19:15

x86

Microsoft.sqlserver.types.dll

2017.140.3008.27

392352

16-Nov-2017

19:05

x86

Microsoft.sqlserver.xevent.linq.dll

2017.140.3008.27

304288

16-Nov-2017

19:05

x64

Qds.dll

2017.140.3008.27

1165472

16-Nov-2017

21:28

x64

Sqagtres.dll

2017.140.3008.27

74400

16-Nov-2017

19:17

x64

Sql_engine_core_inst_keyfile.dll

2017.140.3008.27

100512

16-Nov-2017

18:31

x64

Sqlaamss.dll

2017.140.3008.27

89760

16-Nov-2017

19:15

x64

Sqlaccess.dll

2017.140.3008.27

474784

16-Nov-2017

18:31

x64

Sqlagent.exe

2017.140.3008.27

579744

16-Nov-2017

19:15

x64

Sqlagentctr140.dll

2017.140.3008.27

61088

16-Nov-2017

19:15

x64

Sqlagentctr140.dll

2017.140.3008.27

52896

16-Nov-2017

19:18

x86

Sqlagentmail.dll

2017.140.3008.27

53920

16-Nov-2017

18:31

x64

Sqlboot.dll

2017.140.3008.27

195232

16-Nov-2017

18:31

x64

Sqlceip.exe

14.0.3008.27

249504

16-Nov-2017

19:19

x86

Sqlcmdss.dll

2017.140.3008.27

72352

16-Nov-2017

19:15

x64

Sqlctr140.dll

2017.140.3008.27

129184

16-Nov-2017

19:17

x64

Sqlctr140.dll

2017.140.3008.27

111776

16-Nov-2017

19:19

x86

Sqldk.dll

2017.140.3008.27

2789536

16-Nov-2017

21:28

x64

Sqldtsss.dll

2017.140.3008.27

107168

16-Nov-2017

19:54

x64

Sqlevn70.rll

2017.140.3008.27

3207328

16-Nov-2017

18:27

x64

Sqlevn70.rll

2017.140.3008.27

3668128

16-Nov-2017

18:27

x64

Sqlevn70.rll

2017.140.3008.27

3813024

16-Nov-2017

18:27

x64

Sqlevn70.rll

2017.140.3008.27

3777184

16-Nov-2017

18:27

x64

Sqlevn70.rll

2017.140.3008.27

4016800

16-Nov-2017

18:27

x64

Sqlevn70.rll

2017.140.3008.27

2032800

16-Nov-2017

18:27

x64

Sqlevn70.rll

2017.140.3008.27

1442464

16-Nov-2017

18:27

x64

Sqlevn70.rll

2017.140.3008.27

3359904

16-Nov-2017

18:27

x64

Sqlevn70.rll

2017.140.3008.27

3771040

16-Nov-2017

18:28

x64

Sqlevn70.rll

2017.140.3008.27

3474080

16-Nov-2017

18:28

x64

Sqlevn70.rll

2017.140.3008.27

3284640

16-Nov-2017

18:28

x64

Sqlevn70.rll

2017.140.3008.27

3909792

16-Nov-2017

18:28

x64

Sqlevn70.rll

2017.140.3008.27

2085536

16-Nov-2017

18:28

x64

Sqlevn70.rll

2017.140.3008.27

3395232

16-Nov-2017

18:28

x64

Sqlevn70.rll

2017.140.3008.27

3290272

16-Nov-2017

18:29

x64

Sqlevn70.rll

2017.140.3008.27

3580576

16-Nov-2017

18:29

x64

Sqlevn70.rll

2017.140.3008.27

3778208

16-Nov-2017

18:29

x64

Sqlevn70.rll

2017.140.3008.27

3331744

16-Nov-2017

18:31

x64

Sqlevn70.rll

2017.140.3008.27

3906720

16-Nov-2017

18:31

x64

Sqlevn70.rll

2017.140.3008.27

1495200

16-Nov-2017

18:31

x64

Sqlevn70.rll

2017.140.3008.27

3589792

16-Nov-2017

18:31

x64

Sqlevn70.rll

2017.140.3008.27

3627168

16-Nov-2017

18:33

x64

Sqllang.dll

2017.140.3008.27

41173152

16-Nov-2017

21:28

x64

Sqlmin.dll

2017.140.3008.27

40238752

16-Nov-2017

21:28

x64

Sqlolapss.dll

2017.140.3008.27

107680

16-Nov-2017

19:15

x64

Sqlos.dll

2017.140.3008.27

26272

16-Nov-2017

19:05

x64

Sqlpowershellss.dll

2017.140.3008.27

67744

16-Nov-2017

19:15

x64

Sqlrepss.dll

2017.140.3008.27

64160

16-Nov-2017

19:15

x64

Sqlscm.dll

2017.140.3008.27

70816

16-Nov-2017

19:15

x64

Sqlscriptdowngrade.dll

2017.140.3008.27

27808

16-Nov-2017

17:43

x64

Sqlscriptupgrade.dll

2017.140.3008.27

5871264

16-Nov-2017

18:31

x64

Sqlservr.exe

2017.140.3008.27

487072

16-Nov-2017

21:28

x64

Sqlsvc.dll

2017.140.3008.27

161440

16-Nov-2017

19:15

x64

Sqltses.dll

2017.140.3008.27

9537696

16-Nov-2017

21:28

x64

Sqsrvres.dll

2017.140.3008.27

260256

16-Nov-2017

19:17

x64

Svl.dll

2017.140.3008.27

153760

16-Nov-2017

19:17

x64

Xpadsi.exe

2017.140.3008.27

89760

16-Nov-2017

19:17

x64

Xplog70.dll

2017.140.3008.27

75936

16-Nov-2017

19:17

x64

Xpqueue.dll

2017.140.3008.27

74912

16-Nov-2017

19:17

x64

Xprepl.dll

2017.140.3008.27

101536

16-Nov-2017

19:17

x64

Xpsqlbot.dll

2017.140.3008.27

32416

16-Nov-2017

18:31

x64

Xpstar.dll

2017.140.3008.27

437408

16-Nov-2017

19:17

x64

SQL Server 2017 Database Services Core Shared

File name

File version

File size

Date

Time

Platform

Bcp.exe

2017.140.3008.27

119968

16-Nov-2017

18:31

x64

Distrib.exe

2017.140.3008.27

202400

16-Nov-2017

18:31

x64

Dts.dll

2017.140.3008.27

2997920

16-Nov-2017

19:15

x64

Dtsconn.dll

2017.140.3008.27

496800

16-Nov-2017

19:15

x64

Dtshost.exe

2017.140.3008.27

103584

16-Nov-2017

19:17

x64

Dtspipeline.dll

2017.140.3008.27

1265824

16-Nov-2017

19:15

x64

Dtutil.exe

2017.140.3008.27

147104

16-Nov-2017

19:15

x64

Logread.exe

2017.140.3008.27

623776

16-Nov-2017

19:17

x64

Mergetxt.dll

2017.140.3008.27

63136

16-Nov-2017

18:31

x64

Microsoft.analysisservices.applocal.core.dll

14.0.1.440

1381536

08-Nov-2017

12:55

x86

Microsoft.data.datafeedclient.dll

13.1.1.0

171208

28-Oct-2017

03:16

x86

Microsoft.sqlserver.replication.dll

2017.140.3008.27

1650336

16-Nov-2017

19:16

x64

Msgprox.dll

2017.140.3008.27

269984

16-Nov-2017

18:31

x64

Msxmlsql.dll

2017.140.3008.27

1450656

16-Nov-2017

19:17

x64

Qrdrsvc.exe

2017.140.3008.27

472224

16-Nov-2017

19:17

x64

Rdistcom.dll

2017.140.3008.27

839840

16-Nov-2017

19:17

x64

Repldp.dll

2017.140.3008.27

284320

16-Nov-2017

18:31

x64

Replerrx.dll

2017.140.3008.27

153760

16-Nov-2017

19:17

x64

Replisapi.dll

2017.140.3008.27

361632

16-Nov-2017

19:17

x64

Replmerg.exe

2017.140.3008.27

524448

16-Nov-2017

19:17

x64

Replprov.dll

2017.140.3008.27

801440

16-Nov-2017

18:31

x64

Replrec.dll

2017.140.3008.27

975008

16-Nov-2017

18:31

x64

Replsub.dll

2017.140.3008.27

445600

16-Nov-2017

19:17

x64

Replsync.dll

2017.140.3008.27

153760

16-Nov-2017

19:17

x64

Spresolv.dll

2017.140.3008.27

252064

16-Nov-2017

19:17

x64

Sql_engine_core_shared_keyfile.dll

2017.140.3008.27

100512

16-Nov-2017

18:31

x64

Sqldistx.dll

2017.140.3008.27

224920

16-Nov-2017

19:17

x64

Sqlmergx.dll

2017.140.3008.27

360608

16-Nov-2017

18:31

x64

Sqlscm.dll

2017.140.3008.27

60064

16-Nov-2017

18:32

x86

Sqlscm.dll

2017.140.3008.27

70816

16-Nov-2017

19:15

x64

Sqlsvc.dll

2017.140.3008.27

161440

16-Nov-2017

19:15

x64

Sqlsvc.dll

2017.140.3008.27

134304

16-Nov-2017

19:18

x86

Ssradd.dll

2017.140.3008.27

74912

16-Nov-2017

18:31

x64

Ssravg.dll

2017.140.3008.27

74912

16-Nov-2017

18:31

x64

Ssrdown.dll

2017.140.3008.27

60064

16-Nov-2017

19:17

x64

Ssrmax.dll

2017.140.3008.27

72864

16-Nov-2017

19:17

x64

Ssrmin.dll

2017.140.3008.27

73376

16-Nov-2017

19:17

x64

Ssrpub.dll

2017.140.3008.27

60576

16-Nov-2017

19:17

x64

Ssrup.dll

2017.140.3008.27

60064

16-Nov-2017

18:31

x64

Xmlsub.dll

2017.140.3008.27

260256

16-Nov-2017

19:17

x64

SQL Server 2017 sql_extensibility

File name

File version

File size

Date

Time

Platform

Launchpad.exe

2017.140.3008.27

1122464

16-Nov-2017

19:17

x64

Sql_extensibility_keyfile.dll

2017.140.3008.27

100512

16-Nov-2017

18:31

x64

Sqlsatellite.dll

2017.140.3008.27

920736

16-Nov-2017

19:17

x64

SQL Server 2017 Full-Text Engine

File name

File version

File size

Date

Time

Platform

Fd.dll

2017.140.3008.27

667296

16-Nov-2017

19:17

x64

Fdhost.exe

2017.140.3008.27

114336

16-Nov-2017

19:17

x64

Fdlauncher.exe

2017.140.3008.27

62112

16-Nov-2017

19:17

x64

Sql_fulltext_keyfile.dll

2017.140.3008.27

100512

16-Nov-2017

18:31

x64

Sqlft140ph.dll

2017.140.3008.27

67744

16-Nov-2017

19:17

x64

SQL Server 2017 sql_inst_mr

File name

File version

File size

Date

Time

Platform

Imrdll.dll

14.0.3008.27

23712

16-Nov-2017

18:31

x86

Sql_inst_mr_keyfile.dll

2017.140.3008.27

100512

16-Nov-2017

18:31

x64

SQL Server 2017 Integration Services

File name

File version

File size

Date

Time

Platform

Attunity.sqlserver.cdccontroltask.dll

5.0.0.70

75248

25-Oct-2017

03:10

x86

Attunity.sqlserver.cdcsplit.dll

5.0.0.70

36336

25-Oct-2017

03:10

x86

Attunity.sqlserver.cdcsrc.dll

5.0.0.70

76272

25-Oct-2017

03:10

x86

Dts.dll

2017.140.3008.27

2997920

16-Nov-2017

19:15

x64

Dts.dll

2017.140.3008.27

2548896

16-Nov-2017

19:18

x86

Dtsconn.dll

2017.140.3008.27

496800

16-Nov-2017

19:15

x64

Dtsconn.dll

2017.140.3008.27

398496

16-Nov-2017

19:18

x86

Dtshost.exe

2017.140.3008.27

103584

16-Nov-2017

19:17

x64

Dtshost.exe

2017.140.3008.27

89760

16-Nov-2017

19:18

x86

Dtspipeline.dll

2017.140.3008.27

1265824

16-Nov-2017

19:15

x64

Dtspipeline.dll

2017.140.3008.27

1058464

16-Nov-2017

19:18

x86

Dtutil.exe

2017.140.3008.27

147104

16-Nov-2017

19:15

x64

Dtutil.exe

2017.140.3008.27

126112

16-Nov-2017

19:18

x86

Isdeploymentwizard.exe

14.0.3008.27

476832

16-Nov-2017

19:53

x64

Isdeploymentwizard.exe

14.0.3008.27

477344

16-Nov-2017

20:27

x86

Microsoft.analysisservices.applocal.core.dll

14.0.1.440

1381536

08-Nov-2017

12:55

x86

Microsoft.analysisservices.applocal.core.dll

14.0.1.440

1381536

08-Nov-2017

12:57

x86

Microsoft.data.datafeedclient.dll

13.1.1.0

171208

28-Oct-2017

03:16

x86

Microsoft.sqlserver.integrationservices.isserverdbupgrade.dll

14.0.3008.27

493728

16-Nov-2017

18:31

x86

Microsoft.sqlserver.integrationservices.isserverdbupgrade.dll

14.0.3008.27

493728

16-Nov-2017

19:18

x86

Microsoft.sqlserver.integrationservices.server.dll

14.0.3008.27

83616

16-Nov-2017

19:15

x86

Microsoft.sqlserver.integrationservices.server.dll

14.0.3008.27

83616

16-Nov-2017

19:18

x86

Microsoft.sqlserver.integrationservices.wizard.common.dll

14.0.3008.27

415392

16-Nov-2017

19:54

x86

Microsoft.sqlserver.integrationservices.wizard.common.dll

14.0.3008.27

415392

16-Nov-2017

20:27

x86

Msdtssrvr.exe

14.0.3008.27

219808

16-Nov-2017

19:15

x64

Msmdpp.dll

2017.140.1.440

8400544

08-Nov-2017

12:57

x64

Sql_is_keyfile.dll

2017.140.3008.27

100512

16-Nov-2017

18:31

x64

Sqlceip.exe

14.0.3008.27

249504

16-Nov-2017

19:19

x86

SQL Server 2017 sql_polybase_core_inst

File name

File version

File size

Date

Time

Platform

Instapi140.dll

2017.140.3008.27

70304

16-Nov-2017

18:31

x64

Mpdwsvc.exe

2017.140.3008.27

7323296

16-Nov-2017

19:04

x64

Sqldumper.exe

2017.140.3008.27

140448

16-Nov-2017

19:04

x64

Sqlevn70.rll

2017.140.3008.27

1495200

16-Nov-2017

18:31

x64

Sqlevn70.rll

2017.140.3008.27

3906720

16-Nov-2017

18:31

x64

Sqlevn70.rll

2017.140.3008.27

3207328

16-Nov-2017

18:27

x64

Sqlevn70.rll

2017.140.3008.27

3909792

16-Nov-2017

18:28

x64

Sqlevn70.rll

2017.140.3008.27

3813024

16-Nov-2017

18:27

x64

Sqlevn70.rll

2017.140.3008.27

2085536

16-Nov-2017

18:28

x64

Sqlevn70.rll

2017.140.3008.27

2032800

16-Nov-2017

18:27

x64

Sqlevn70.rll

2017.140.3008.27

3580576

16-Nov-2017

18:29

x64

Sqlevn70.rll

2017.140.3008.27

3589792

16-Nov-2017

18:31

x64

Sqlevn70.rll

2017.140.3008.27

1442464

16-Nov-2017

18:27

x64

Sqlevn70.rll

2017.140.3008.27

3777184

16-Nov-2017

18:27

x64

SQL Server 2017 sql_shared_mr

File name

File version

File size

Date

Time

Platform

Smrdll.dll

14.0.3008.27

23712

16-Nov-2017

18:31

x86

Sql_engine_core_shared_keyfile.dll

2017.140.3008.27

100512

16-Nov-2017

18:31

x64

SQL Server 2017 sql_tools_extensions

File name

File version

File size

Date

Time

Platform

Dts.dll

2017.140.3008.27

2997920

16-Nov-2017

19:15

x64

Dts.dll

2017.140.3008.27

2548896

16-Nov-2017

19:18

x86

Dtsconn.dll

2017.140.3008.27

496800

16-Nov-2017

19:15

x64

Dtsconn.dll

2017.140.3008.27

398496

16-Nov-2017

19:18

x86

Dtshost.exe

2017.140.3008.27

103584

16-Nov-2017

19:17

x64

Dtshost.exe

2017.140.3008.27

89760

16-Nov-2017

19:18

x86

Dtspipeline.dll

2017.140.3008.27

1265824

16-Nov-2017

19:15

x64

Dtspipeline.dll

2017.140.3008.27

1058464

16-Nov-2017

19:18

x86

Dtutil.exe

2017.140.3008.27

147104

16-Nov-2017

19:15

x64

Dtutil.exe

2017.140.3008.27

126112

16-Nov-2017

19:18

x86

Microsoft.sqlserver.astasksui.dll

14.0.3008.27

184480

16-Nov-2017

20:53

x86

Microsoft.sqlserver.chainer.infrastructure.dll

14.0.3008.27

406688

16-Nov-2017

19:15

x86

Microsoft.sqlserver.chainer.infrastructure.dll

14.0.3008.27

406688

16-Nov-2017

19:18

x86

Microsoft.sqlserver.configuration.sco.dll

14.0.3008.27

2093216

16-Nov-2017

19:15

x86

Microsoft.sqlserver.configuration.sco.dll

14.0.3008.27

2093216

16-Nov-2017

19:18

x86

Msmgdsrv.dll

2017.140.1.440

7310496

08-Nov-2017

12:57

x86

Sql_tools_extensions_keyfile.dll

2017.140.3008.27

100512

16-Nov-2017

18:31

x64

Sqlscm.dll

2017.140.3008.27

60064

16-Nov-2017

18:32

x86

Sqlscm.dll

2017.140.3008.27

70816

16-Nov-2017

19:15

x64

Sqlsvc.dll

2017.140.3008.27

161440

16-Nov-2017

19:15

x64

Sqlsvc.dll

2017.140.3008.27

134304

16-Nov-2017

19:18

x86

Notes for this update

To apply this Cumulative Update package, you must be running SQL Server 2017.

You may have to restart the computer after you apply this Cumulative Update package.

To use one of the hotfixes in this package, you do not have to make any changes to the registry.

This article also provides important information about the following situations:

  • Pacemaker : A behavioral change is made in distributions that use the latest available version of Pacemaker. Mitigation methods are provided.

  • Query Store : You must run this script if you use the Query Store and you have previously installed Microsoft SQL Server 2017 Cumulative Update 2 (CU2).

Analysis Services CU build version

Beginning in SQL Server 2017, the Analysis Services build version number and SQL Server Database Engine build version number do not match. For more information, see Verify Analysis Services cumulative update build version.

Cumulative updates (CU)

Cumulative updates (CU) are now available at the Microsoft Download Center.

Only the most recent CU that was released for SQL Server 2017 is available at the Download Center.

CU packages for Linux are available at https://packages.microsoft.com/.

Notes

  • Each new CU contains all the fixes that were included with the previous CU for the installed version of SQL Server.

  • SQL Server CUs are certified to the same levels as Service Packs, and should be installed at the same level of confidence.

  • We recommend ongoing, proactive installation of CUs as they become available according to these guidelines:

    • Historical data shows that a significant number of support cases involve an issue that has already been addressed in a released CU.

    • CUs may contain added value over and above hotfixes. This includes supportability, manageability, and reliability updates.

  • We recommend that you test CUs before you deploy them to production environments.

IMPORTANT

All distributions (including RHEL 7.3 and 7.4) that use the latest available Pacemaker package 1.1.18-11.el7 introduce a behavior change for the start-failure-is-fatal cluster setting if its value is false. This change affects the failover workflow. If a primary replica experiences an outage, the cluster is expected to fail over to one of the available secondary replicas. Instead, users will notice that the cluster keeps trying to start the failed primary replica. If that primary never comes online (because of a permanent outage), the cluster never fails over to another available secondary replica.

This issue affects all SQL Server versions, regardless of the cumulative update version that they are on.

To mitigate the issue, use either of the following methods.

Method 1

Follow these steps:

  1. Remove the start-failure-is-fatal override from the existing cluster.

    # RHEL, Ubuntu pcs property unset start-failure-is-fatal # or pcs property set start-failure-is-fatal=true # SLES crm configure property start-failure-is-fatal=true

  2. Decrease the cluster-recheck-interval value.

    # RHEL, Ubuntu pcs property set cluster-recheck-interval=<Xmin> # SLES crm configure property cluster-recheck-interval=<Xmin>

  3. Add the failure-timeout meta property to each AG resource.

    # RHEL, Ubuntu pcs resource update ag1 meta failure-timeout=60s # SLES crm configure edit ag1 # In the text editor, add `meta failure-timeout=60s` after any `param`s and before any `op`s

    Note In this code, substitute the value for <Xmin> as appropriate. If a replica goes down, the cluster tries to restart the replica at an interval that is bound by the failure-timeout value and the cluster-recheck-interval value. For example, if failure-timeout is set to 60 seconds and cluster-recheck-interval is set to 120 seconds, the restart is tried at an interval that is greater than 60 seconds but less than 120 seconds. We recommend that you set failure-timeout to 60s and cluster-recheck-interval to a value that is greater than 60 seconds. We recommend that you do not set cluster-recheck-interval to a small value. For more information, refer to the Pacemaker documentation or consult the system provider.

Method 2

Revert to Pacemaker version 1.1.16.

IMPORTANT

You must run this script if you use Query Store and you are updating from SQL Server 2017 Cumulative Update 2 (CU2) directly to SQL Server 2017 Cumulative Update 3 (CU3) or any later cumulative update. You do not have to run this script if you have previously installed SQL Server 2017 Cumulative Update 3 (CU3) or any later SQL Server 2017 cumulative update.

SET NOCOUNT ON;
DROP TABLE IF EXISTS #tmpUserDBs;

SELECT [database_id], 0 AS [IsDone]
INTO #tmpUserDBs
FROM master.sys.databases
WHERE [database_id] > 4
 AND [state] = 0 -- must be ONLINE
 AND is_read_only = 0 -- cannot be READ_ONLY
 AND [database_id] NOT IN (SELECT dr.database_id FROM sys.dm_hadr_database_replica_states dr -- Except all local Always On secondary replicas
  INNER JOIN sys.dm_hadr_availability_replica_states rs ON dr.group_id = rs.group_id
  INNER JOIN sys.databases d ON dr.database_id = d.database_id
  WHERE rs.role = 2 -- Is Secondary
   AND dr.is_local = 1
   AND rs.is_local = 1)

DECLARE @userDB sysname;

WHILE (SELECT COUNT([database_id]) FROM #tmpUserDBs WHERE [IsDone] = 0) > 0
BEGIN
 SELECT TOP 1 @userDB = DB_NAME([database_id]) FROM #tmpUserDBs WHERE [IsDone] = 0

 -- PRINT 'Working on database ' + @userDB

 EXEC ('USE [' + @userDB + '];
DECLARE @clearPlan bigint, @clearQry bigint;
IF EXISTS (SELECT [actual_state] FROM sys.database_query_store_options WHERE [actual_state] IN (1,2))
BEGIN
 IF EXISTS (SELECT plan_id FROM sys.query_store_plan WHERE engine_version = ''14.0.3008.27'')
 BEGIN
  DROP TABLE IF EXISTS #tmpclearPlans;

  SELECT plan_id, query_id, 0 AS [IsDone]
  INTO #tmpclearPlans
  FROM sys.query_store_plan WHERE engine_version = ''14.0.3008.27''

  WHILE (SELECT COUNT(plan_id) FROM #tmpclearPlans WHERE [IsDone] = 0) > 0
  BEGIN
   SELECT TOP 1 @clearPlan = plan_id, @clearQry = query_id FROM #tmpclearPlans WHERE [IsDone] = 0
   EXECUTE sys.sp_query_store_unforce_plan @clearQry, @clearPlan;
   EXECUTE sys.sp_query_store_remove_plan @clearPlan;

   UPDATE #tmpclearPlans
   SET [IsDone] = 1
   WHERE plan_id = @clearPlan AND query_id = @clearQry
  END;

  PRINT ''- Cleared possibly affected plans in database [' + @userDB + ']''
 END
 ELSE
 BEGIN
  PRINT ''- No affected plans in database [' + @userDB + ']''
 END
END
ELSE
BEGIN
 PRINT ''- Query Store not enabled in database [' + @userDB + ']''
END')
  UPDATE #tmpUserDBs
  SET [IsDone] = 1
  WHERE [database_id] = DB_ID(@userDB)
END

When you deploy an update to a hybrid environment (such as AlwaysOn, replication, cluster, and mirroring), we recommend that you refer to the following articles before you deploy the update:

SQL Server Cumulative Updates are currently multilingual. Therefore, this cumulative update package is not specific to one language. It applies to all supported languages.

One Cumulative Update package includes all available updates for ALL SQL Server 2017 components (features). However, the cumulative update package updates only those components that are currently installed on the SQL Server instance you select to be serviced. If a SQL Server feature (for example, Analysis Services) is added to the instance after this CU is applied, you must re-apply this CU to update the new feature to this CU.

If additional issues occur or if any troubleshooting is required, you might have to create a service request. The usual support costs will apply to additional support questions and to issues that do not qualify for this specific cumulative update package. For a complete list of Microsoft Customer Service and Support telephone numbers, or to create a separate service request, go to the Microsoft support website.

How to uninstall this update

  1. In Control Panel, open the Programs and Features item, and then select View installed updates.

  2. Locate the entry that corresponds to this cumulative update package under SQL Server 2017.

  3. Press and hold (or right-click) the entry, and then select Uninstall.

To uninstall this CU on Linux, you must roll back the package to the previous version.

For more information about how to roll back the installation, see Rollback SQL Server.


Third-party information disclaimer

The third-party products that are discussed in this article are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.

References

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×