SQL Server 2016 Cumulative Update 7 (KB4024304) Now Available: Key Improvements & Fixes

Table of Contents

SQL Server 2016 Cumulative Update 7

Release Date: August 8, 2017
Version: 13.0.2210.0

This article details Cumulative Update 7 (CU7) for Microsoft SQL Server 2016. This update package, identified by build number 13.0.2210.0, incorporates numerous fixes and enhancements that have been implemented since the initial release of SQL Server 2016. Cumulative Updates are crucial for maintaining the stability and performance of your SQL Server environment by bundling various bug fixes and improvements into a single, deployable package.

Interestingly, Cumulative Update 7 for SQL Server 2016 was also released concurrently as part of a SQL Server Security Bulletin on August 8, 2017, specifically under Knowledge Base article KB4019086. This security bulletin addressed a specific vulnerability detailed in CVE-2017-8516. Due to this dual release mechanism, it is possible that you may have already installed the components of CU7 if you applied the security bulletin KB4019086.

If you attempt to install the standalone CU7 package after the security bulletin KB4019086 has already been applied, the installation wizard is designed to detect the presence of the updated components. In such cases, you might encounter a message indicating, “There are no SQL Server instances or shared features that can be updated on this computer.” This message serves as confirmation that the Cumulative Update 7 content is already present on your system as a result of the security bulletin installation, and no further installation steps are required.

A potential point of confusion might arise from the package name for CU7. The executable file name, formatted as “SQLServer2016-KB4024304-.exe,” prominently features the Knowledge Base number associated with the security bulletin (KB4019086), rather than the specific KB number assigned to the Cumulative Update 7 itself (KB4024304). Users should disregard this discrepancy in naming. The single package is designed to service both release channels, ensuring that applying either the security bulletin or the cumulative update delivers the same set of fixes and version components for SQL Server 2016.

Key Improvements and Fixes Included in This Update

This Cumulative Update package contains a collection of fixes addressing various components and functionalities within SQL Server 2016. These fixes resolve issues ranging from database engine core problems to specific components like Analysis Services, Reporting Services, Integration Services, and more. Applying this update is essential for resolving known issues and improving the overall reliability of your SQL Server installation. Below is a summary of some of the key issues resolved in CU7:

  • High Availability: Addresses a fix (KB4018227) where a stored procedure might fail after an automatic failover event occurs on a mirrored database. This is critical for environments relying on database mirroring for disaster recovery or high availability. Another significant fix (KB4017080) resolves transaction log backup failures on the secondary replica within SQL Server Always-On Availability Groups, ensuring the continuity of backup strategies in these environments. An additional fix (KB4024449) resolves an issue where databases on a secondary replica show a “NOT SYNCHRONIZING” status unexpectedly after a failover event, impacting the health state visibility and failover readiness.
  • SQL Service: Includes multiple fixes for the core SQL Server service. This encompasses issues such as Change Data Capture (CDC) stopping after applying a recent cumulative update (KB4038210), a fix for SQL Server 2014 or 2016 Backup to URL not being compatible with TLS 1.2 (KB4017023), incorrect syntax errors when adding a subscription via sp_addpullsubscription_agent (KB4023138), access violations when dropping a stored procedure before executing the END TRY section (KB4015561), and an access violation occurring when querying data from a clustered columnstore index (KB4024184). It also addresses issues with disabling “change data capture” if columns are encrypted by “Always Encrypted” (KB4034376). Further fixes relate to replication: system-generated stored procedures created incorrectly in P2P publications if schema names contain periods (KB4021580), and System Center Configuration Manager replication failing with large XML column values using BCP APIs (KB4019125). Several fixes concern TDE-encrypted databases, including Error 9004 during compressed backups from multiple files (KB4025628), failure to compress backup files with INIT and COMPRESSION options (KB4032200), and restore failures when using compression and checksum on TDE databases (KB4019893). An “EXCEPTION_INVALID_CRT_PARAMETER” error during BULK INSERT is also fixed (KB4024989). Lastly, an update adds the “CLR strict security” feature to SQL Server 2016 (KB4018930).
  • SQL Performance: Addresses performance issues, including a fix (KB4011477) where the Dynamic Management Function (DMF) sys.dm_db_incremental_stats_properties doesn’t show all partitions if the partitioning column is a character or binary data type, hindering performance analysis. Another crucial fix (KB4022435) resolves issues where parallel query execution returns incorrect results for merge join operations. A fix (KB4023419) addresses queries with UNION ALL and a row goal potentially running slower in SQL Server 2014 or later compared to SQL Server 2008 R2.
  • Analysis Services: This update includes fixes for SQL Server Analysis Services (SSAS). A fix (KB4013585) resolves an issue where proactive caching processes a partition but doesn’t run an SQL query, leading to stale data in cubes. Another fix (KB4025402) addresses the Security Bulletin MS16-136 breaking the SSRS data source type in PowerPivot within SQL Server 2016. A critical fix (KB4019603) resolves SSAS crashes when executing an MDX query that refers to parent-child dimensions. An issue where dimension security is ignored by Power BI Desktop in SSAS Multidimensional models is also fixed (KB4018908).
  • Reporting Services: Addresses issues in SQL Server Reporting Services (SSRS). This includes intermittent failures with System.NullReferenceException when using custom authentication in SSRS 2014 or 2016 (KB4014862). An “Index was out of range” error when exporting to PDF from an SSRS report is fixed (KB4019983). It also resolves an issue where the “SortExpression” in Reporting Services causes an rsComparisonError when a column set as “DateTimeOffset” contains a NULL value (KB4017827). An item referencing a GDR update package for SQL Server 2016 SP1 (KB3210089) is also noted.
  • Data Quality Services (DQS): Includes a fix (KB4023865) addressing long load times when expanding the Entities folder on the Manage Groups page in SQL Server 2016 Master Data Services (MDS), which relies on DQS components.
  • Integration Services: Addresses issues in SQL Server Integration Services (SSIS). A fix (KB4016804) resolves deadlocks occurring within the SSISDB database when multiple SSIS packages are executed concurrently in SQL Server 2014 or 2016.
  • XML: Includes a fix (KB4019125) related to XML column handling during replication processes using BCP APIs, specifically resolving failures when large values are present in an XML column.

These fixes cover a broad range of areas, highlighting the importance of applying cumulative updates to ensure the stability, security, and performance of your SQL Server 2016 installation. Each fix is designed to address specific scenarios and improve the overall robustness of the platform.

Obtaining the Cumulative Update

The Cumulative Update 7 package for Microsoft SQL Server 2016 is available for download from the Microsoft Download Center. Microsoft recommends obtaining updates directly from official sources to ensure package integrity and authenticity.

Download the latest cumulative update package for Microsoft SQL Server 2016 now (Note: This link points to the download page, which might list the latest available CU, potentially newer than CU7).

If you encounter any difficulties accessing the download page or require assistance obtaining the package, you should contact Microsoft Customer Service and Support for guidance.

Understanding Cumulative Updates

Cumulative Updates (CUs) represent a standard release channel for SQL Server updates. Unlike hotfixes, which often address a single, specific issue, CUs bundle a collection of fixes and sometimes minor feature enhancements that have been developed and tested since the previous release point (either a Service Pack or the last CU).

Only the most recent Cumulative Update package for a specific version and Service Pack level of SQL Server is typically available on the Microsoft Download Center. Each new CU build is cumulative, meaning it incorporates all the fixes that were included in previous CUs for the same baseline version/Service Pack.

Microsoft strongly recommends the ongoing and proactive installation of Cumulative Updates as they become available. This recommendation is based on several factors:

  • Certification Level: SQL Server CUs undergo the same rigorous testing and certification levels as Service Packs. They are built upon stable baselines and should be installed with a comparable level of confidence as Service Packs.
  • Issue Resolution: Historical data from Microsoft Support indicates that a significant proportion of support cases raised by customers involve issues that have already been identified and addressed in a released Cumulative Update. Applying CUs proactively can prevent encountering these known problems.
  • Added Value: Beyond simply fixing bugs, CUs can sometimes introduce improvements related to supportability, manageability, and reliability, enhancing the overall operational experience of SQL Server.
  • Testing: While CUs are certified, it is still a best practice to thoroughly test them in a non-production or staging environment before deploying them to critical production systems. This allows you to verify that the update does not introduce any unforeseen conflicts or performance regressions specific to your environment and workload.
  • Latest Service Pack: It is also recommended to ensure your SQL Server installation is updated to the latest available Service Pack for SQL Server 2016 as a foundation before applying subsequent Cumulative Updates.

Deployment in Hybrid Environments

Deploying updates, including Cumulative Updates, in complex or hybrid SQL Server environments requires careful planning and execution. Environments involving technologies like Always On Availability Groups, Replication, Failover Cluster Instances (FCI), or Database Mirroring have specific procedures to minimize downtime and ensure data consistency during the update process.

Before deploying this or any other hotfix or cumulative update to such environments, it is highly recommended to consult the specific documentation relevant to your topology:

  • Failover Cluster Instances: Consult documentation on upgrading a SQL Server failover cluster instance. The recommended approach typically involves a rolling update process to maintain high availability. If a rolling update is not feasible or desired, the alternative steps involve installing the update first on the passive node(s) and then on the active node (which requires a service restart and a brief outage).
  • Always On Availability Groups: Refer to the documentation on upgrading Availability Group replicas. A rolling upgrade process is generally recommended here as well, starting with readable secondary replicas, then non-readable secondaries, and finally the primary replica (which requires failover). If the SSISDB catalog is part of an Always On setup, additional considerations might apply, and specific guidance should be sought from Microsoft documentation regarding SSIS with Always On deployments.
  • Replication and Database Mirroring: Specific procedures exist for applying hotfixes in topologies involving transactional replication and database mirroring to ensure synchronization is maintained and no data loss or corruption occurs. Similarly, dedicated guidance is available for applying hotfixes in general replication topologies.
  • Mirrored Instances: Consult the documentation specifically on upgrading mirrored instances, which outlines the steps to update SQL Server instances involved in database mirroring sessions.
  • General Servicing: Review the overall documentation on installing SQL Server servicing updates for a comprehensive understanding of the update process.

Understanding and following these specific procedures is vital to successfully applying the update without negatively impacting the availability or integrity of your SQL Server instances in complex configurations.

Language Support

SQL Server Cumulative Updates are designed to be multilingual. This means that a single cumulative update package, such as this one, is not specific to one particular language but is applicable to all supported languages for SQL Server 2016. When you download the package, the download page might list the languages for which the update package is explicitly verified or available. If your specific language is not listed there, it is because a language-specific package is not necessary; the English (ENU) download is intended to apply correctly to all supported language installations of SQL Server 2016.

Components Updated

A single cumulative update package for SQL Server is designed to be comprehensive, containing updates for all components of SQL Server 2016. However, when you run the update package, it intelligently detects which components of SQL Server are installed on the system and applies the updates only to those detected components. This ensures that you only install the necessary updates for your specific SQL Server configuration (e.g., Database Engine, Analysis Services, Reporting Services, Integration Services, etc.).

Support for This Update

While Cumulative Updates are tested and designed to resolve known issues, unexpected problems or scenarios requiring specific troubleshooting might arise after applying the update. If you encounter any issues that are not directly resolved by this cumulative update package, or if you require further assistance, you may need to create a separate service request with Microsoft Customer Service and Support. Standard support costs may apply to such requests, especially if the issues are not directly related to the fixes provided in this specific cumulative update package. You can find a complete list of Microsoft Customer Service and Support telephone numbers or initiate a service request by visiting the official Microsoft support website.

How to Uninstall This Update

If, for any reason, you need to remove this cumulative update package from your system, you can do so using the standard Windows program management tools. Follow these general steps:

  1. Open the Control Panel on your computer.
  2. Depending on your Windows version, select Add or Remove Programs (for older versions) or Programs and Features (for Windows 7 and later).
  3. Browse the list of installed programs and updates to locate the entry corresponding to this specific cumulative update package for SQL Server 2016. The entry will typically include the KB number (KB4024304, or potentially the related KB4019086 depending on how it’s listed).
  4. Select the entry and then choose the Uninstall option. Follow any prompts that appear to complete the uninstallation process.

Uninstalling an update should also be tested in a non-production environment if possible, especially if it’s being done to resolve a problem.

Prerequisites

To successfully apply this cumulative update package, your system must have a supported installation of SQL Server 2016 already running. Ensure your SQL Server 2016 instance meets the minimum requirements for installing updates.

Restart Information

Applying this cumulative update package may require a restart of the SQL Server services or the entire computer to fully implement all the changes. It is advisable to plan for a potential service interruption or system restart when scheduling the installation of this update. The installation process will typically notify you if a restart is necessary.

Registry Information

Generally, applying the hotfixes and improvements included in this cumulative update package does not necessitate any manual changes to the Windows registry. The installation process handles any required registry modifications automatically.

File Information

The files contained within a cumulative update package are specific to the components being updated. This package contains the necessary files to address the issues listed in this article. The English version of this package contains files with attributes (or later) as detailed in the following tables. The dates and times listed are in Coordinated Universal Time (UTC). When viewed on your local system, these times will be converted to your local time zone.

Cumulative Update Package File Information (x86-based versions)

SQL Server 2016 Browser Service

File Name File Version File Size Date Time Platform
Msmdsrv.rll 2015.130.2210.0 1295048 17-Jul-2017 13:24 x86
Msmdsrvi.rll 2015.130.2210.0 1291968 17-Jul-2017 13:24 x86
Sqlbrowser_keyfile.dll 2015.130.2210.0 88768 17-Jul-2017 13:23 x86

SQL Server 2016 Database Services Common Core

File Name File Version File Size Date Time Platform
Microsoft.analysisservices.adomdclient.dll 13.0.2210.0 1023168 17-Jul-2017 13:22 x86
Microsoft.analysisservices.core.dll 13.0.2210.0 1344192 17-Jul-2017 13:22 x86
Microsoft.analysisservices.dll 13.0.2210.0 702656 17-Jul-2017 13:22 x86
Microsoft.analysisservices.tabular.dll 13.0.2210.0 765632 17-Jul-2017 13:22 x86
Microsoft.analysisservices.xmla.dll 13.0.2210.0 707264 17-Jul-2017 13:22 x86
Microsoft.sqlserver.edition.dll 13.0.2210.0 37056 17-Jul-2017 13:23 x86
Microsoft.sqlserver.instapi.dll 13.0.2210.0 46272 17-Jul-2017 13:23 x86
Microsoft.sqlserver.mgdsqldumper.dll 2015.130.2210.0 72904 17-Jul-2017 13:23 x86
Pbsvcacctsync.dll 2015.130.2210.0 60096 17-Jul-2017 13:22 x86
Sql_common_core_keyfile.dll 2015.130.2210.0 88768 17-Jul-2017 13:23 x86
Sqlmgmprovider.dll 2015.130.2210.0 364224 17-Jul-2017 13:22 x86
Sqlsvcsync.dll 2015.130.2210.0 267456 17-Jul-2017 13:22 x86
Sqltdiagn.dll 2015.130.2210.0 60608 17-Jul-2017 13:22 x86
Svrenumapi130.dll 2015.130.2210.0 854208 17-Jul-2017 13:22 x86

SQL Server 2016 Data Quality

File Name File Version File Size Date Time Platform
Microsoft.ssdqs.cleansing.dll 13.0.2210.0 473280 17-Jul-2017 13:22 x86
Microsoft.ssdqs.infra.dll 13.0.2210.0 1876680 17-Jul-2017 13:22 x86

SQL Server 2016 sql_tools_extensions

File Name File Version File Size Date Time Platform
Autoadmin.dll 2015.130.2210.0 1311432 17-Jul-2017 13:23 x86
Dtaengine.exe 2015.130.2210.0 167112 17-Jul-2017 13:23 x86
Dts.dll 2015.130.2210.0 2631872 17-Jul-2017 13:23 x86
Dtspipeline.dll 2015.130.2210.0 1059520 17-Jul-2017 13:23 x86
Dtswizard.exe 13.0.2210.0 895680 17-Jul-2017 13:22 x86
Microsoft.sqlserver.chainer.infrastructure.dll 13.0.2210.0 432832 17-Jul-2017 13:23 x86
Microsoft.sqlserver.configuration.sco.dll 13.0.2210.0 2044096 17-Jul-2017 13:23 x86
Microsoft.sqlserver.configuration.sstring.dll 13.0.2210.0 33480 17-Jul-2017 13:23 x86
Microsoft.sqlserver.deployment.dll 13.0.2210.0 250056 17-Jul-2017 13:23 x86
Microsoft.sqlserver.integrationservices.runtimetelemetry.dll 13.0.2210.0 33984 17-Jul-2017 13:23 x86
Microsoft.sqlserver.manageddts.dll 13.0.2210.0 606400 17-Jul-2017 13:23 x86
Microsoft.sqlserver.packageformatupdate.dll 13.0.2210.0 445120 17-Jul-2017 13:23 x86
Msmdlocal.dll 2015.130.2210.0 37019840 17-Jul-2017 13:22 x86
Msmgdsrv.dll 2015.130.2210.0 6501568 17-Jul-2017 13:22 x86
Msolap130.dll 2015.130.2210.0 6968000 17-Jul-2017 13:22 x86
Sql_tools_extensions_keyfile.dll 2015.130.2210.0 88768 17-Jul-2017 13:23 x86
Xmsrv.dll 2015.130.2210.0 32696000 17-Jul-2017 13:22 x86

Cumulative Update Package File Information (x64-based versions)

SQL Server 2016 Browser Service

File Name File Version File Size Date Time Platform
Keyfile.dll 2015.130.2210.0 88768 17-Jul-2017 13:23 x86
Msmdsrv.rll 2015.130.2210.0 1295048 17-Jul-2017 13:24 x86
Msmdsrvi.rll 2015.130.2210.0 1291968 17-Jul-2017 13:24 x86

SQL Server 2016 Business Intelligence Development Studio

File Name File Version File Size Date Time Platform
Sqlsqm_keyfile.dll 2015.130.2210.0 100552 17-Jul-2017 13:22 x64

SQL Server 2016 Writer

File Name File Version File Size Date Time Platform
Sqlboot.dll 2015.130.2210.0 186568 17-Jul-2017 13:22 x64
Sqlvdi.dll 2015.130.2210.0 168640 17-Jul-2017 13:22 x86
Sqlvdi.dll 2015.130.2210.0 197312 17-Jul-2017 13:23 x64
Sqlwriter_keyfile.dll 2015.130.2210.0 100552 17-Jul-2017 13:22 x64

SQL Server 2016 Analysis Services

File Name File Version File Size Date Time Platform
Microsoft.analysisservices.server.core.dll 13.0.2210.0 1343680 17-Jul-2017 13:23 x86
Microsoft.analysisservices.server.tabular.dll 13.0.2210.0 765632 17-Jul-2017 13:23 x86
Microsoft.data.edm.netfx35.dll 5.7.0.62516 667872 04-Jun-2016 17:07 x86
Microsoft.data.edm.netfx35.dll 5.7.0.62516 667872 20-Jun-2016 13:28 x86
Microsoft.data.mashup.dll 2.35.4399.541 186592 04-Jun-2016 17:07 x86
Microsoft.data.mashup.dll 2.35.4399.541 186592 20-Jun-2016 13:28 x86
Microsoft.data.odata.netfx35.dll 5.7.0.62516 1461464 04-Jun-2016 17:07 x86
Microsoft.data.odata.netfx35.dll 5.7.0.62516 1461464 20-Jun-2016 13:28 x86
Microsoft.data.odata.query.netfx35.dll 5.7.0.62516 188128 04-Jun-2016 17:07 x86
Microsoft.data.odata.query.netfx35.dll 5.7.0.62516 188128 20-Jun-2016 13:28 x86
Microsoft.mashup.container.exe 2.35.4399.541 27872 04-Jun-2016 17:07 x64
Microsoft.mashup.container.exe 2.35.4399.541 27872 20-Jun-2016 13:28 x64
Microsoft.mashup.container.netfx40.exe 2.35.4399.541 28384 04-Jun-2016 17:07 x64
Microsoft.mashup.container.netfx40.exe 2.35.4399.541 28384 20-Jun-2016 13:28 x64
Microsoft.mashup.container.netfx45.exe 2.35.4399.541 28384 04-Jun-2016 17:07 x64
Microsoft.mashup.container.netfx45.exe 2.35.4399.541 28384 20-Jun-2016 13:28 x64
Microsoft.mashup.eventsource.dll 2.35.4399.541 159456 04-Jun-2016 17:07 x86
Microsoft.mashup.eventsource.dll 2.35.4399.541 159456 20-Jun-2016 13:28 x86
Microsoft.mashup.oauth.dll 2.35.4399.541 63200 04-Jun-2016 17:07 x86
Microsoft.mashup.oauth.dll 2.35.4399.541 63200 20-Jun-2016 13:28 x86
Microsoft.mashup.storage.xmlserializers.dll 1.0.0.0 143072 04-Jun-2016 17:07 x86
Microsoft.mashup.storage.xmlserializers.dll 1.0.0.0 143072 20-Jun-2016 13:28 x86
Microsoft.mashupengine.dll 2.35.4399.541 5652704 04-Jun-2016 17:07 x86
Microsoft.mashupengine.dll 2.35.4399.541 5652704 20-Jun-2016 13:28 x86
Microsoft.odata.core.netfx35.dll 6.15.0.0 1444576 04-Jun-2016 17:07 x86
Microsoft.odata.core.netfx35.dll 6.15.0.0 1444576 20-Jun-2016 13:28 x86
Microsoft.odata.edm.netfx35.dll 6.15.0.0 785632 04-Jun-2016 17:07 x86
Microsoft.odata.edm.netfx35.dll 6.15.0.0 785632 20-Jun-2016 13:28 x86
Microsoft.spatial.netfx35.dll 6.15.0.0 133344 04-Jun-2016 17:07 x86
Microsoft.spatial.netfx35.dll 6.15.0.0 133344 20-Jun-2016 13:28 x86
Msmdlocal.dll 2015.130.2210.0 37019840 17-Jul-2017 13:22 x86
Msmdlocal.dll 2015.130.2210.0 56109768 17-Jul-2017 13:22 x64
Msmdsrv.exe 2015.130.2210.0 56655552 17-Jul-2017 13:23 x64
Msmgdsrv.dll 2015.130.2210.0 6501568 17-Jul-2017 13:22 x86
Msmgdsrv.dll 2015.130.2210.0 7499968 17-Jul-2017 13:22 x64
Msolap130.dll 2015.130.2210.0 6968000 17-Jul-2017 13:22 x86
Msolap130.dll 2015.130.2210.0 8590024 17-Jul-2017 13:22 x64
Sql_as_keyfile.dll 2015.130.2210.0 100552 17-Jul-2017 13:22 x64
Sqlboot.dll 2015.130.2210.0 186568 17-Jul-2017 13:22 x64
Sqlceip.exe 13.0.2210.0 249032 17-Jul-2017 13:23 x86
System.spatial.netfx35.dll 5.7.0.62516 124640 04-Jun-2016 17:07 x86
System.spatial.netfx35.dll 5.7.0.62516 124640 20-Jun-2016 13:28 x86
Tmapi.dll 2015.130.2210.0 4344512 17-Jul-2017 13:20 x64
Tmcachemgr.dll 2015.130.2210.0 2825408 17-Jul-2017 13:20 x64
Tmpersistence.dll 2015.130.2210.0 1069768 17-Jul-2017 13:20 x64
Tmtransactions.dll 2015.130.2210.0 1349824 17-Jul-2017 13:20 x64
Xmsrv.dll 2015.130.2210.0 24015552 17-Jul-2017 13:20 x64
Xmsrv.dll 2015.130.2210.0 32696000 17-Jul-2017 13:22 x86

SQL Server 2016 Database Services Common Core

File Name File Version File Size Date Time Platform
Microsoft.analysisservices.adomdclient.dll 13.0.2210.0 1023168 17-Jul-2017 13:22 x86
Microsoft.analysisservices.adomdclient.dll 13.0.2210.0 1023168 17-Jul-2017 13:23 x86
Microsoft.analysisservices.core.dll 13.0.2210.0 1344192 17-Jul-2017 13:22 x86
Microsoft.analysisservices.dll 13.0.2210.0 702656 17-Jul-2017 13:22 x86
Microsoft.analysisservices.tabular.dll 13.0.2210.0 765632 17-Jul-2017 13:22 x86
Microsoft.analysisservices.xmla.dll 13.0.2210.0 707264 17-Jul-2017 13:22 x86
Microsoft.analysisservices.xmla.dll 13.0.2210.0 707264 17-Jul-2017 13:23 x86
Microsoft.sqlserver.edition.dll 13.0.2210.0 37056 17-Jul-2017 13:23 x86
Microsoft.sqlserver.instapi.dll 13.0.2210.0 46272 17-Jul-2017 13:23 x86
Microsoft.sqlserver.mgdsqldumper.dll 2015.130.2210.0 75456 17-Jul-2017 13:22 x64
Microsoft.sqlserver.mgdsqldumper.dll 2015.130.2210.0 72904 17-Jul-2017 13:23 x86
Pbsvcacctsync.dll 2015.130.2210.0 60096 17-Jul-2017 13:22 x86
Pbsvcacctsync.dll 2015.130.2210.0 72896 17-Jul-2017 13:22 x64
Sql_common_core_keyfile.dll 2015.130.2210.0 100552 17-Jul-2017 13:22 x64
Sqlmgmprovider.dll 2015.130.2210.0 404160 17-Jul-2017 13:20 x64
Sqlmgmprovider.dll 2015.130.2210.0 364224 17-Jul-2017 13:22 x86
Sqlsvcsync.dll 2015.130.2210.0 348864 17-Jul-2017 13:20 x64
Sqlsvcsync.dll 2015.130.2210.0 267456 17-Jul-2017 13:22 x86
Sqltdiagn.dll 2015.130.2210.0 67776 17-Jul-2017 13:20 x64
Sqltdiagn.dll 2015.130.2210.0 60608 17-Jul-2017 13:22 x86
Svrenumapi130.dll 2015.130.2210.0 1115840 17-Jul-2017 13:20 x64
Svrenumapi130.dll 2015.130.2210.0 854208 17-Jul-2017 13:22 x86

SQL Server 2016 Data Quality

File Name File Version File Size Date Time Platform
Microsoft.ssdqs.cleansing.dll 13.0.2210.0 473280 17-Jul-2017 13:22 x86
Microsoft.ssdqs.cleansing.dll 13.0.2210.0 473280 17-Jul-2017 13:22 x86
Microsoft.ssdqs.infra.dll 13.0.2210.0 1876680 17-Jul-2017 13:22 x86
Microsoft.ssdqs.infra.dll 13.0.2210.0 1876672 17-Jul-2017 13:22 x86

SQL Server 2016 Database Services Core Instance

File Name File Version File Size Date Time Platform
Backuptourl.exe 13.0.2210.0 41152 17-Jul-2017 13:23 x64
Databasemail.exe 13.0.16100.4 29888 09-Dec-2016 01:46 x64
Hadrres.dll 2015.130.2210.0 177856 17-Jul-2017 13:23 x64
Hkcompile.dll 2015.130.2210.0 1297088 17-Jul-2017 13:23 x64
Hkengine.dll 2015.130.2210.0 5600448 17-Jul-2017 13:23 x64
Hkruntime.dll 2015.130.2210.0 158912 17-Jul-2017 13:23 x64
Microsoft.sqlautoadmin.autobackupagent.dll 13.0.2210.0 231624 17-Jul-2017 13:23 x86
Microsoft.sqlserver.types.dll 2015.130.2210.0 391872 17-Jul-2017 13:22 x86
Microsoft.sqlserver.vdiinterface.dll 2015.130.2210.0 71360 17-Jul-2017 13:22 x64
Qds.dll 2015.130.2210.0 844480 17-Jul-2017 13:22 x64
Rsfxft.dll 2015.130.2210.0 34496 17-Jul-2017 13:23 x64
Sql_engine_core_inst_keyfile.dll 2015.130.2210.0 100552 17-Jul-2017 13:22 x64
Sqlaccess.dll 2015.130.2210.0 462528 17-Jul-2017 13:22 x64
Sqlagent.exe 2015.130.2210.0 565952 17-Jul-2017 13:23 x64
Sqlboot.dll 2015.130.2210.0 186568 17-Jul-2017 13:22 x64
Sqlceip.exe 13.0.2210.0 249032 17-Jul-2017 13:23 x86
Sqldk.dll 2015.130.2210.0 2585792 17-Jul-2017 13:22 x64
Sqllang.dll 2015.130.2210.0 39335616 17-Jul-2017 13:22 x64
Sqlmin.dll 2015.130.2210.0 37353152 17-Jul-2017 13:20 x64
Sqlos.dll 2015.130.2210.0 26304 17-Jul-2017 13:23 x64
Sqlscriptdowngrade.dll 2015.130.2210.0 27840 17-Jul-2017 13:20 x64
Sqlscriptupgrade.dll 2015.130.2210.0 5797568 17-Jul-2017 13:23 x64
Sqlserverspatial130.dll 2015.130.2210.0 732864 17-Jul-2017 13:23 x64
Sqlservr.exe 2015.130.2210.0 392896 17-Jul-2017 13:23 x64
Sqltses.dll 2015.130.2210.0 8896704 17-Jul-2017 13:20 x64
Stretchcodegen.exe 13.0.2210.0 55488 17-Jul-2017 13:23 x86
Xpstar.dll 2015.130.2210.0 422080 17-Jul-2017 13:23 x64

SQL Server 2016 Database Services Core Shared

File Name File Version File Size Date Time Platform
Dts.dll 2015.130.2210.0 3145408 17-Jul-2017 13:22 x64
Dtspipeline.dll 2015.130.2210.0 1278144 17-Jul-2017 13:22 x64
Dtswizard.exe 13.0.2210.0 895176 17-Jul-2017 13:23 x64
Logread.exe 2015.130.2210.0 616640 17-Jul-2017 13:23 x64
Microsoft.sqlserver.integrationservices.runtimetelemetry.dll 13.0.2210.0 33984 17-Jul-2017 13:22 x86
Microsoft.sqlserver.manageddts.dll 13.0.2210.0 606400 17-Jul-2017 13:22 x86
Microsoft.sqlserver.management.pssnapins.dll 13.0.2210.0 215232 17-Jul-2017 13:23 x86
Microsoft.sqlserver.management.sdk.scripting.dll 13.0.16107.4 30912 20-Mar-2017 23:54 x86
Microsoft.sqlserver.packageformatupdate.dll 13.0.2210.0 445120 17-Jul-2017 13:22 x86
Microsoft.sqlserver.replication.dll 2015.130.2210.0 1638088 17-Jul-2017 13:22 x64
Repldp.dll 2015.130.2210.0 276160 17-Jul-2017 13:22 x64
Spresolv.dll 2015.130.2210.0 244928 17-Jul-2017 13:22 x64
Sql_engine_core_shared_keyfile.dll 2015.130.2210.0 100552 17-Jul-2017 13:22 x64
Sqlmergx.dll 2015.130.2210.0 346816 17-Jul-2017 13:20 x64
Sqlwep130.dll 2015.130.2210.0 105664 17-Jul-2017 13:20 x64
Ssradd.dll 2015.130.2210.0 65216 17-Jul-2017 13:20 x64
Ssravg.dll 2015.130.2210.0 65216 17-Jul-2017 13:20 x64
Ssrdown.dll 2015.130.2210.0 50880 17-Jul-2017 13:20 x64
Ssrmax.dll 2015.130.2210.0 63168 17-Jul-2017 13:20 x64
Ssrmin.dll 2015.130.2210.0 63680 17-Jul-2017 13:20 x64
Ssrpub.dll 2015.130.2210.0 51392 17-Jul-2017 13:20 x64
Ssrup.dll 2015.130.2210.0 50880 17-Jul-2017 13:20 x64
Txdatacollector.dll 2015.130.2210.0 367304 17-Jul-2017 13:20 x64

SQL Server 2016 sql_extensibility

File Name File Version File Size Date Time Platform
Launchpad.exe 2015.130.2210.0 1011904 17-Jul-2017 13:22 x64
Sql_extensibility_keyfile.dll 2015.130.2210.0 100552 17-Jul-2017 13:22 x64
Sqlsatellite.dll 2015.130.2210.0 836808 17-Jul-2017 13:23 x64

SQL Server 2016 Full-Text Engine

File Name File Version File Size Date Time Platform
Fd.dll 2015.130.2210.0 660160 17-Jul-2017 13:23 x64
Mswb7.dll 14.0.4763.1000 331672 20-Jun-2016 13:29 x64
Prm0007.bin 14.0.4763.1000 11602944 20-Jun-2016 13:29 x64
Prm0009.bin 14.0.4763.1000 5739008 20-Jun-2016 13:29 x64
Prm0013.bin 14.0.4763.1000 9482240 20-Jun-2016 13:29 x64
Sql_fulltext_keyfile.dll 2015.130.2210.0 100552 17-Jul-2017 13:22 x64

SQL Server 2016 sql_inst_mr

File Name File Version File Size Date Time Platform
Imrdll.dll 13.0.2210.0 23744 17-Jul-2017 13:23 x86
Sql_inst_mr_keyfile.dll 2015.130.2210.0 100552 17-Jul-2017 13:22 x64

SQL Server 2016 Integration Services

File Name File Version File Size Date Time Platform
Dts.dll 2015.130.2210.0 3145408 17-Jul-2017 13:22 x64
Dts.dll 2015.130.2210.0 2631872 17-Jul-2017 13:23 x86
Dtspipeline.dll 2015.130.2210.0 1278144 17-Jul-2017 13:22 x64
Dtspipeline.dll 2015.130.2210.0 1059520 17-Jul-2017 13:23 x86
Dtswizard.exe 13.0.2210.0 895680 17-Jul-2017 13:22 x86
Dtswizard.exe 13.0.2210.0 895176 17-Jul-2017 13:23 x64
Microsoft.sqlserver.integrationservices.isserverdbupgrade.dll 13.0.2210.0 469696 17-Jul-2017 13:22 x86
Microsoft.sqlserver.integrationservices.isserverdbupgrade.dll 13.0.2210.0 469696 17-Jul-2017 13:23 x86
Microsoft.sqlserver.integrationservices.runtimetelemetry.dll 13.0.2210.0 33984 17-Jul-2017 13:22 x86
Microsoft.sqlserver.integrationservices.runtimetelemetry.dll 13.0.2210.0 33984 17-Jul-2017 13:23 x86
Microsoft.sqlserver.manageddts.dll 13.0.2210.0 606400 17-Jul-2017 13:22 x86
Microsoft.sqlserver.manageddts.dll 13.0.2210.0 606400 17-Jul-2017 13:23 x86
Microsoft.sqlserver.packageformatupdate.dll 13.0.2210.0 445120 17-Jul-2017 13:22 x86
Microsoft.sqlserver.packageformatupdate.dll 13.0.2210.0 445120 17-Jul-2017 13:23 x86
Msdtssrvr.exe 13.0.2210.0 216768 17-Jul-2017 13:23 x64
Sql_is_keyfile.dll 2015.130.2210.0 100552 17-Jul-2017 13:22 x64
Sqlceip.exe 13.0.2210.0 249032 17-Jul-2017 13:23 x86

SQL Server 2016 sql_polybase_core_inst

File Name File Version File Size Date Time Platform
Microsoft.sqlserver.datawarehouse.sql.dll 10.0.8224.29 2155712 14-Apr-2017 05:35 x86

SQL Server 2016 Reporting Services

File Name File Version File Size Date Time Platform
Microsoft.reportingservices.authorization.dll 13.0.2210.0 79040 17-Jul-2017 13:23 x86
Microsoft.reportingservices.dataextensions.xmlaclient.dll 13.0.2210.0 567488 17-Jul-2017 13:23 x86
Microsoft.reportingservices.datarendering.dll 13.0.2210.0 166088 17-Jul-2017 13:23 x86
Microsoft.reportingservices.diagnostics.dll 13.0.2210.0 1619648 17-Jul-2017 13:23 x86
Microsoft.reportingservices.excelrendering.dll 13.0.2210.0 657600 17-Jul-2017 13:23 x86
Microsoft.reportingservices.hpbprocessing.dll 13.0.2210.0 329920 17-Jul-2017 13:23 x86
Microsoft.reportingservices.htmlrendering.dll 13.0.2210.0 1069760 17-Jul-2017 13:23 x86
Microsoft.reportingservices.imagerendering.dll 13.0.2210.0 161984 17-Jul-2017 13:23 x86
Microsoft.reportingservices.interfaces.dll 13.0.2210.0 76480 17-Jul-2017 13:23 x86
Microsoft.reportingservices.interfaces.dll 13.0.2210.0 76480 17-Jul-2017 13:23 x86
Microsoft.reportingservices.portal.interfaces.dll 13.0.2210.0 124096 17-Jul-2017 13:23 x86
Microsoft.reportingservices.portal.odatawebapi.dll 13.0.2210.0 104128 17-Jul-2017 13:23 x86
Microsoft.reportingservices.portal.services.dll 13.0.2210.0 4910272 17-Jul-2017 13:23 x86
Microsoft.reportingservices.portal.web.dll 13.0.2210.0 9645768 17-Jul-2017 13:23 x86
Microsoft.reportingservices.portal.webhost.exe 13.0.2210.0 92864 17-Jul-2017 13:23 x64
Microsoft.reportingservices.processingcore.dll 13.0.2210.0 5951168 17-Jul-2017 13:23 x86
Microsoft.reportingservices.sharepoint.server.dll 13.0.2210.0 245952 17-Jul-2017 13:23 x86
Microsoft.reportingservices.spbprocessing.dll 13.0.2210.0 298176 17-Jul-2017 13:23 x86
Microsoft.reportingservices.storage.dll 13.0.2210.0 207552 17-Jul-2017 13:23 x86
Microsoft.reportingservices.upgradescripts.dll 13.0.2210.0 500928 17-Jul-2017 13:23 x86
Microsoft.sqlserver.types.dll 2015.130.2210.0 391872 17-Jul-2017 13:22 x86
Microsoft.sqlserver.types.dll 2015.130.2210.0 396992 17-Jul-2017 13:23 x86
Msmdlocal.dll 2015.130.2210.0 37019840 17-Jul-2017 13:22 x86
Msmdlocal.dll 2015.130.2210.0 56109768 17-Jul-2017 13:22 x64
Msmgdsrv.dll 2015.130.2210.0 6501568 17-Jul-2017 13:22 x86
Msmgdsrv.dll 2015.130.2210.0 7499968 17-Jul-2017 13:22 x64
Msolap130.dll 2015.130.2210.0 6968000 17-Jul-2017 13:22 x86
Msolap130.dll 2015.130.2210.0 8590024 17-Jul-2017 13:22 x64
Reportingserviceslibrary.dll 13.0.2210.0 2516160 17-Jul-2017 13:22 x86
Reportingservicesnativeclient.dll 2015.130.2210.0 114368 17-Jul-2017 13:22 x86
Reportingservicesnativeclient.dll 2015.130.2210.0 108736 17-Jul-2017 13:22 x64
Reportingservicesnativeserver.dll 2015.130.2210.0 99008 17-Jul-2017 13:22 x64
Reportingserviceswebserver.dll 13.0.2210.0 2698432 17-Jul-2017 13:22 x86
Sql_rs_keyfile.dll 2015.130.2210.0 100552 17-Jul-2017 13:22 x64
Sqlserverspatial130.dll 2015.130.2210.0 584392 17-Jul-2017 13:22 x86
Sqlserverspatial130.dll 2015.130.2210.0 732864 17-Jul-2017 13:23 x64
Xmsrv.dll 2015.130.2210.0 24015552 17-Jul-2017 13:20 x64
Xmsrv.dll 2015.130.2210.0 32696000 17-Jul-2017 13:22 x86

SQL Server 2016 sql_shared_mr

File Name File Version File Size Date Time Platform
Smrdll.dll 13.0.2210.0 23744 17-Jul-2017 13:22 x86
Sql_engine_core_shared_keyfile.dll 2015.130.2210.0 100552 17-Jul-2017 13:22 x64

SQL Server 2016 sql_tools_extensions

File Name File Version File Size Date Time Platform
Autoadmin.dll 2015.130.2210.0 1311432 17-Jul-2017 13:23 x86
Dtaengine.exe 2015.130.2210.0 167112 17-Jul-2017 13:23 x86
Dts.dll 2015.130.2210.0 3145408 17-Jul-2017 13:22 x64
Dts.dll 2015.130.2210.0 2631872 17-Jul-2017 13:23 x86
Dtspipeline.dll 2015.130.2210.0 1278144 17-Jul-2017 13:22 x64
Dtspipeline.dll 2015.130.2210.0 1059520 17-Jul-2017 13:23 x86
Dtswizard.exe 13.0.2210.0 895680 17-Jul-2017 13:22 x86
Dtswizard.exe 13.0.2210.0 895176 17-Jul-2017 13:23 x64
Microsoft.sqlserver.chainer.infrastructure.dll 13.0.2210.0 432832 17-Jul-2017 13:23 x86
Microsoft.sqlserver.chainer.infrastructure.dll 13.0.2210.0 432832 17-Jul-2017 13:23 x86
Microsoft.sqlserver.configuration.sco.dll 13.0.2210.0 2044096 17-Jul-2017 13:23 x86
Microsoft.sqlserver.configuration.sco.dll 13.0.2210.0 2044096 17-Jul-2017 13:23 x86
Microsoft.sqlserver.configuration.sstring.dll 13.0.2210.0 33480 17-Jul-2017 13:23 x86
Microsoft.sqlserver.configuration.sstring.dll 13.0.2210.0 33472 17-Jul-2017 13:23 x86
Microsoft.sqlserver.deployment.dll 13.0.2210.0 250056 17-Jul-2017 13:23 x86
Microsoft.sqlserver.deployment.dll 13.0.2210.0 250048 17-Jul-2017 13:23 x86
Microsoft.sqlserver.integrationservices.runtimetelemetry.dll 13.0.2210.0 33984 17-Jul-2017 13:22 x86
Microsoft.sqlserver.integrationservices.runtimetelemetry.dll 13.0.2210.0 33984 17-Jul-2017 13:23 x86
Microsoft.sqlserver.manageddts.dll 13.0.2210.0 606400 17-Jul-2017 13:22 x86
Microsoft.sqlserver.manageddts.dll 13.0.2210.0 606400 17-Jul-2017 13:23 x86
Microsoft.sqlserver.packageformatupdate.dll 13.0.2210.0 445120 17-Jul-2017 13:22 x86
Microsoft.sqlserver.packageformatupdate.dll 13.0.2210.0 445120 17-Jul-2017 13:23 x86
Msmdlocal.dll 2015.130.2210.0 37019840 17-Jul-2017 13:22 x86
Msmdlocal.dll 2015.130.2210.0 56109768 17-Jul-2017 13:22 x64
Msmgdsrv.dll 2015.130.2210.0 6501568 17-Jul-2017 13:22 x86
Msmgdsrv.dll 2015.130.2210.0 7499968 17-Jul-2017 13:22 x64
Msolap130.dll 2015.130.2210.0 6968000 17-Jul-2017 13:22 x86
Msolap130.dll 2015.130.2210.0 8590024 17-Jul-2017 13:22 x64
Sql_tools_extensions_keyfile.dll 2015.130.2210.0 100552 17-Jul-2017 13:22 x64
Xmsrv.dll 2015.130.2210.0 24015552 17-Jul-2017 13:20 x64
Xmsrv.dll 2015.130.2210.0 32696000 17-Jul-2017 13:22 x86

Applying this Cumulative Update is a recommended step for SQL Server 2016 users to benefit from the latest fixes and improvements. Always ensure you have a proper backup strategy and test updates in a controlled environment before applying them to production systems.

What has been your experience with applying Cumulative Updates for SQL Server 2016? Share your thoughts and tips in the comments below!

Post a Comment