SQL Server 2017: Critical Cumulative Update 12 (KB4464082) Now Available

Table of Contents

This article provides a comprehensive overview of Cumulative Update package 12 (CU12) for Microsoft SQL Server 2017, released on October 24, 2018. This vital update brings the SQL Server product version to 14.0.3045.24 and the Analysis Services product version to 14.0.230.1. It incorporates a total of 18 significant fixes that have been issued since the release of SQL Server 2017 Cumulative Update 11, ensuring improved stability, performance, and reliability for your SQL Server deployments.

SQL Server 2017 Cumulative Update

Summary of Key Improvements and Fixes

Cumulative Update 12 for SQL Server 2017 addresses a range of issues across various components, enhancing the overall functionality and user experience. The fixes span areas such as Analysis Services, Master Data Services, SQL Server Connectivity, and various aspects of the SQL Server Engine, including query execution, programmability, and replication. These updates resolve critical bugs that could lead to unexpected behavior, performance degradation, or operational challenges in production environments.

Analysis Services Enhancements

The update includes crucial fixes for Analysis Services, improving its stability and query processing capabilities. One notable fix (Bug Reference 12392563) addresses an “An unexpected exception occurred” error during MDX queries involving PC dimensions, which could disrupt data analysis. Another significant improvement (Bug Reference 12363625) resolves a deadlock scenario that occurred when running parallel DAX queries with time intelligence calculations, ensuring smoother and more efficient analytical operations. These fixes are essential for maintaining the integrity and performance of your analytical cubes and models.

Master Data Services Fixes

For Master Data Services (MDS) users, CU12 brings fixes that improve data management and user permissions. Bug Reference 12229849 resolves an issue where “Create” and “Update” operations failed in an entity when specific read and create permissions were set, hindering data governance processes. Additionally, Bug Reference 12352667 fixes an error encountered when attempting to change the “Display value” of the “Name” attribute in the SQL Server 2017 MDS Add-in for Excel, ensuring greater flexibility in data presentation. These improvements enhance the usability and reliability of MDS.

SQL Server Connectivity and Engine Improvements

The update also addresses critical issues related to SQL Server connectivity and the core database engine. A fix (Bug Reference 12342954) resolves an “Encryption not supported on the client” error that could occur when SQL Server 2017 linked server queries failed, ensuring secure and reliable data transfer. Within the SQL Server Engine, Bug Reference 12366825 corrects an issue where backing up a SQL Server 2008 database using a VSS backup application might fail after installing CU10 for SQL Server 2017, preventing data loss. Furthermore, an important fix (Bug Reference 12428685) prevents unexpected crashes of SQL Server 2017 when using third-party Active Directory providers, improving system stability.

Query Execution and Performance Optimizations

Several fixes in CU12 are dedicated to optimizing query execution and performance. Bug Reference 11967433 resolves an assertion error that occurred when executing a MERGE statement with an OUTPUT clause, ensuring correct data modification operations. A critical fix (Bug Reference 12409366) addresses a scenario where rebuilding an index with resumable online index rebuild could result in a fragmented index, which could degrade query performance over time. An improvement (Bug Reference 12186149) provides an optional replacement for the “String or binary data would be truncated” message with extended information, aiding in debugging data truncation issues. The update also disables trace flag 2467 at the session level to prevent performance issues for parallel queries (Bug Reference 12403785), contributing to better query execution times.

How to Obtain and Apply This Cumulative Update

Staying current with cumulative updates is crucial for maintaining the health and security of your SQL Server environment. Microsoft strongly recommends applying the latest cumulative update to ensure you benefit from the latest fixes and improvements.

A structured approach to applying updates minimizes risks and ensures system stability.

mermaid graph TD A[Start Update Process] --> B{Review Release Notes & Known Issues}; B --> C[Backup Databases & System State]; C --> D{Download CU12 Package}; D --> E[Test Update in Non-Production Environment]; E -- Issues Found --> F[Troubleshoot & Re-Test]; F --> E; E -- No Issues --> G[Plan Production Deployment]; G --> H[Apply CU12 to Production Systems]; H --> I[Verify System Functionality]; I --> J[Monitor Performance & Logs]; J --> K[End Process];

Obtaining the Update for Windows

The latest cumulative update packages for SQL Server 2017 for Windows are available from the Microsoft Download Center. If you encounter any issues accessing the download page, you can contact Microsoft Customer Service and Support for assistance. For future updates, the Microsoft Update Catalog will also host this and all previous CUs, though installing the latest available CU is always recommended.

Obtaining the Update for Linux

For SQL Server 2017 instances running on Linux, updating to the latest CU requires configuring the Cumulative Update repository. Once configured, you can update your SQL Server packages using platform-specific update commands. Detailed installation instructions and direct links to CU package downloads are provided in the SQL Server 2017 Release Notes.

File Information and Verification

Verifying the integrity of downloaded files is an important security measure. You can compute the SHA256 hash of the SQLServer2017-KB4464082-x64.exe file to ensure it matches the provided hash, confirming that the download is complete and untampered.

File Hash Information

File name SHA256 hash
SQLServer2017-KB4464082-x64.exe 0A435B81D0C41041C2CD1BFA0B2AB4754B1B4609D6EA5BC672991F761B509B2F

Cumulative Update Package File Information

The English version of this package includes various files with specific attributes. The dates and times listed for these files are in Coordinated Universal Time (UTC). When viewing the file information locally, it is converted to your local time zone.

x64-based versions

SQL Server 2017 Analysis Services
File name File version File size Date Time Platform
Asplatformhost.dll 2017.140.230.1 266312 26-Sep-18 18:56 x64
Microsoft.analysisservices.minterop.dll 14.0.230.1 741448 26-Sep-18 18:56 x86
Microsoft.analysisservices.server.core.dll 14.0.230.1 1380424 26-Sep-18 18:56 x86
Microsoft.analysisservices.server.tabular.dll 14.0.230.1 984328 26-Sep-18 18:56 x86
Microsoft.analysisservices.server.tabular.json.dll 14.0.230.1 521480 26-Sep-18 18:56 x86
Microsoft.applicationinsights.dll 2.7.0.13435 329872 27-Jul-18 23:51 x86
Microsoft.data.mashup.dll 2.57.5068.261 180424 06-Jun-18 04:34 x86
Microsoft.data.mashup.oledb.dll 2.57.5068.261 37584 06-Jun-18 04:34 x86
Microsoft.data.mashup.preview.dll 2.57.5068.261 54472 06-Jun-18 04:34 x86
Microsoft.data.mashup.providercommon.dll 2.57.5068.261 107728 06-Jun-18 04:34 x86
Microsoft.hostintegration.connectors.dll 2.57.5068.261 5223112 06-Jun-18 04:34 x86
Microsoft.mashup.container.exe 2.57.5068.261 26312 06-Jun-18 04:34 x64
Microsoft.mashup.container.netfx40.exe 2.57.5068.261 26824 06-Jun-18 04:34 x64
Microsoft.mashup.container.netfx45.exe 2.57.5068.261 26824 06-Jun-18 04:34 x64
Microsoft.mashup.eventsource.dll 2.57.5068.261 159440 06-Jun-18 04:34 x86
Microsoft.mashup.oauth.dll 2.57.5068.261 84176 06-Jun-18 04:34 x86
Microsoft.mashup.oledbprovider.dll 2.57.5068.261 67280 06-Jun-18 04:34 x86
Microsoft.mashup.shims.dll 2.57.5068.261 25808 06-Jun-18 04:34 x86
Microsoft.mashup.storage.xmlserializers.dll 1.0.0.0 151240 06-Jun-18 04:34 x86
Microsoft.mashupengine.dll 2.57.5068.261 13608144 06-Jun-18 04:34 x86
Microsoft.powerbi.adomdclient.dll 15.0.1.272 1106088 06-Jun-18 04:34 x86
Msmdctr.dll 2017.140.230.1 40200 26-Sep-18 18:56 x64
Msmdlocal.dll 2017.140.230.1 60710168 26-Sep-18 18:56 x64
Msmdlocal.dll 2017.140.230.1 40384280 26-Sep-18 18:56 x86
Msmdpump.dll 2017.140.230.1 9335064 26-Sep-18 18:56 x64
Msmdredir.dll 2017.140.230.1 7092296 26-Sep-18 18:56 x86
Msmdsrv.exe 2017.140.230.1 60612680 26-Sep-18 18:56 x64
Msmgdsrv.dll 2017.140.230.1 9004616 26-Sep-18 18:56 x64
Msmgdsrv.dll 2017.140.230.1 7310600 26-Sep-18 18:56 x86
Msolap.dll 2017.140.230.1 10258504 26-Sep-18 18:56 x64
Msolap.dll 2017.140.230.1 7777552 26-Sep-18 18:56 x86
Msolui.dll 2017.140.230.1 311056 26-Sep-18 18:56 x64
Msolui.dll 2017.140.230.1 287512 26-Sep-18 18:56 x86
Powerbiextensions.dll 2.57.5068.261 6606536 06-Jun-18 04:34 x86
Sql_as_keyfile.dll 2017.140.3045.24 100632 19-Oct-18 06:07 x64
Sqlboot.dll 2017.140.3045.24 196360 19-Oct-18 06:02 x64
Sqlceip.exe 14.0.3045.24 255560 19-Oct-18 06:21 x86
Sqldumper.exe 2017.140.3045.24 141384 19-Oct-18 06:13 x64
Sqldumper.exe 2017.140.3045.24 119368 19-Oct-18 06:13 x86
Tmapi.dll 2017.140.230.1 5821512 26-Sep-18 18:56 x64
Tmcachemgr.dll 2017.140.230.1 4164880 26-Sep-18 18:56 x64
Tmpersistence.dll 2017.140.230.1 1132104 26-Sep-18 18:56 x64
Tmtransactions.dll 2017.140.230.1 1641032 26-Sep-18 18:56 x64
Xe.dll 2017.140.3045.24 673352 19-Oct-18 06:06 x64
Xmlrw.dll 2017.140.3045.24 305416 19-Oct-18 06:07 x64
Xmlrw.dll 2017.140.3045.24 257816 19-Oct-18 06:13 x86
Xmlrwbin.dll 2017.140.3045.24 224536 19-Oct-18 06:02 x64
Xmlrwbin.dll 2017.140.3045.24 189512 19-Oct-18 06:06 x86
Xmsrv.dll 2017.140.230.1 25375512 26-Sep-18 18:56 x64
Xmsrv.dll 2017.140.230.1 33350728 26-Sep-18 18:56 x86
SQL Server 2017 Database Services Common Core
File name File version File size Date Time Platform
Batchparser.dll 2017.140.3045.24 181016 19-Oct-18 05:57 x64
Batchparser.dll 2017.140.3045.24 160536 19-Oct-18 06:02 x86
Instapi140.dll 2017.140.3045.24 61232 19-Oct-18 06:06 x86
Instapi140.dll 2017.140.3045.24 70936 19-Oct-18 06:07 x64
Isacctchange.dll 2017.140.3045.24 29448 19-Oct-18 06:06 x86
Isacctchange.dll 2017.140.3045.24 30792 19-Oct-18 06:15 x64
Microsoft.analysisservices.adomdclient.dll 14.0.230.1 1088792 26-Sep-18 18:56 x86
Microsoft.analysisservices.adomdclient.dll 14.0.230.1 1088792 26-Sep-18 18:56 x86
Microsoft.analysisservices.core.dll 14.0.230.1 1381640 26-Sep-18 18:56 x86
Microsoft.analysisservices.xmla.dll 14.0.230.1 741656 26-Sep-18 18:56 x86
Microsoft.analysisservices.xmla.dll 14.0.230.1 741648 26-Sep-18 18:56 x86
Microsoft.sqlserver.edition.dll 14.0.3045.24 37152 19-Oct-18 06:06 x86
Microsoft.sqlserver.mgdsqldumper.v4x.dll 2017.140.3045.24 78600 19-Oct-18 06:06 x86
Microsoft.sqlserver.mgdsqldumper.v4x.dll 2017.140.3045.24 81992 19-Oct-18 06:15 x64
Msasxpress.dll 2017.140.230.1 35912 26-Sep-18 18:56 x64
Msasxpress.dll 2017.140.230.1 32016 26-Sep-18 18:56 x86
Pbsvcacctsync.dll 2017.140.3045.24 82712 19-Oct-18 06:07 x64
Pbsvcacctsync.dll 2017.140.3045.24 68360 19-Oct-18 06:13 x86
Sql_common_core_keyfile.dll 2017.140.3045.24 100632 19-Oct-18 06:07 x64
Sqldumper.exe 2017.140.3045.24 141384 19-Oct-18 06:13 x64
Sqldumper.exe 2017.140.3045.24 119368 19-Oct-18 06:13 x86
Sqlftacct.dll 2017.140.3045.24 55600 19-Oct-18 06:21 x86
Sqlftacct.dll 2017.140.3045.24 62728 19-Oct-18 06:21 x64
Sqlmanager.dll 2017.140.17218.0 734952 21-Apr-18 00:33 x64
Sqlmanager.dll 2017.140.17218.0 602848 21-Apr-18 00:29 x86
Sqlmgmprovider.dll 2017.140.3045.24 373008 19-Oct-18 06:13 x86
Sqlmgmprovider.dll 2017.140.3045.24 416528 19-Oct-18 06:31 x64
Sqlsecacctchg.dll 2017.140.3045.24 35096 19-Oct-18 06:21 x86
Sqlsecacctchg.dll 2017.140.3045.24 37648 19-Oct-18 06:21 x64
Sqlsvcsync.dll 2017.140.3045.24 273480 19-Oct-18 06:06 x86
Sqlsvcsync.dll 2017.140.3045.24 356104 19-Oct-18 06:07 x64
Sqltdiagn.dll 2017.140.3045.24 60488 19-Oct-18 05:57 x86
Sqltdiagn.dll 2017.140.3045.24 67656 19-Oct-18 05:57 x64
Svrenumapi140.dll 2017.140.3045.24 1173776 19-Oct-18 06:07 x64
Svrenumapi140.dll 2017.140.3045.24 893704 19-Oct-18 06:13 x86
SQL Server 2017 sql_dreplay_client
File name File version File size Date Time Platform
Dreplayclient.exe 2017.140.3045.24 121104 19-Oct-18 06:20 x86
Dreplaycommon.dll 2017.140.3045.24 699144 19-Oct-18 06:13 x86
Dreplayserverps.dll 2017.140.3045.24 32840 19-Oct-18 06:02 x86
Dreplayutil.dll 2017.140.3045.24 310040 19-Oct-18 06:20 x86
Instapi140.dll 2017.140.3045.24 70936 19-Oct-18 06:07 x64
Sql_dreplay_client_keyfile.dll 2017.140.3045.24 100632 19-Oct-18 06:07 x64
Sqlresourceloader.dll 2017.140.3045.24 29256 19-Oct-18 05:56 x86
SQL Server 2017 sql_dreplay_controller
File name File version File size Date Time Platform
Dreplaycommon.dll 2017.140.3045.24 699144 19-Oct-18 06:13 x86
Dreplaycontroller.exe 2017.140.3045.24 350472 19-Oct-18 06:20 x86
Dreplayprocess.dll 2017.140.3045.24 171800 19-Oct-18 06:13 x86
Dreplayserverps.dll 2017.140.3045.24 32840 19-Oct-18 06:02 x86
Instapi140.dll 2017.140.3045.24 70936 19-Oct-18 06:07 x64
Sql_dreplay_controller_keyfile.dll 2017.140.3045.24 100632 19-Oct-18 06:07 x64
Sqlresourceloader.dll 2017.140.3045.24 29256 19-Oct-18 05:56 x86
SQL Server 2017 Database Services Core Instance
File name File version File size Date Time Platform
Batchparser.dll 2017.140.3045.24 181016 19-Oct-18 05:57 x64
C1.dll 18.10.40116.18 909312 20-Apr-18 23:43 x64
C2.dll 18.10.40116.18 5325312 20-Apr-18 23:43 x64
Cl.exe 18.10.40116.18 176128 20-Apr-18 23:43 x64
Databasemailprotocols.dll 14.0.17178.0 48352 21-Apr-18 00:28 x86
Datacollectorcontroller.dll 2017.140.3045.24 226576 19-Oct-18 06:15 x64
Dcexec.exe 2017.140.3045.24 74512 19-Oct-18 06:15 x64
Fssres.dll 2017.140.3045.24 89864 19-Oct-18 06:21 x64
Hadrres.dll 2017.140.3045.24 188168 19-Oct-18 06:21 x64
Hkcompile.dll 2017.140.3045.24 1423120 19-Oct-18 06:21 x64
Hkengine.dll 2017.140.3045.24 5858576 19-Oct-18 06:31 x64
Hkruntime.dll 2017.140.3045.24 162888 19-Oct-18 06:38 x64
Link.exe 12.10.40116.18 1001472 20-Apr-18 23:43 x64
Microsoft.analysisservices.applocal.xmla.dll 14.0.230.1 741136 26-Sep-18 18:56 x86
Microsoft.applicationinsights.dll 2.7.0.13435 329872 27-Jul-18 23:51 x86
Microsoft.sqlautoadmin.autobackupagent.dll 14.0.3045.24 237320 19-Oct-18 06:21 x86
Microsoft.sqlautoadmin.sqlautoadmin.dll 14.0.3045.24 79640 19-Oct-18 06:13 x86
Microsoft.sqlserver.vdiinterface.dll 2017.140.3045.24 71240 19-Oct-18 06:02 x64
Microsoft.sqlserver.xe.core.dll 2017.140.3045.24 65096 19-Oct-18 06:01 x64
Microsoft.sqlserver.xevent.configuration.dll 2017.140.3045.24 152336 19-Oct-18 06:13 x64
Microsoft.sqlserver.xevent.dll 2017.140.3045.24 159496 19-Oct-18 06:06 x64
Microsoft.sqlserver.xevent.linq.dll 2017.140.3045.24 304392 19-Oct-18 06:13 x64
Microsoft.sqlserver.xevent.targets.dll 2017.140.3045.24 75024 19-Oct-18 06:20 x64
Msobj120.dll 12.10.40116.18 113664 20-Apr-18 23:43 x64
Mspdb120.dll 12.10.40116.18 543232 20-Apr-18 23:43 x64
Mspdbcore.dll 12.10.40116.18 543232 20-Apr-18 23:43 x64
Msvcp120.dll 12.10.40116.18 645120 20-Apr-18 23:43 x64
Msvcr120.dll 12.10.40116.18 948736 20-Apr-18 23:43 x64
Odsole70.dll 2017.140.3045.24 92952 19-Oct-18 06:21 x64
Opends60.dll 2017.140.3045.24 33048 19-Oct-18 06:02 x64
Qds.dll 2017.140.3045.24 1173784 19-Oct-18 11:04 x64
Rsfxft.dll 2017.140.3045.24 34568 19-Oct-18 06:06 x64
Secforwarder.dll 2017.140.3045.24 37656 19-Oct-18 06:20 x64
Sqagtres.dll 2017.140.3045.24 74520 19-Oct-18 06:15 x64
Sql_engine_core_inst_keyfile.dll 2017.140.3045.24 100632 19-Oct-18 06:07 x64
Sqlaamss.dll 2017.140.3045.24 90392 19-Oct-18 06:21 x64
Sqlaccess.dll 2017.140.3045.24 475928 19-Oct-18 06:07 x64
Sqlagent.exe 2017.140.3045.24 582216 19-Oct-18 06:21 x64
Sqlagentctr140.dll 2017.140.3045.24 62232 19-Oct-18 06:13 x64
Sqlagentctr140.dll 2017.140.3045.24 53016 19-Oct-18 06:13 x86
Sqlagentlog.dll 2017.140.3045.24 32840 19-Oct-18 05:57 x64
Sqlagentmail.dll 2017.140.3045.24 54024 19-Oct-18 05:56 x64
Sqlboot.dll 2017.140.3045.24 196360 19-Oct-18 06:02 x64
Sqlceip.exe 14.0.3045.24 255560 19-Oct-18 06:21 x86
Sqlcmdss.dll 2017.140.3045.24 72776 19-Oct-18 06:15 x64
Sqlctr140.dll 2017.140.3045.24 112400 19-Oct-18 06:21 x86
Sqlctr140.dll 2017.140.3045.24 129304 19-Oct-18 06:21 x64
Sqldk.dll 2017.140.3045.24 2796312 19-Oct-18 11:08 x64
Sqldtsss.dll 2017.140.3045.24 107592 19-Oct-18 06:49 x64
Sqlevn70.rll 2017.140.3045.24 3291720 19-Oct-18 06:06 x64
Sqlevn70.rll 2017.140.3045.24 2090264 19-Oct-18 06:06 x64
Sqlevn70.rll 2017.140.3045.24 3297352 19-Oct-18 06:06 x64
Sqlevn70.rll 2017.140.3045.24 1498184 19-Oct-18 06:06 x64
Sqlevn70.rll 2017.140.3045.24 3482392 19-Oct-18 06:06 x64
Sqlevn70.rll 2017.140.3045.24 3636504 19-Oct-18 06:06 x64
Sqlevn70.rll 2017.140.3045.24 3915536 19-Oct-18 06:06 x64
Sqlevn70.rll 2017.140.3045.24 3677976 19-Oct-18 06:06 x64
Sqlevn70.rll 2017.140.3045.24 3785992 19-Oct-18 06:06 x64
Sqlevn70.rll 2017.140.3045.24 1445640 19-Oct-18 06:06 x64
Sqlevn70.rll 2017.140.3045.24 3339568 19-Oct-18 06:06 x64
Sqlevn70.rll 2017.140.3045.24 3821848 19-Oct-18 06:06 x64
Sqlevn70.rll 2017.140.3045.24 3597592 19-Oct-18 06:06 x64
Sqlevn70.rll 2017.140.3045.24 3787544 19-Oct-18 06:06 x64
Sqlevn70.rll 2017.140.3045.24 3918088 19-Oct-18 06:06 x64
Sqlevn70.rll 2017.140.3045.24 3214608 19-Oct-18 06:06 x64
Sqlevn70.rll 2017.140.3045.24 3403336 19-Oct-18 06:06 x64
Sqlevn70.rll 2017.140.3045.24 3589400 19-Oct-18 06:06 x64
Sqlevn70.rll 2017.140.3045.24 3780376 19-Oct-18 06:06 x64
Sqlevn70.rll 2017.140.3045.24 2037016 19-Oct-18 06:06 x64
Sqlevn70.rll 2017.140.3045.24 3368216 19-Oct-18 06:07 x64
Sqlevn70.rll 2017.140.3045.24 4027672 19-Oct-18 06:07 x64
Sqliosim.com 2017.140.3045.24 313416 19-Oct-18 06:20 x64
Sqliosim.exe 2017.140.3045.24 3019848 19-Oct-18 06:38 x64
Sqllang.dll 2017.140.3045.24 41245768 19-Oct-18 11:25 x64
Sqlmin.dll 2017.140.3045.24 40462600 19-Oct-18 11:22 x64
Sqlolapss.dll 2017.140.3045.24 107800 19-Oct-18 06:15 x64
Sqlos.dll 2017.140.3045.24 26376 19-Oct-18 06:20 x64
Sqlpowershellss.dll 2017.140.3045.24 68168 19-Oct-18 06:15 x64
Sqlrepss.dll 2017.140.3045.24 64584 19-Oct-18 06:07 x64
Sqlresld.dll 2017.140.3045.24 30792 19-Oct-18 05:57 x64
Sqlresourceloader.dll 2017.140.3045.24 32328 19-Oct-18 06:02 x64
Sqlscm.dll 2017.140.3045.24 71240 19-Oct-18 06:07 x64
Sqlscriptdowngrade.dll 2017.140.3045.24 27912 19-Oct-18 05:57 x64
Sqlscriptupgrade.dll 2017.140.3045.24 5872712 19-Oct-18 06:07 x64
Sqlserverspatial140.dll 2017.140.3045.24 732936 19-Oct-18 06:21 x64
Sqlservr.exe 2017.140.3045.24 487688 19-Oct-18 11:04 x64
Sqlsvc.dll 2017.140.3045.24 161864 19-Oct-18 06:15 x64
Sqltses.dll 2017.140.3045.24 9564952 19-Oct-18 11:08 x64
Sqsrvres.dll 2017.140.3045.24 261392 19-Oct-18 06:31 x64
Svl.dll 2017.140.3045.24 153864 19-Oct-18 06:38 x64
Xe.dll 2017.140.3045.24 673352 19-Oct-18 06:06 x64
Xmlrw.dll 2017.140.3045.24 305416 19-Oct-18 06:07 x64
Xmlrwbin.dll 2017.140.3045.24 224536 19-Oct-18 06:02 x64
Xpadsi.exe 2017.140.3045.24 89672 19-Oct-18 06:15 x64
Xplog70.dll 2017.140.3045.24 75848 19-Oct-18 06:38 x64
Xpqueue.dll 2017.140.3045.24 75016 19-Oct-18 06:07 x64
Xprepl.dll 2017.140.3045.24 102152 19-Oct-18 06:07 x64
Xpsqlbot.dll 2017.140.3045.24 32328 19-Oct-18 06:07 x64
Xpstar.dll 2017.140.3045.24 438344 19-Oct-18 06:21 x64
SQL Server 2017 Database Services Core Shared
File name File version File size Date Time Platform
Batchparser.dll 2017.140.3045.24 181016 19-Oct-18 05:57 x64
Batchparser.dll 2017.140.3045.24 160536 19-Oct-18 06:02 x86
Bcp.exe 2017.140.3045.24 120088 19-Oct-18 06:07 x64
Commanddest.dll 2017.140.3045.24 246024 19-Oct-18 06:15 x64
Datacollectorenumerators.dll 2017.140.3045.24 116296 19-Oct-18 06:15 x64
Datacollectortasks.dll 2017.140.3045.24 187464 19-Oct-18 06:15 x64
Distrib.exe 2017.140.3045.24 203528 19-Oct-18 06:15 x64
Dteparse.dll 2017.140.3045.24 111384 19-Oct-18 06:15 x64
Dteparsemgd.dll 2017.140.3045.24 89352 19-Oct-18 06:07 x64
Dtepkg.dll 2017.140.3045.24 138000 19-Oct-18 06:15 x64
Dtexec.exe 2017.140.3045.24 73992 19-Oct-18 06:21 x64
Dts.dll 2017.140.3045.24 2999064 19-Oct-18 06:21 x64
Dtscomexpreval.dll 2017.140.3045.24 475400 19-Oct-18 06:15 x64
Dtsconn.dll 2017.140.3045.24 497416 19-Oct-18 06:15 x64
Dtshost.exe 2017.140.3045.24 104712 19-Oct-18 06:15 x64
Dtslog.dll 2017.140.3045.24 120600 19-Oct-18 06:15 x64
Dtsmsg140.dll 2017.140.3045.24 545352 19-Oct-18 06:02 x64
Dtspipeline.dll 2017.140.3045.24 1266440 19-Oct-18 06:21 x64
Dtspipelineperf140.dll 2017.140.3045.24 48408 19-Oct-18 06:15 x64
Dtuparse.dll 2017.140.3045.24 89368 19-Oct-18 06:15 x64
Dtutil.exe 2017.140.3045.24 147224 19-Oct-18 06:15 x64
Exceldest.dll 2017.140.3045.24 260680 19-Oct-18 06:15 x64
Excelsrc.dll 2017.140.3045.24 282888 19-Oct-18 06:15 x64
Execpackagetask.dll 2017.140.3045.24 168008 19-Oct-18 06:15 x64
Flatfiledest.dll 2017.140.3045.24 386832 19-Oct-18 06:15 x64
Flatfilesrc.dll 2017.140.3045.24 399112 19-Oct-18 06:15 x64
Foreachfileenumerator.dll 2017.140.3045.24 96520 19-Oct-18 06:15 x64
Hkengperfctrs.dll 2017.140.3045.24 59656 19-Oct-18 06:21 x64
Logread.exe 2017.140.3045.24 635160 19-Oct-18 06:21 x64
Mergetxt.dll 2017.140.3045.24 63752 19-Oct-18 06:15 x64
Microsoft.analysisservices.applocal.core.dll 14.0.230.1 1381440 26-Sep-18 18:56 x86
Microsoft.data.datafeedclient.dll 13.1.1.0 171208 21-Apr-18 00:24 x86
Microsoft.exceptionmessagebox.dll 14.0.3045.24 137800 19-Oct-18 06:13 x86
Microsoft.sqlserver.integrationservice.hadoopcomponents.dll 14.0.3045.24 89672 19-Oct-18 06:38 x86
Microsoft.sqlserver.manageddts.dll 14.0.3045.24 613960 19-Oct-18 06:21 x86
Microsoft.sqlserver.replication.dll 2017.140.3045.24 1663760 19-Oct-18 06:31 x64
Microsoft.sqlserver.xevent.configuration.dll 2017.140.3045.24 152336 19-Oct-18 06:13 x64
Microsoft.sqlserver.xevent.dll 2017.140.3045.24 159496 19-Oct-18 06:06 x64
Msdtssrvrutil.dll 2017.140.3045.24 103496 19-Oct-18 06:15 x64
Msgprox.dll 2017.140.3045.24 270408 19-Oct-18 06:15 x64
Msxmlsql.dll 2017.140.3045.24 1448216 19-Oct-18 06:15 x64
Oledbdest.dll 2017.140.3045.24 261192 19-Oct-18 06:15 x64
Oledbsrc.dll 2017.140.3045.24 289040 19-Oct-18 06:21 x64
Osql.exe 2017.140.3045.24 75336 19-Oct-18 06:02 x64
Qrdrsvc.exe 2017.140.3045.24 473672 19-Oct-18 06:15 x64
Rawdest.dll 2017.140.3045.24 206600 19-Oct-18 06:15 x64
Rawsource.dll 2017.140.3045.24 194120 19-Oct-18 06:15 x64
Rdistcom.dll 2017.140.3045.24 857360 19-Oct-18 06:15 x64
Recordsetdest.dll 2017.140.3045.24 184392 19-Oct-18 06:15 x64
Replagnt.dll 2017.140.3045.24 30792 19-Oct-18 06:07 x64
Repldp.dll 2017.140.3045.24 291080 19-Oct-18 06:15 x64
Replerrx.dll 2017.140.3045.24 154392 19-Oct-18 06:15 x64
Replisapi.dll 2017.140.3045.24 362256 19-Oct-18 06:21 x64
Replmerg.exe 2017.140.3045.24 525064 19-Oct-18 06:31 x64
Replprov.dll 2017.140.3045.24 802080 19-Oct-18 06:21 x64
Replrec.dll 2017.140.3045.24 975432 19-Oct-18 06:15 x64
Replsub.dll 2017.140.3045.24 445704 19-Oct-18 06:15 x64
Replsync.dll 2017.140.3045.24 154184 19-Oct-18 06:15 x64
Spresolv.dll 2017.140.3045.24 251976 19-Oct-18 06:15 x64
Sql_engine_core_shared_keyfile.dll 2017.140.3045.24 100632 19-Oct-18 06:07 x64
Sqlcmd.exe 2017.140.3045.24 248904 19-Oct-18 06:02 x64
Sqldiag.exe 2017.140.3045.24 1257544 19-Oct-18 06:07 x64
Sqldistx.dll 2017.140.3045.24 225560 19-Oct-18 06:15 x64
Sqllogship.exe 14.0.3045.24 105544 19-Oct-18 06:07 x64
Sqlmergx.dll 2017.140.3045.24 360520 19-Oct-18 06:15 x64
Sqlresld.dll 2017.140.3045.24 30792 19-Oct-18 05:57 x64
Sqlresld.dll 2017.140.3045.24 28744 19-Oct-18 06:02 x86
Sqlresourceloader.dll 2017.140.3045.24 29256 19-Oct-18 05:56 x86
Sqlresourceloader.dll 2017.140.3045.24 32328 19-Oct-18 06:02 x64
Sqlscm.dll 2017.140.3045.24 71240 19-Oct-18 06:07 x64
Sqlscm.dll 2017.140.3045.24 61208 19-Oct-18 06:13 x86
Sqlsvc.dll 2017.140.3045.24 134728 19-Oct-18 06:13 x86
Sqlsvc.dll 2017.140.3045.24 161864 19-Oct-18 06:15 x64
Sqltaskconnections.dll 2017.140.3045.24 184088 19-Oct-18 06:15 x64
Sqlwep140.dll 2017.140.3045.24 105544 19-Oct-18 06:02 x64
Ssdebugps.dll 2017.140.3045.24 33544 19-Oct-18 06:21 x64
Ssisoledb.dll 2017.140.3045.24 216328 19-Oct-18 06:07 x64
Ssradd.dll 2017.140.3045.24 75528 19-Oct-18 06:07 x64
Ssravg.dll 2017.140.3045.24 75848 19-Oct-18 06:07 x64
Ssrdown.dll 2017.140.3045.24 60696 19-Oct-18 06:15 x64
Ssrmax.dll 2017.140.3045.24 73480 19-Oct-18 06:07 x64
Ssrmin.dll 2017.140.3045.24 73992 19-Oct-18 06:15 x64
Ssrpub.dll 2017.140.3045.24 61704 19-Oct-18 06:15 x64
Ssrup.dll 2017.140.3045.24 60680 19-Oct-18 06:15 x64
Txagg.dll 2017.140.3045.24 362248 19-Oct-18 06:15 x64
Txbdd.dll 2017.140.3045.24 170248 19-Oct-18 06:15 x64
Txdatacollector.dll 2017.140.3045.24 360720 19-Oct-18 06:15 x64
Txdataconvert.dll 2017.140.3045.24 293144 19-Oct-18 06:15 x64
Txderived.dll 2017.140.3045.24 604432 19-Oct-18 06:15 x64
Txlookup.dll 2017.140.3045.24 528152 19-Oct-18 06:15 x64
Txmerge.dll 2017.140.3045.24 230472 19-Oct-18 06:15 x64
Txmergejoin.dll 2017.140.3045.24 275528 19-Oct-18 06:15 x64
Txmulticast.dll 2017.140.3045.24 127560 19-Oct-18 06:15 x64
Txrowcount.dll 2017.140.3045.24 125512 19-Oct-18 06:15 x64
Txsort.dll 2017.140.3045.24 257096 19-Oct-18 06:15 x64
Txsplit.dll 2017.140.3045.24 596744 19-Oct-18 06:15 x64
Txunionall.dll 2017.140.3045.24 181832 19-Oct-18 06:15 x64
Xe.dll 2017.140.3045.24 673352 19-Oct-18 06:06 x64
Xmlrw.dll 2017.140.3045.24 305416 19-Oct-18 06:07 x64
Xmlsub.dll 2017.140.3045.24 261384 19-Oct-18 06:15 x64
SQL Server 2017 sql_extensibility
File name File version File size Date Time Platform
Launchpad.exe 2017.140.3045.24 1124616 19-Oct-18 06:49 x64
Sql_extensibility_keyfile.dll 2017.140.3045.24 100632 19-Oct-18 06:07 x64
Sqlsatellite.dll 2017.140.3045.24 922184 19-Oct-18 06:43 x64
SQL Server 2017 Full-Text Engine
File name File version File size Date Time Platform
Fd.dll 2017.140.3045.24 667400 19-Oct-18 06:07 x64
Fdhost.exe 2017.140.3045.24 114960 19-Oct-18 06:31 x64
Fdlauncher.exe 2017.140.3045.24 62736 19-Oct-18 06:15 x64
Sql_fulltext_keyfile.dll 2017.140.3045.24 100632 19-Oct-18 06:07 x64
Sqlft140ph.dll 2017.140.3045.24 68400 19-Oct-18 06:15 x64
SQL Server 2017 sql_inst_mr
File name File version File size Date Time Platform
Imrdll.dll 14.0.3045.24 23624 19-Oct-18 06:07 x86
Sql_inst_mr_keyfile.dll 2017.140.3045.24 100632 19-Oct-18 06:07 x64
SQL Server 2017 Integration Services
File name File version File size Date Time Platform
Attunity.sqlserver.cdccontroltask.dll 5.0.0.70 75248 21-Apr-18 00:28 x86
Attunity.sqlserver.cdcsplit.dll 5.0.0.70 36336 21-Apr-18 00:28 x86
Attunity.sqlserver.cdcsrc.dll 5.0.0.70 76272 21-Apr-18 00:28 x86
Commanddest.dll 2017.140.3045.24 201008 19-Oct-18 06:13 x86
Commanddest.dll 2017.140.3045.24 246024 19-Oct-18 06:15 x64
Dteparse.dll 2017.140.3045.24 100624 19-Oct-18 06:13 x86
Dteparse.dll 2017.140.3045.24 111384 19-Oct-18 06:15 x64
Dteparsemgd.dll 2017.140.3045.24 89352 19-Oct-18 06:07 x64
Dteparsemgd.dll 2017.140.3045.24 83736 19-Oct-18 06:13 x86
Dtepkg.dll 2017.140.3045.24 138000 19-Oct-18 06:15 x64
Dtepkg.dll 2017.140.3045.24 117008 19-Oct-18 06:20 x86
Dtexec.exe 2017.140.3045.24 73992 19-Oct-18 06:21 x64
Dtexec.exe 2017.140.3045.24 67848 19-Oct-18 06:31 x86
Dts.dll 2017.140.3045.24 2549512 19-Oct-18 06:20 x86
Dts.dll 2017.140.3045.24 2999064 19-Oct-18 06:21 x64
Dtscomexpreval.dll 2017.140.3045.24 418072 19-Oct-18 06:13 x86
Dtscomexpreval.dll 2017.140.3045.24 475400 19-Oct-18 06:15 x64
Dtsconn.dll 2017.140.3045.24 399640 19-Oct-18 06:13 x86
Dtsconn.dll 2017.140.3045.24 497416 19-Oct-18 06:15 x64
Dtsdebughost.exe 2017.140.3045.24 111176 19-Oct-18 06:15 x64
Dtsdebughost.exe 2017.140.3045.24 95512 19-Oct-18 06:20 x86
Dtshost.exe 2017.140.3045.24 89880 19-Oct-18 06:13 x86
Dtshost.exe 2017.140.3045.24 104712 19-Oct-18 06:15 x64
Dtslog.dll 2017.140.3045.24 103192 19-Oct-18 06:13 x86
Dtslog.dll 2017.140.3045.24 120600 19-Oct-18 06:15 x64
Dtsmsg140.dll 2017.140.3045.24 545352 19-Oct-18 06:02 x64
Dtsmsg140.dll 2017.140.3045.24 541488 19-Oct-18 06:06 x86
Dtspipeline.dll 2017.140.3045.24 1266440 19-Oct-18 06:21 x64
Dtspipeline.dll 2017.140.3045.24 1059400 19-Oct-18 06:31 x86
Dtspipelineperf140.dll 2017.140.3045.24 42760 19-Oct-18 06:13 x86
Dtspipelineperf140.dll 2017.140.3045.24 48408 19-Oct-18 06:15 x64
Dtuparse.dll 2017.140.3045.24 80144 19-Oct-18 06:13 x86
Dtuparse.dll 2017.140.3045.24 89368 19-Oct-18 06:15 x64
Dtutil.exe 2017.140.3045.24 126232 19-Oct-18 06:13 x86
Dtutil.exe 2017.140.3045.24 147224 19-Oct-18 06:15 x64
Exceldest.dll 2017.140.3045.24 214808 19-Oct-18 06:13 x86
Exceldest.dll 2017.140.3045.24 260680 19-Oct-18 06:15 x64
Excelsrc.dll 2017.140.3045.24 230680 19-Oct-18 06:13 x86
Excelsrc.dll 2017.140.3045.24 282888 19-Oct-18 06:15 x64
Execpackagetask.dll 2017.140.3045.24 135448 19-Oct-18 06:13 x86
Execpackagetask.dll 2017.140.3045.24 168008 19-Oct-18 06:15 x64
Flatfiledest.dll 2017.140.3045.24 333080 19-Oct-18 06:13 x86
Flatfiledest.dll 2017.140.3045.24 386832 19-Oct-18 06:15 x64
Flatfilesrc.dll 2017.140.3045.24 344344 19-Oct-18 06:13 x86
Flatfilesrc.dll 2017.140.3045.24 399112 19-Oct-18 06:15 x64
Foreachfileenumerator.dll 2017.140.3045.24 80656 19-Oct-18 06:13 x86
Foreachfileenumerator.dll 2017.140.3045.24 96520 19-Oct-18 06:15 x64
Isdeploymentwizard.exe 14.0.3045.24 467016 19-Oct-18 07:00 x86
Isdeploymentwizard.exe 14.0.3045.24 466696 19-Oct-18 07:00 x64
Isserverexec.exe 14.0.3045.24 149264 19-Oct-18 06:20 x86
Isserverexec.exe 14.0.3045.24 148552 19-Oct-18 06:38 x64
Microsoft.analysisservices.applocal.core.dll 14.0.230.1 1381440 26-Sep-18 18:56 x86
Microsoft.analysisservices.applocal.core.dll 14.0.230.1 1381448 26-Sep-18 18:56 x86
Microsoft.applicationinsights.dll 2.7.0.13435 329872 27-Jul-18 23:51 x86
Microsoft.data.datafeedclient.dll 13.1.1.0 171208 21-Apr-18 00:24 x86
Microsoft.sqlserver.astasks.dll 14.0.3045.24 72776 19-Oct-18 06:21 x86
Microsoft.sqlserver.bulkinserttaskconnections.dll 2017.140.3045.24 112200 19-Oct-18 06:07 x64
Microsoft.sqlserver.bulkinserttaskconnections.dll 2017.140.3045.24 107080 19-Oct-18 06:13 x86
Microsoft.sqlserver.integrationservice.hadoopcomponents.dll 14.0.3045.24 89872 19-Oct-18 06:20 x86
Microsoft.sqlserver.integrationservice.hadoopcomponents.dll 14.0.3045.24 89672 19-Oct-18 06:38 x86
Microsoft.sqlserver.integrationservices.isserverdbupgrade.dll 14.0.3045.24 494664 19-Oct-18 06:07 x86
Microsoft.sqlserver.integrationservices.isserverdbupgrade.dll 14.0.3045.24 494872 19-Oct-18 06:13 x86
Microsoft.sqlserver.integrationservices.server.dll 14.0.3045.24 83736 19-Oct-18 06:13 x86
Microsoft.sqlserver.integrationservices.server.dll 14.0.3045.24 83736 19-Oct-18 06:15 x86
Microsoft.sqlserver.integrationservices.wizard.common.dll 14.0.3045.24 415816 19-Oct-18 06:49 x86
Microsoft.sqlserver.integrationservices.wizard.common.dll 14.0.3045.24 415816 19-Oct-18 07:00 x86
Microsoft.sqlserver.manageddts.dll 14.0.3045.24 613960 19-Oct-18 06:13 x86
Microsoft.sqlserver.manageddts.dll 14.0.3045.24 613960 19-Oct-18 06:21 x86
Microsoft.sqlserver.management.integrationservices.dll 14.0.3045.24 252696 19-Oct-18 06:13 x86
Microsoft.sqlserver.management.integrationservices.dll 14.0.3045.24 252680 19-Oct-18 06:15 x86
Microsoft.sqlserver.xevent.configuration.dll 2017.140.3045.24 152336 19-Oct-18 06:13 x64
Microsoft.sqlserver.xevent.configuration.dll 2017.140.3045.24 141896 19-Oct-18 06:21 x86
Microsoft.sqlserver.xevent.dll 2017.140.3045.24 159496 19-Oct-18 06:06 x64
Microsoft.sqlserver.xevent.dll 2017.140.3045.24 145480 19-Oct-18 06:13 x86
Msdtssrvr.exe 14.0.3045.24 219928 19-Oct-18 06:21 x64
Msdtssrvrutil.dll 2017.140.3045.24 90392 19-Oct-18 06:13 x86
Msdtssrvrutil.dll 2017.140.3045.24 103496 19-Oct-18 06:15 x64
Msmdpp.dll 2017.140.230.1 9194272 26-Sep-18 18:56 x64
Oledbdest.dll 2017.140.3045.24 214808 19-Oct-18 06:13 x86
Oledbdest.dll 2017.140.3045.24 261192 19-Oct-18 06:15 x64
Oledbsrc.dll 2017.140.3045.24 233240 19-Oct-18 06:13 x86
Oledbsrc.dll 2017.140.3045.24 289040 19-Oct-18 06:21 x64
Rawdest.dll 2017.140.3045.24 166680 19-Oct-18 06:13 x86
Rawdest.dll 2017.140.3045.24 206600 19-Oct-18 06:15 x64
Rawsource.dll 2017.140.3045.24 153368 19-Oct-18 06:13 x86
Rawsource.dll 2017.140.3045.24 194120 19-Oct-18 06:15 x64
Recordsetdest.dll 2017.140.3045.24 149272 19-Oct-18 06:13 x86
Recordsetdest.dll 2017.140.3045.24 184392 19-Oct-18 06:15 x64
Sql_is_keyfile.dll 2017.140.3045.24 100632 19-Oct-18 06:07 x64
Sqlceip.exe 14.0.3045.24 255560 19-Oct-18 06:21 x86
Sqldest.dll 2017.140.3045.24 213784 19-Oct-18 06:13 x86
Sqldest.dll 2017.140.3045.24 260888 19-Oct-18 06:15 x64
Sqltaskconnections.dll 2017.140.3045.24 155416 19-Oct-18 06:13 x86
Sqltaskconnections.dll 2017.140.3045.24 184088 19-Oct-18 06:15 x64
Ssisoledb.dll 2017.140.3045.24 216328 19-Oct-18 06:07 x64
Ssisoledb.dll 2017.140.3045.24 176920 19-Oct-18 06:13 x86
Txagg.dll 2017.140.3045.24 302360 19-Oct-18 06:13 x86
Txagg.dll 2017.140.3045.24 362248 19-Oct-18 06:15 x64
Txbdd.dll 2017.140.3045.24 139552 19-Oct-18 06:13 x86
Txbdd.dll 2017.140.3045.24 170248 19-Oct-18 06:15 x64
Txbestmatch.dll 2017.140.3045.24 493336 19-Oct-18 06:13 x86
Txbestmatch.dll 2017.140.3045.24 605472 19-Oct-18 06:15 x64
Txcache.dll 2017.140.3045.24 146192 19-Oct-18 06:13 x86
Txcache.dll 2017.140.3045.24 180488 19-Oct-18 06:15 x64
Txcharmap.dll 2017.140.3045.24 249112 19-Oct-18 06:13 x86
Txcharmap.dll 2017.140.3045.24 286984 19-Oct-18 06:15 x64
Txcopymap.dll 2017.140.3045.24 145680 19-Oct-18 06:13 x86
Txcopymap.dll 2017.140.3045.24 180296 19-Oct-18 06:15 x64
Txdataconvert.dll 2017.140.3045.24 253200 19-Oct-18 06:13 x86
Txdataconvert.dll 2017.140.3045.24 293144 19-Oct-18 06:15 x64
Txderived.dll 2017.140.3045.24 515888 19-Oct-18 06:13 x86
Txderived.dll 2017.140.3045.24 604432 19-Oct-18 06:15 x64
Txfileextractor.dll 2017.140.3045.24 161048 19-Oct-18 06:13 x86
Txfileextractor.dll 2017.140.3045.24 198928 19-Oct-18 06:15 x64
Txfileinserter.dll 2017.140.3045.24 159512 19-Oct-18 06:13 x86
Txfileinserter.dll 2017.140.3045.24 196680 19-Oct-18 06:15 x64
Txgroupdups.dll 2017.140.3045.24 231192 19-Oct-18 06:13 x86
Txgroupdups.dll 2017.140.3045.24 290568 19-Oct-18 06:15 x64
Txlineage.dll 2017.140.3045.24 110384 19-Oct-18 06:13 x86
Txlineage.dll 2017.140.3045.24 136776 19-Oct-18 06:15 x64
Txlookup.dll 2017.140.3045.24 446752 19-Oct-18 06:13 x86
Txlookup.dll 2017.140.3045.24 528152 19-Oct-18 06:15 x64
Txmerge.dll 2017.140.3045.24 177456 19-Oct-18 06:13 x86
Txmerge.dll 2017.140.3045.24 230472 19-Oct-18 06:15 x64
Txmergejoin.dll 2017.140.3045.24 221968 19-Oct-18 06:13 x86
Txmergejoin.dll 2017.140.3045.24 275528 19-Oct-18 06:15 x64
Txmulticast.dll 2017.140.3045.24 102672 19-Oct-18 06:13 x86
Txmulticast.dll 2017.140.3045.24 127560 19-Oct-18 06:15 x64
Txpivot.dll 2017.140.3045.24 180512 19-Oct-18 06:13 x86
Txpivot.dll 2017.140.3045.24 224840 19-Oct-18 06:15 x64
Txrowcount.dll 2017.140.3045.24 101656 19-Oct-18 06:13 x86
Txrowcount.dll 2017.140.3045.24 125512 19-Oct-18 06:15 x64
Txsampling.dll 2017.140.3045.24 135952 19-Oct-18 06:13 x86
Txsampling.dll 2017.140.3045.24 174152 19-Oct-18 06:15 x64
Txscd.dll 2017.140.3045.24 170264 19-Oct-18 06:13 x86
Txscd.dll 2017.140.3045.24 220936 19-Oct-18 06:15 x64
Txsort.dll 2017.140.3045.24 208672 19-Oct-18 06:13 x86
Txsort.dll 2017.140.3045.24 257096 19-Oct-18 06:15 x64
Txsplit.dll 2017.140.3045.24 596744 19-Oct-18 06:15 x64
Txsplit.dll 2017.140.3045.24 510768 19-Oct-18 06:21 x86
Txtermextraction.dll 2017.140.3045.24 8676424 19-Oct-18 06:15 x64
Txtermextraction.dll 2017.140.3045.24 8615192 19-Oct-18 06:21 x86
Txtermlookup.dll 2017.140.3045.24 4107024 19-Oct-18 06:13 x86
Txtermlookup.dll 2017.140.3045.24 4157232 19-Oct-18 06:15 x64
Txunionall.dll 2017.140.3045.24 140056 19-Oct-18 06:13 x86
Txunionall.dll 2017.140.3045.24 181832 19-Oct-18 06:15 x64
Txunpivot.dll 2017.140.3045.24 160536 19-Oct-18 06:13 x86
Txunpivot.dll 2017.140.3045.24 199752 19-Oct-18 06:15 x64
Xe.dll 2017.140.3045.24 673352 19-Oct-18 06:06 x64
Xe.dll 2017.140.3045.24 595736 19-Oct-18 06:06 x86
SQL Server 2017 sql_polybase_core_inst
File name File version File size Date Time Platform
Dms.dll 13.0.9124.18 523944 21-Apr-18 00:47 x86
Dmsnative.dll 2016.130.9124.18 78504 21-Apr-18 00:47 x64
Dwengineservice.dll 13.0.9124.18 45736 21-Apr-18 00:47 x86
Instapi140.dll 2017.140.3045.24 70936 19-Oct-18 06:07 x64
Microsoft.sqlserver.datawarehouse.backup.backupmetadata.dll 13.0.9124.18 74928 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.catalog.dll 13.0.9124.18 213672 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.common.dll 13.0.9124.18 1799336 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.configuration.dll 13.0.9124.18 116904 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.datamovement.common.dll 13.0.9124.18 390312 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.datamovement.manager.dll 13.0.9124.18 196272 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.datamovement.messagetypes.dll 13.0.9124.18 131248 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.datamovement.messagingprotocol.dll 13.0.9124.18 63144 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.diagnostics.dll 13.0.9124.18 55464 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.distributor.dll 13.0.9124.18 93872 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.engine.dll 13.0.9124.18 792752 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.engine.statsstream.dll 13.0.9124.18 87720 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.eventing.dll 13.0.9124.18 78000 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.fabric.appliance.dll 13.0.9124.18 42152 21-Apr-18 00:49 x86
Microsoft.sqlserver.datawarehouse.fabric.interface.dll 13.0.9124.18 37032 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.fabric.polybase.dll 13.0.9124.18 47792 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.fabric.xdbinterface.dll 13.0.9124.18 27304 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.failover.dll 13.0.9124.18 32424 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.hadoop.hadoopbridge.dll 13.0.9124.18 129704 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.loadercommon.dll 13.0.9124.18 95400 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.loadmanager.dll 13.0.9124.18 109232 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.localization.dll 13.0.9124.18 264360 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.localization.resources.dll 13.0.9124.18 105128 21-Apr-18 00:46 x86
Microsoft.sqlserver.datawarehouse.localization.resources.dll 13.0.9124.18 119464 21-Apr-18 00:48 x86
Microsoft.sqlserver.datawarehouse.localization.resources.dll 13.0.9124.18 122536 21-Apr-18 00:46 x86
Microsoft.sqlserver.datawarehouse.localization.resources.dll 13.0.9124.18 118952 21-Apr-18 00:49 x86
Microsoft.sqlserver.datawarehouse.localization.resources.dll 13.0.9124.18 129192 21-Apr-18 00:46 x86
Microsoft.sqlserver.datawarehouse.localization.resources.dll 13.0.9124.18 121512 21-Apr-18 00:46 x86
Microsoft.sqlserver.datawarehouse.localization.resources.dll 13.0.9124.18 116392 21-Apr-18 00:50 x86
Microsoft.sqlserver.datawarehouse.localization.resources.dll 13.0.9124.18 149680 21-Apr-18 00:46 x86
Microsoft.sqlserver.datawarehouse.localization.resources.dll 13.0.9124.18 103080 21-Apr-18 00:46 x86
Microsoft.sqlserver.datawarehouse.localization.resources.dll 13.0.9124.18 118440 21-Apr-18 00:50 x86
Microsoft.sqlserver.datawarehouse.nodes.dll 13.0.9124.18 70312 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.nulltransaction.dll 13.0.9124.18 28840 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.parallelizer.dll 13.0.9124.18 43688 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.resourcemanagement.dll 13.0.9124.18 83624 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.setup.componentupgradelibrary.dll 13.0.9124.18 136872 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.sql.dll 13.0.9124.18 2341040 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.sql.parser.dll 13.0.9124.18 3860136 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.sql.parser.resources.dll 13.0.9124.18 110760 21-Apr-18 00:46 x86
Microsoft.sqlserver.datawarehouse.sql.parser.resources.dll 13.0.9124.18 123560 21-Apr-18 00:48 x86
Microsoft.sqlserver.datawarehouse.sql.parser.resources.dll 13.0.9124.18 128176 21-Apr-18 00:46 x86
Microsoft.sqlserver.datawarehouse.sql.parser.resources.dll 13.0.9124.18 124080 21-Apr-18 00:49 x86
Microsoft.sqlserver.datawarehouse.sql.parser.resources.dll 13.0.9124.18 136872 21-Apr-18 00:46 x86
Microsoft.sqlserver.datawarehouse.sql.parser.resources.dll 13.0.9124.18 124584 21-Apr-18 00:46 x86
Microsoft.sqlserver.datawarehouse.sql.parser.resources.dll 13.0.9124.18 121512 21-Apr-18 00:50 x86
Microsoft.sqlserver.datawarehouse.sql.parser.resources.dll 13.0.9124.18 156328 21-Apr-18 00:46 x86
Microsoft.sqlserver.datawarehouse.sql.parser.resources.dll 13.0.9124.18 108712 21-Apr-18 00:46 x86
Microsoft.sqlserver.datawarehouse.sql.parser.resources.dll 13.0.9124.18 123048 21-Apr-18 00:50 x86
Microsoft.sqlserver.datawarehouse.sqldistributor.dll 13.0.9124.18 70312 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.transactsql.scriptdom.dll 13.0.9124.18 2756264 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.utilities.dll 13.0.9124.18 751784 21-Apr-18 00:47 x86
Mpdwinterop.dll 2017.140.3045.24 407312 19-Oct-18 06:21 x64
Mpdwsvc.exe 2017.140.3045.24 7325768 19-Oct-18 06:37 x64
Pdwodbcsql11.dll 2017.140.3045.24 2263112 19-Oct-18 06:02 x64
Secforwarder.dll 2017.140.3045.24 37656 19-Oct-18 06:20 x64
Sharedmemory.dll 2016.130.9124.18 64688 21-Apr-18 00:19 x64
Sqldk.dll 2017.140.3045.24 2730248 19-Oct-18 06:43 x64
Sqldumper.exe 2017.140.3045.24 141384 19-Oct-18 06:13 x64
Sqlevn70.rll 2017.140.3045.24 1498184 19-Oct-18 06:06 x64
Sqlevn70.rll 2017.140.3045.24 3915536 19-Oct-18 06:06 x64
Sqlevn70.rll 2017.140.3045.24 3214608 19-Oct-18 06:06 x64
Sqlevn70.rll 2017.140.3045.24 3918088 19-Oct-18 06:06 x64
Sqlevn70.rll 2017.140.3045.24 3821848 19-Oct-18 06:06 x64
Sqlevn70.rll 2017.140.3045.24 2090264 19-Oct-18 06:06 x64
Sqlevn70.rll 2017.140.3045.24 2037016 19-Oct-18 06:06 x64
Sqlevn70.rll 2017.140.3045.24 3589400 19-Oct-18 06:06 x64
Sqlevn70.rll 2017.140.3045.24 3597592 19-Oct-18 06:06 x64
Sqlevn70.rll 2017.140.3045.24 1445640 19-Oct-18 06:06 x64
Sqlevn70.rll 2017.140.3045.24 3785992 19-Oct-18 06:06 x64
Sqlos.dll 2017.140.3045.24 26376 19-Oct-18 06:20 x64
Sqlsortpdw.dll 2016.130.9124.18 4348072 21-Apr-18 00:47 x64
Sqltses.dll 2017.140.3045.24 9734920 19-Oct-18 06:43 x64
SQL Server 2017 sql_shared_mr
File name File version File size Date Time Platform
Smrdll.dll 14.0.3045.24 23824 19-Oct-18 06:07 x86
Sql_engine_core_shared_keyfile.dll 2017.140.3045.24 100632 19-Oct-18 06:07 x64
SQL Server 2017 sql_tools_extensions
File name File version File size Date Time Platform
Autoadmin.dll 2017.140.3045.24 1448520 19-Oct-18 06:30 x86
Dtaengine.exe 2017.140.3045.24 204560 19-Oct-18 06:30 x86
Dteparse.dll 2017.140.3045.24 100624 19-Oct-18 06:13 x86
Dteparse.dll 2017.140.3045.24 111384 19-Oct-18 06:15 x64
Dteparsemgd.dll 2017.140.3045.24 89352 19-Oct-18 06:07 x64
Dteparsemgd.dll 2017.140.3045.24 83736 19-Oct-18 06:13 x86
Dtepkg.dll 2017.140.3045.24 138000 19-Oct-18 06:15 x64
Dtepkg.dll 2017.140.3045.24 117008 19-Oct-18 06:20 x86
Dtexec.exe 2017.140.3045.24 73992 19-Oct-18 06:21 x64
Dtexec.exe 2017.140.3045.24 67848 19-Oct-18 06:31 x86
Dts.dll 2017.140.3045.24 2549512 19-Oct-18 06:20 x86
Dts.dll 2017.140.3045.24 2999064 19-Oct-18 06:21 x64
Dtscomexpreval.dll 2017.140.3045.24 418072 19-Oct-18 06:13 x86
Dtscomexpreval.dll 2017.140.3045.24 475400 19-Oct-18 06:15 x64
Dtsconn.dll 2017.140.3045.24 399640 19-Oct-18 06:13 x86
Dtsconn.dll 2017.140.3045.24 497416 19-Oct-18 06:15 x64
Dtshost.exe 2017.140.3045.24 89880 19-Oct-18 06:13 x86
Dtshost.exe 2017.140.3045.24 104712 19-Oct-18 06:15 x64
Dtslog.dll 2017.140.3045.24 103192 19-Oct-18 06:13 x86
Dtslog.dll 2017.140.3045.24 120600 19-Oct-18 06:15 x64
Dtsmsg140.dll 2017.140.3045.24 545352 19-Oct-18 06:02 x64
Dtsmsg140.dll 2017.140.3045.24 541488 19-Oct-18 06:06 x86
Dtspipeline.dll 2017.140.3045.24 1266440 19-Oct-18 06:21 x64
Dtspipeline.dll 2017.140.3045.24 1059400 19-Oct-18 06:31 x86
Dtspipelineperf140.dll 2017.140.3045.24 42760 19-Oct-18 06:13 x86
Dtspipelineperf140.dll 2017.140.3045.24 48408 19-Oct-18 06:15 x64
Dtuparse.dll 2017.140.3045.24 80144 19-Oct-18 06:13 x86
Dtuparse.dll 2017.140.3045.24 89368 19-Oct-18 06:15 x64
Dtutil.exe 2017.140.3045.24 126232 19-Oct-18 06:13 x86
Dtutil.exe 2017.140.3045.24 147224 19-Oct-18 06:15 x64
Exceldest.dll 2017.140.3045.24 214808 19-Oct-18 06:13 x86
Exceldest.dll 2017.140.3045.24 260680 19-Oct-18 06:15 x64
Excelsrc.dll 2017.140.3045.24 230680 19-Oct-18 06:13 x86
Excelsrc.dll 2017.140.3045.24 282888 19-Oct-18 06:15 x64
Flatfiledest.dll 2017.140.3045.24 333080 19-Oct-18 06:13 x86
Flatfiledest.dll 2017.140.3045.24 386832 19-Oct-18 06:15 x64
Flatfilesrc.dll 2017.140.3045.24 344344 19-Oct-18 06:13 x86
Flatfilesrc.dll 2017.140.3045.24 399112 19-Oct-18 06:15 x64
Foreachfileenumerator.dll 2017.140.3045.24 80656 19-Oct-18 06:13 x86
Foreachfileenumerator.dll 2017.140.3045.24 96520 19-Oct-18 06:15 x64
Microsoft.sqlserver.astasks.dll 14.0.3045.24 72968 19-Oct-18 06:20 x86
Microsoft.sqlserver.astasksui.dll 14.0.3045.24 186632 19-Oct-18 07:05 x86
Microsoft.sqlserver.chainer.infrastructure.dll 14.0.3045.24 406792 19-Oct-18 06:13 x86
Microsoft.sqlserver.chainer.infrastructure.dll 14.0.3045.24 406808 19-Oct-18 06:15 x86
Microsoft.sqlserver.configuration.sco.dll 14.0.3045.24 2093336 19-Oct-18 06:13 x86
Microsoft.sqlserver.configuration.sco.dll 14.0.3045.24 2093328 19-Oct-18 06:15 x86
Microsoft.sqlserver.manageddts.dll 14.0.3045.24 613960 19-Oct-18 06:13 x86
Microsoft.sqlserver.manageddts.dll 14.0.3045.24 613960 19-Oct-18 06:21 x86
Microsoft.sqlserver.management.integrationservices.dll 14.0.3045.24 252696 19-Oct-18 06:13 x86
Microsoft.sqlserver.xevent.configuration.dll 2017.140.3045.24 152336 19-Oct-18 06:13 x64
Microsoft.sqlserver.xevent.configuration.dll 2017.140.3045.24 141896 19-Oct-18 06:21 x86
Microsoft.sqlserver.xevent.dll 2017.140.3045.24 159496 19-Oct-18 06:06 x64
Microsoft.sqlserver.xevent.dll 2017.140.3045.24 145480 19-Oct-18 06:13 x86
Msdtssrvrutil.dll 2017.140.3045.24 90392 19-Oct-18 06:13 x86
Msdtssrvrutil.dll 2017.140.3045.24 103496 19-Oct-18 06:15 x64
Msmdpp.dll 2017.140.230.1 9194272 26-Sep-18 18:56 x64
Oledbdest.dll 2017.140.3045.24 214808 19-Oct-18 06:13 x86
Oledbdest.dll 2017.140.3045.24 261192 19-Oct-18 06:15 x64
Oledbsrc.dll 2017.140.3045.24 233240 19-Oct-18 06:13 x86
Oledbsrc.dll 2017.140.3045.24 289040 19-Oct-18 06:21 x64
Rawdest.dll 2017.140.3045.24 166680 19-Oct-18 06:13 x86
Rawdest.dll 2017.140.3045.24 206600 19-Oct-18 06:15 x64
Rawsource.dll 2017.140.3045.24 153368 19-Oct-18 06:13 x86
Rawsource.dll 2017.140.3045.24 194120 19-Oct-18 06:15 x64
Recordsetdest.dll 2017.140.3045.24 149272 19-Oct-18 06:13 x86
Recordsetdest.dll 2017.140.3045.24 184392 19-Oct-18 06:15 x64
Sqldest.dll 2017.140.3045.24 213784 19-Oct-18 06:13 x86
Sqldest.dll 2017.140.3045.24 260888 19-Oct-18 06:15 x64
Txagg.dll 2017.140.3045.24 302360 19-Oct-18 06:13 x86
Txbdd.dll 2017.140.3045.24 139552 19-Oct-18 06:13 x86
Txbestmatch.dll 2017.140.3045.24 493336 19-Oct-18 06:13 x86
Txcache.dll 2017.140.3045.24 146192 19-Oct-18 06:13 x86
Txcharmap.dll 2017.140.3045.24 249112 19-Oct-18 06:13 x86
Txcopymap.dll 2017.140.3045.24 145680 19-Oct-18 06:13 x86
Txcharmap.dll 2017.140.3045.24 286984 19-Oct-18 06:15 x64
Txcopymap.dll 2017.140.3045.24 180296 19-Oct-18 06:15 x64
Txdataconvert.dll 2017.140.3045.24 253200 19-Oct-18 06:13 x86
Txderived.dll 2017.140.3045.24 515888 19-Oct-18 06:13 x86
Txfileextractor.dll 2017.140.3045.24 161048 19-Oct-18 06:13 x86
Txfileinserter.dll 2017.140.3045.24 159512 19-Oct-18 06:13 x86
Txgroupdups.dll 2017.140.3045.24 231192 19-Oct-18 06:13 x86
Txlineage.dll 2017.140.3045.24 110384 19-Oct-18 06:13 x86
Txlookup.dll 2017.140.3045.24 446752 19-Oct-18 06:13 x86
Txmerge.dll 2017.140.3045.24 177456 19-Oct-18 06:13 x86
Txmergejoin.dll 2017.140.3045.24 221968 19-Oct-18 06:13 x86
Txmulticast.dll 2017.140.3045.24 102672 19-Oct-18 06:13 x86
Txpivot.dll 2017.140.3045.24 180512 19-Oct-18 06:13 x86
Txrowcount.dll 2017.140.3045.24 101656 19-Oct-18 06:13 x86
Txsampling.dll 2017.140.3045.24 135952 19-Oct-18 06:13 x86
Txscd.dll 2017.140.3045.24 170264 19-Oct-18 06:13 x86
Txsort.dll 2017.140.3045.24 208672 19-Oct-18 06:13 x86
Txtermextraction.dll 2017.140.3045.24 8615192 19-Oct-18 06:21 x86
Txtermlookup.dll 2017.140.3045.24 4107024 19-Oct-18 06:13 x86
Txunionall.dll 2017.140.3045.24 140056 19-Oct-18 06:13 x86
Txunpivot.dll 2017.140.3045.24 160536 19-Oct-18 06:13 x86
Xe.dll 2017.140.3045.24 595736 19-Oct-18 06:06 x86

Important Notices for Deployment

Before deploying this cumulative update, it is crucial to review some important considerations, particularly for specific configurations like Pacemaker and Query Store, and for hybrid environments.

Analysis Services CU Build Version

It’s important to note that starting with Microsoft SQL Server 2017, the Analysis Services build version number no longer consistently matches the SQL Server Database Engine build version number. This change reflects the independent development cycles of these components. To verify your Analysis Services cumulative update build version, specific methods are required.

Pacemaker Notice

IMPORTANT: A significant behavioral change has been introduced in Linux distributions utilizing the latest available Pacemaker package 1.1.18-11.el7. This change impacts the cluster setting start-failure-is-fatal when its value is false, affecting the failover workflow. Previously, if a primary replica failed, the cluster would typically fail over to an available secondary. With this change, the cluster may continuously attempt to restart the failed primary replica. If the primary cannot come online, the cluster will not fail over to another secondary. This issue affects all SQL Server versions, regardless of their cumulative update level.

To mitigate this critical issue, consider the following two methods:

Method 1: Adjust Pacemaker Properties

This method involves reconfiguring certain Pacemaker properties to restore the desired failover behavior.

  1. Remove the start-failure-is-fatal override:
    • For RHEL, Ubuntu: pcs property unset start-failure-is-fatal or pcs property set start-failure-is-fatal=true
    • For SLES: crm configure property start-failure-is-fatal=true
      This step ensures that the cluster’s default fatal failure behavior is either restored or explicitly set to true, preventing continuous restart attempts on a permanently failed primary.
  2. Decrease the cluster-recheck-interval value:
    • For RHEL, Ubuntu: pcs property set cluster-recheck-interval=<Xmin>
    • For SLES: crm configure property cluster-recheck-interval=<Xmin>
      Lowering this interval allows the cluster to re-evaluate the status of resources more frequently, potentially speeding up detection of persistent failures and failover initiation.
  3. Add the failure-timeout meta property to each Availability Group (AG) resource:
    • For RHEL, Ubuntu: pcs resource update ag1 meta failure-timeout=60s
    • For SLES: crm configure edit ag1 (then, in the text editor, add meta failure-timeout=60s after any params and before any ops).
      Setting a failure-timeout on the AG resource specifies how long the resource will be ignored after a failure before being allowed to start again. This works in conjunction with cluster-recheck-interval. For instance, if failure-timeout is 60 seconds and cluster-recheck-interval is 120 seconds, a restart will be attempted between 60 and 120 seconds after a failure. It is recommended to set failure-timeout to 60s and cluster-recheck-interval to a value greater than 60 seconds, but not too small to avoid excessive checks.

Method 2: Revert Pacemaker Version

Alternatively, you can revert your Pacemaker installation to version 1.1.16, which does not exhibit this behavioral change. This might be a simpler solution if reverting is feasible within your environment and does not introduce other compatibility issues.

Query Store Notice

IMPORTANT: If you are currently using Query Store and are upgrading your SQL Server 2017 instance directly from Cumulative Update 2 (CU2) to CU3 or any subsequent cumulative update, you must execute the following SQL script. This script addresses specific issues related to Query Store plans that might arise from this particular update path. If you have already installed CU3 or a later SQL Server 2017 CU, running this script is not necessary.

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

Hybrid Environment Deployment Considerations

Deploying updates in hybrid SQL Server environments (such as Always On Availability Groups, replication, failover clusters, and database mirroring) requires careful planning to minimize downtime and data loss. It is strongly recommended to consult the specific upgrade guidelines for each of these configurations to ensure a smooth update process. For failover clusters, consider a rolling update process to maintain high availability. For Always On with SSISDB, specific instructions are available to correctly apply updates in such complex environments. Replication and mirroring topologies also have unique requirements to ensure transactional consistency during updates.

General Cumulative Update Information

SQL Server Cumulative Updates are designed to deliver proactive maintenance and incorporate all fixes from previous CUs for a given version. They are certified to the same rigorous levels as service packs, ensuring high confidence in their deployment. Microsoft strongly recommends the ongoing, proactive installation of CUs as they become available. Historical data indicates that a significant number of support cases involve issues already resolved in released CUs. Beyond hotfixes, CUs often include valuable updates related to supportability, manageability, and overall reliability. Prior to deploying any CU to production environments, thorough testing in development and staging environments is always advised.

Language Support

SQL Server Cumulative Updates are multilingual, meaning this CU package is not language-specific. It is designed to apply seamlessly across all supported languages, simplifying the update process for diverse global deployments.

Components (Features) Updated

A single CU package encompasses all available updates for every SQL Server 2017 component or feature. However, the cumulative update package only applies updates to those components that are currently installed on the specific SQL Server instance being serviced. If additional SQL Server features (such as Analysis Services, Integration Services, etc.) are installed on the instance after this CU has been applied, it is necessary to reapply the CU to ensure these newly added features are also updated to the latest build. This ensures that your entire SQL Server installation benefits from the update’s improvements and fixes.

Support for This Update

Should you encounter any further issues or require troubleshooting assistance beyond the scope of this article, you may need to create a service request with Microsoft Support. Standard support costs will apply to additional support questions or issues that do not directly qualify under this specific cumulative update package. For a comprehensive list of Microsoft Customer Service and Support telephone numbers or to initiate a new service request, please visit the official Microsoft support website.

How to Uninstall This Update on Windows

If for any reason you need to remove this cumulative update package from a Windows environment, follow these steps:

  1. Open the Control Panel on your Windows system.
  2. Navigate to Programs and Features.
  3. On the left-hand pane, select View installed updates.
  4. Locate the entry corresponding to this cumulative update package under SQL Server 2017.
  5. Right-click (or press and hold) the entry and then select Uninstall.

Third-Party Information Disclaimer

Please be aware that any third-party products mentioned or discussed in this article are manufactured by companies independent of Microsoft. Microsoft disclaims any warranty, whether implied or otherwise, regarding the performance, reliability, or quality of these third-party products. Users should consult the respective third-party vendors for specific support or information related to their products.

We hope this detailed overview of SQL Server 2017 Cumulative Update 12 (KB4464082) proves beneficial for your environment. Share your experiences or questions regarding this update in the comments below. Your insights are valuable to the SQL Server community!

Post a Comment