Home kb4013106 patches sql server updates

SQL Server 2016 SP1: Cumulative Update 2 (KB4013106) Now Available

Updated: • 0 • min read
Table of Contents

SQL Server 2016 SP1 Cumulative Update 2 Now Available

Release Information

Release Date and Version

This cumulative update was released on March 20, 2017, and the version is 13.0.4422.0. This update is specifically for Microsoft SQL Server 2016 Service Pack 1 (SP1). It is important to note these details for accurate identification and application of the update.

About Cumulative Update 2

Cumulative Update package 2 (CU2) for SQL Server 2016 SP1 is now available. This package, identified by build number 13.0.4422.0, includes a collection of fixes that were implemented after the initial release of SQL Server 2016 SP1. These fixes address a range of issues reported by users and discovered internally by Microsoft. Applying this CU is recommended to enhance the stability and performance of your SQL Server 2016 SP1 instance.

Important Considerations

Potential Issues with Change Data Capture (CDC)

After installing this Cumulative Update, there’s a potential issue that may affect Change Data Capture (CDC) functionality. This issue can arise under specific circumstances, particularly when:

  • Databases enabled for CDC are part of an Always On availability group.
  • SQL Server replication components are not installed on the server.

If your SQL Server environment falls into either of these categories and utilizes CDC, it is crucial to review the following resources for detailed information and potential workarounds:

Understanding these potential implications for CDC is vital before proceeding with the installation of CU2, especially in production environments.

Improvements and Fixes Included in This Update

This Cumulative Update 2 for SQL Server 2016 SP1 addresses a wide spectrum of bugs and introduces performance improvements across various SQL Server components. The fixes are categorized by feature area for clarity. Below is a detailed breakdown of the issues resolved in this CU.

Analysis Services Fixes

This cumulative update includes numerous fixes for SQL Server Analysis Services (SSAS), enhancing its stability, performance, and query accuracy. These fixes target various aspects of SSAS, including MDX query processing, tabular model operations, and connection management.

Bug Reference Description Fix Area
9456824 Improvement: Performance improvement for the “sequence point algorithm” step in an SSAS 2016 Tabular Model transaction (KB4013122) Analysis Services
9237364 FIX: MDX query returns errors if the value of MaxRolapOrConditions is greater than 256 in SQL Server Analysis Services (KB3208179) Analysis Services
9287975 FIX: Unexpected error occurs when you process a table in a tabular model in SSAS 2016 (KB4014013) Analysis Services
9367862 FIX: Access violation occurs when you run and then cancel a query on distinct count partitions in SSAS (KB3025408) Analysis Services
9367868 FIX: SSAS may crash on query execution if a predefined role is specified in the connection string (KB3212916) Analysis Services
9367872 FIX: Error when you execute an MDX query on a Tabular model database in SQL Server 2016 Analysis Services (KB3198356) Analysis Services
9367901 FIX: Can’t cancel queries with SORT conditions on cells or measure values in SQL Server Analysis Services (KB3198826) Analysis Services
9367911 FIX: Error occurs for queries on global measures that have previously been referenced by query scoped measures in SSAS 2016 tabular mode (KB3211605) Analysis Services
9367925 FIX: SSAS stored connection strings become corrupted if extended properties are used incorrectly (KB3209520) Analysis Services
9467732 FIX: SQL Server 2016 Analysis Services crashes or hangs during processing of data in a Tabular instance (KB4013206) Analysis Services
9503252 FIX: An MDX query returns incorrect results in SSAS 2014 or 2016 Tabular mode (KB4009839) Analysis Services

High Availability Fixes

Several fixes in this CU address critical issues related to High Availability features like Always On Availability Groups and database mirroring. These improvements aim to enhance the reliability and stability of these features, ensuring smoother failovers and data synchronization.

Bug Reference Description Fix Area
9237384 FIX: Deadlock causes deferred transaction on the secondary replica in an Always On environment (KB3189959) High Availability
9237401 FIX: Availability databases in incorrect initializing/synchronizing state after failover of SQL Server 2014 or 2016 Always On availability group (KB3206299) High Availability
9237403 FIX: On failover, the new secondary replica stops accepting transaction log records until the instance is restarted in SQL Server (KB3207327) High Availability
9237409 FIX: You can’t select any replica when you fail over from an availability group that’s in the resolving state (KB3208524) High Availability
9367814 FIX: Assert memory dump on a mirror server in SQL Server (KB3192692) High Availability
9367892 FIX: Queries that run against secondary databases always get recompiled in SQL Server (KB3181444) High Availability
9367917 FIX: No automatic failover after database mirroring stops unexpectedly in SQL Server (KB3177238) High Availability
9367937 FIX: DMV sys.dm_hadr_availability_replica_states returns an incorrect synchronization health state for a distributed availability group (KB3213288) High Availability
9368264 FIX: Error 5262 when you execute DBCC CHECKDB on the primary replica in SQL Server 2012, 2014 or 2016 (KB3211304) High Availability
9379260 FIX: Bad query plan created on secondary replicas after FULLSCAN statistics update on primary replica in SQL Server 2016 (KB4016657) High Availability

In-Memory OLTP Fixes

This CU includes fixes for In-Memory OLTP (Online Transaction Processing), focusing on issues related to data integrity and performance. These enhancements are important for environments leveraging memory-optimized tables.

Bug Reference Description Fix Area
8861790 FIX: Checkpoint files grow excessively when you insert data into memory-optimized tables in SQL Server 2016 (KB3206584) In-Memory OLTP
9379508 FIX: ALTER TABLE, ADD CONSTRAINT, and PRIMARY KEY statements don’t detect a duplicate key in SQL Server 2016 (KB4013116) In-Memory OLTP
9460219 FIX: An access violation occurs when natively compiled stored procedures are executed concurrently in SQL Server 2016 (KB4013124) In-Memory OLTP

Integration Services Fixes

Fixes for Integration Services (SSIS) in this CU address issues related to package execution and task failures, specifically focusing on XML tasks and Hadoop File System tasks.

Bug Reference Description Fix Area
9367891 FIX: “The process cannot access the file” error when an XML task fails in SQL Server (KB3115741) Integration Services
9514259 FIX: Hadoop File System Task fails after 10 minutes when you open and run a saved SSIS 2016 package (KB4013936) Integration Services

Management Tools Fixes

This cumulative update provides fixes for SQL Server Management Tools, addressing issues in areas such as Master Data Services (MDS), Database Mail, and general management utilities. These fixes improve the usability and reliability of these tools.

Bug Reference Description Fix Area
9237354 FIX: “No Data Available” in the SQL Server Memory Usage page in the SQL Server 2014 or 2016 MDM report (KB3209442) Management Tools
9367429 FIX: Snapshot Agent fails when you publish UDF’s to SQL Server 2016 Distributor in Transactional Replication (KB3197883) Management Tools
9367867 FIX: SQL Server 2016 Database Mail causes high CPU usage after many email messages are sent (KB3197879) Management Tools
9395865 FIX: SQL Server 2016 Database Mail doesn’t work on a computer that doesn’t have the .NET Framework 3.5 installed (KB3186435) Management Tools
9503259 FIX: The sp_msx_enlist stored procedure fails to enlist a target server into a master server in SQL Server 2014 or 2016 if the server name is too long (KB4010344) Management Tools
9503261 FIX: “Invoke-sqlcmd” cmdlet executes a query statement multiple times if an error occurs in SQL Server 2014 or 2016 (KB4010159) Management Tools
9439184 SQL Server 2016 Service Pack 1 release information (KB3182545) Master Data Services (MDS)

Reporting Services Fixes

This CU addresses multiple issues within SQL Server Reporting Services (SSRS), focusing on report rendering, parameter handling, and integration with SharePoint. These fixes are crucial for ensuring accurate and reliable report generation and delivery.

Bug Reference Description Fix Area
9269601 GDR update package for SQL Server 2016 SP1 (KB3210089) Reporting Services
9367822 MS15-058: Description of the security update for SQL Server 2012 Service Pack 2 GDR: July 14, 2015 (KB3045321) Reporting Services
9367818 FIX: Can’t save the SSRS report after you change a parameter in Report Builder or the SQL Server Data Tool (KB3212193) Reporting Services
9367882 FIX: Image maps not rendered as expected in SSRS custom report item (KB3204265) Reporting Services
9367894 Can’t export a report as an Excel workbook when the “Interpret HTML Tags as Styles” option is selected (KB3180980) Reporting Services
9367903 FIX: Error when you open Data Alert Manager in SQL Server 2014 or 2016 Reporting Services in SharePoint integrated mode (KB3197950) Reporting Services
9368268 FIX: RDL report that’s generated programmatically fails to run in SSRS (KB3157016) Reporting Services
9389933 FIX: User authentication failure in SSRS 2016 under the custom security extensions deployment (KB4013248) Reporting Services
9398927 FIX: Intermittent failure with System.NullReferenceException when you use custom authentication in SSRS 2016 (KB4014862) Reporting Services
9125813 FIX: SSRS 2016 mobile report that contains a shared dataset times out and doesn’t load (KB4013110) Reporting Services

Setup & Install Fixes

This update includes a fix for an issue encountered during patch installation on SQL Server instances with a large number of databases.

Bug Reference Description Fix Area
9503272 FIX: SQL Server is stopped when you install patches on an instance of SQL Server that contains many databases (KB4010990) Setup & Install

SQL Performance Fixes

A significant portion of this CU addresses SQL performance issues, covering areas like query optimization, statistics handling, and specific query patterns. These fixes aim to improve overall database performance and responsiveness.

Bug Reference Description Fix Area
9367879 Improvement: Improves the query performance for SQL Server 2016 by changing the use of histograms on UNIQUE columns (KB3202425) SQL performance
9230882 FIX: More CPU consumption when many consecutive transactions insert data into a temp table in SQL Server 2016 than in SQL Server 2014 (KB3216543) SQL performance
9237319 FIX: Incremental statistics run with higher sample rate than regular statistics when statistics are created or updated in SQL Server 2014 or 2016 (KB3196877) SQL performance
9237342 FIX: Incorrect query result when you use varchar(max) variable in the search condition in SQL Server 2014 or 2016 (KB3208245) SQL performance
9237347 FIX: Error 2809 when you execute a stored procedure that takes a table-valued parameter from RPC calls in SQL Server 2014 or 2016 (KB3205935) SQL performance
9330686 FIX: Assertion error when dm_exec_query_statistics_xml is used in a query plan that contains certain operators in SQL Server 2016 (KB4010984) SQL performance
9367877 FIX: Can’t insert data into a table that uses a clustered columnstore index in SQL Server 2016 (KB3211602) SQL performance
9367885 Statistics are removed after rebuilding a specific partition of a partitioned aligned index on a partitioned table in SQL Server (KB3194959) SQL performance
9367888 FIX: Deadlock when you execute a query plan with a nested loop join in batch mode in SQL Server 2014 or 2016 (KB3195825) SQL performance
9367898 FIX: Rebuilding a nonclustered index to add columns by using CREATE INDEX with DROP_EXISTING=ON and ONLINE=ON causes blocking (KB3194365) SQL performance
9367929 FIX: Unable to rebuild the partition online for a table that contains a computed partitioning column in SQL Server 2016 (KB3213683) SQL performance
9503250 FIX: AFTER DELETE triggers occur in the wrong order in the ON DELETE CASCADE action chain in SQL Server 2014 and 2016 (KB4009823) SQL performance

SQL Security Fixes

This CU addresses security-related issues within SQL Server, focusing on areas like Transparent Data Encryption (TDE) and permission handling. These fixes are crucial for maintaining a secure database environment.

Bug Reference Description Fix Area
9367897 FIX: TDE encrypted Databases go in suspect state during the recovery phase when you restart SQL Server (KB3197631) SQL security
9503270 FIX: Memory leak when you run a query that you don’t have sufficient permissions for in SQL Server 2014 or 2016 (KB4010710) SQL security

SQL Service Fixes

A large number of fixes in this CU fall under the SQL Service category. These fixes cover a wide range of core database engine functionalities, including DBCC commands, replication, full-text search, memory management, and various internal engine operations. These improvements are essential for the overall stability and reliability of the SQL Server engine.

Bug Reference Description Fix Area
9237417 Updates to DBCC CLONEDATABASE functionality in SQL Server 2014 and 2016 (KB3208246) SQL service
9367895 Improvement: Enhance VDI Protocol with VDC_Complete command in SQL Server (KB3188454) SQL service
9452932 Improvement: Enable SQL Server Managed Backup to back up databases that are larger than 50 GB to Microsoft Azure in SQL Server 2016 (KB4014002) SQL service
9452934 Improvement: Enable DBCC CLONEDATABASE to clone a full-text object in SQL Server 2016 SP1 (KB4013120) SQL service
9473330 Update improves DMV sys.dm_os_sys_info and sys.dm_os_sys_info in SQL Server 2016 (KB4013125) SQL service
9503182 Update improves handling of documents too large for Full-Text Search indexing in SQL Server 2014 or 2016 (KB3208276) SQL service
8532466 FIX: Internal error ‘FAC_HK_INTERNAL’ when you insert or update large numbers of rows of data into or in a memory-optimized table in SQL Server 2016 (KB4009794) SQL service
8845976 A memory leak occurs when you use Azure Storage in SQL Server 2014 or 2016 (KB3174370) SQL service
9061115 FIX: Can’t install SQL Server R Services during an offline installation of SQL Server 2016 updates (KB3210708) SQL service
9069693 FIX: Wrong number of rows returned in sys.partitions for Columnstore index in SQL Server 2016 (KB3195752) SQL service
9193209 FIX: Data type conversion error in a query that involves a column store index in SQL Server 2016 (KB4013883) SQL service
9234045 FIX: “(0x80004002) No such interface supported” error when you use RMO to run Web Synchronization for Merge Replication in SQL Server 2016 (KB4014719) SQL service
9237302 FIX: The change table is ordered incorrectly for updated rows after you enable change data capture for a Microsoft SQL Server database (KB3030352) SQL service
9237313 FIX: Memory is paged out when columnstore index query consumes lots of memory in SQL Server 2014 or 2016 (KB3067968) SQL service
9237369 FIX: Incorrect full-text keys are recorded for the rows that aren’t indexed correctly by a full-text index in SQL Server (KB3196012) SQL service
9237390 FIX: Intra-query deadlock when values are inserted into a partitioned clustered columnstore index in SQL Server 2014 or 2016 (KB3204769) SQL service
9237395 FIX: Distribution Agent fails for a SQL Server 2014 publisher and a SQL Server 2012 subscriber in Transactional Replication (KB3204469) SQL service
9237399 FIX: Memory leak when you query sys.dm_sql_referenced_entities view in SQL Server 2014 or 2016 (KB3205994) SQL service
9237405 FIX: Error 21050 when you remove a table that’s not part of a publication in SQL Server 2014 or 2016 (KB3209459) SQL service
9237407 FIX: Adding a subscription to an Oracle transactional publication or an Oracle snapshot publication fails in SQL Server 2014 or 2016 (KB3208243) SQL service
9324510 FIX: Error when you add a NOT NULL column with default values to a non-empty clustered columnstore index in SQL Server 2016 Standard and Express edition (KB4013851) SQL service
9367828 FIX: Changing the data type and then updating the table with more than 4,000 records causes database corruption (KB3213240) SQL service
9367873 FIX: “Non-yielding Scheduler” condition when you parallel-load data into a columnstore index in SQL Server 2016 (KB3205411) SQL service
9367887 SQL Server crashes with an access violation when you use the TRY…CATCH construct for bulk copy (KB3184099) SQL service
9367909 FIX: An access violation occurs when you execute DBCC CHECKDB on a database in SQL Server 2016 (KB3212482) SQL service
9367910 FIX: Out-of-memory errors when you execute DBCC CHECKDB on database that contains columnstore indexes in SQL Server 2014 or 2016 (KB3201416) SQL service
9367921 FIX: SQL Server crashes when you execute a spatial data query that has been compiled in SQL Server 2016 (KB3212789) SQL service
9367922 FIX: Error when creating a stored procedure that uses a synonym together with an index hint in SQL Server 2016 (KB3213263) SQL service
9367923 FIX: SQL Server crashes when you execute the OPENJSON function in a contained database in SQL Server 2016 (KB3210597) SQL service
9367931 FIX: A memory leak occurs when SQL Server procedure cache consumes too much memory (KB3212523) SQL service
9367933 FIX: An assert error occurs when you insert data into a memory-optimized table that contains a clustered columnstore index in SQL Server 2016 (KB3211338) SQL service
9367939 FIX: Error 3628 when you create or rebuild a columnstore index in SQL Server 2016 (KB3213283) SQL service
9371007 FIX: “ADD PERIOD FOR SYSTEM_TIME failed” error when you add period columns to a memory-optimized table in SQL Server 2016 (KB4013112) SQL service
9379510 FIX: CREATE OR ALTER statement applied on a DDL trigger fails on the next execution in SQL Server 2016 (KB4013115) SQL service
9398869 FIX: The sys.column_store_segments catalog view displays incorrect values in the column_id column in SQL Server 2016 (KB4013118) SQL service
9403683 FIX: SQL Server 2014 or 2016 crashes on the execution of the DBCC CLONEDATABASE command (KB5852300) SQL service
9452905 FIX: DBCC CLONEDATABASE doesn’t copy the runtime cache of the query store to the clone in SQL Server 2016 SP1 (KB4013119) SQL service
9468558 FIX: “Incorrect syntax for definition of the ‘default’ constraint” error when you add an arbitrary columnstore column in SQL Server 2016 (KB4013207) SQL service
9491976 FIX: SQL Server Launchpad service fails to start if the installed version of R Services (In-Database) is different from the Database Engine in SQL Server 2016 (KB4014734) SQL service
9503255 FIX: Can’t set a database to partial containment if SQL Server change tracking was ever enabled on that database (KB3212318) SQL service
9503266 FIX: A system assert occurs when a Transact-SQL stored procedure with a TVP argument is called from a SQLCLR procedure (KB4010162) SQL service
9619420 FIX: Significantly increased PAGELATCH_EX contentions in sys.sysobjvalues in SQL Server 2016 (KB4013999) SQL service
9367920 FIX: DBCC CHECKFILEGROUP reports false inconsistency error 5283 on a database that contains a partitioned table in SQL Server (KB3108537) SQL service

Download Information

The latest cumulative update package is available for download from the Microsoft Download Center.

Download the latest cumulative update package for SQL Server 2016 SP1 now

If you encounter issues accessing the download page, you can contact Microsoft Customer Service and Support to obtain the package.

Cumulative Updates for SQL Server 2016 SP1

Cumulative Updates (CUs) are a crucial part of maintaining a healthy and up-to-date SQL Server environment. Microsoft releases CUs regularly, and they are available through the Microsoft Download Center. It is important to understand how CUs work and why they are recommended for proactive installation.

Only the most recent CU released for SQL Server 2016 SP1 is available on the Download Center. This ensures that you are always getting the latest fixes and improvements.

Recommendation for Applying CUs

Microsoft strongly recommends the ongoing and proactive installation of Cumulative Updates as they are released. Here’s why:

  • Certified Reliability: SQL Server CUs undergo the same rigorous certification process as Service Packs. You can install them with the same level of confidence in their quality and stability.
  • Addressing Known Issues: Historical data shows that a significant percentage of support cases are related to issues that have already been resolved in a released CU. Installing CUs can prevent you from encountering known problems and needing to contact support for already-solved issues.
  • Added Value: CUs are not just collections of hotfixes. They often include valuable additions beyond bug fixes, such as updates that improve supportability, manageability, and overall reliability of SQL Server.

Testing CUs

Just like with SQL Server Service Packs, it is highly recommended to thoroughly test Cumulative Updates in a non-production environment before deploying them to your production systems. This testing phase allows you to identify and address any potential compatibility issues or unexpected behavior in a controlled setting, minimizing risks to your live databases.

Upgrading to Latest Service Pack

Microsoft recommends that you keep your SQL Server installation as current as possible. Upgrading to the latest SQL Server 2016 service pack is a best practice to ensure you benefit from the most recent features, performance enhancements, and security updates. Service packs are comprehensive updates that include all previous cumulative updates and represent a significant step in maintaining a robust SQL Server environment.

Deployment in Hybrid Environments

When deploying hotfixes, including Cumulative Updates, in hybrid environments such as Always On Availability Groups, replication setups, clusters, and mirroring configurations, it is essential to follow specific procedures to minimize downtime and ensure a smooth update process. Consult the following articles before applying hotfixes in these environments:

Upgrade a Failover Cluster Instance

Upgrade a SQL Server failover cluster instance provides guidance on updating clustered SQL Server instances.

Note: If you prefer not to use the rolling update process for failover clusters, you can follow these steps to apply a CU or SP:
1. Install the service pack on the passive node first.
2. Then, install the service pack on the active node. This step will require a service restart, so plan accordingly.

Upgrade and Update of Availability Group Servers

Upgrade and update of availability group servers that use minimal downtime and data loss details the process for updating servers participating in Always On Availability Groups while minimizing disruption.

Note: If you are using Always On with the SSISDB catalog, refer to information about SSIS with Always On for specific instructions on applying CUs or SPs in these environments.

Applying Hotfixes in Replication Topologies

These articles provide detailed steps for applying hotfixes in SQL Server replication environments, ensuring that the replication topology remains consistent and functional throughout the update process.

Upgrading Mirrored Instances

Upgrading Mirrored Instances offers specific guidance on upgrading SQL Server instances involved in database mirroring.

Overview of SQL Server Servicing Installation

Overview of SQL Server Servicing Installation provides a broader overview of SQL Server servicing and installation best practices, which is helpful for understanding the general context of applying updates.

Language Support

SQL Server Cumulative Updates are designed to be multilingual. This means that this specific cumulative update package is not language-specific and is applicable to all supported languages of SQL Server 2016 SP1.

The “Download the latest cumulative update package for Microsoft SQL Server 2016 now” form on the download center will display the languages for which specific localized update packages are available. If your language is not listed, it indicates that a language-specific CU package is not available for that language, and the English (ENU) download is designed to be applied to all languages.

Components Updated

A single cumulative update package includes updates for all components of SQL Server. However, when you install the CU package, it intelligently updates only those SQL Server components that are actually installed on your specific system. This streamlined approach ensures that you only update the parts of SQL Server that are relevant to your environment, reducing unnecessary installation time and potential conflicts.

Support for This Update

If you encounter any issues not specifically addressed in this cumulative update, or if you require troubleshooting assistance related to this CU, you may need to create a separate service request with Microsoft Support. Standard support costs will apply to additional support inquiries and issues that are not directly related to this specific cumulative update package.

For a comprehensive list of Microsoft Customer Service and Support telephone numbers, or to create a new service request, please visit the Microsoft support website.

Uninstalling This Update

If, for any reason, you need to uninstall this cumulative update, you can do so through the Control Panel in Windows. Follow these steps:

  1. Open Control Panel.
  2. Select Add or Remove Programs.
    • Note: If you are using Windows 7 or a later version of Windows, choose Programs and Features in Control Panel instead.
  3. Locate and select the entry corresponding to this Cumulative Update package in the list of installed programs.
  4. Right-click (or press and hold) on the entry and choose Uninstall.
  5. Follow the on-screen prompts to complete the uninstallation process.

Prerequisites

Before applying this cumulative update package, it is essential to ensure that your system is already running SQL Server 2016 SP1. This Cumulative Update is designed specifically for SQL Server 2016 Service Pack 1 and will not install correctly on earlier versions or editions of SQL Server 2016. Verify your current SQL Server version before proceeding with the installation to avoid any compatibility issues.

Restart Requirement

After you apply this cumulative update package, you might be prompted to restart your computer. A restart may be necessary to fully apply all the changes included in the CU and to ensure that all SQL Server services are running with the updated components. It is recommended to plan for a potential restart after installation, especially in production environments, to minimize disruption.

Registry Information

To utilize the fixes included in this cumulative update package, you do not need to make any modifications to the Windows Registry. The fixes are applied directly through the installation process of the CU package without requiring manual registry edits. This simplifies the update process and reduces the risk of introducing errors through manual registry changes.

File Information

The following tables list the file information for the x86-based and x64-based versions of this cumulative update package. These details can be helpful for verifying the successful application of the update and for inventory purposes.

x86-based versions

SQL Server 2016 Database Services Common Core

File name File version File size Date Time Platform
Microsoft.sqlserver.edition.dll 13.0.4422.0 37056 07-Mar-17 00:17 x86
Microsoft.sqlserver.instapi.dll 13.0.4422.0 46272 07-Mar-17 00:17 x86
Microsoft.sqlserver.mgdsqldumper.dll 2015.130.4422.0 72896 07-Mar-17 00:17 x86
Pbsvcacctsync.dll 2015.130.4422.0 60096 07-Mar-17 00:16 x86
Sql_common_core_keyfile.dll 2015.130.4422.0 88768 07-Mar-17 00:17 x86
Sqlmgmprovider.dll 2015.130.4422.0 364224 07-Mar-17 00:16 x86
Sqlsvcsync.dll 2015.130.4422.0 267456 07-Mar-17 00:16 x86
Sqltdiagn.dll 2015.130.4422.0 60608 07-Mar-17 00:16 x86
Svrenumapi130.dll 2015.130.4422.0 854208 07-Mar-17 00:16 x86

SQL Server 2016 Data Quality

File name File version File size Date Time Platform
Microsoft.ssdqs.infra.dll 13.0.4422.0 1876672 07-Mar-17 00:17 x86

SQL Server 2016 sql_tools_extensions

File name File version File size Date Time Platform
Microsoft.analysisservices.project.dll 2015.130.4422.0 2023104 07-Mar-17 00:17 x86
Microsoft.sqlserver.chainer.infrastructure.dll 13.0.4422.0 433856 07-Mar-17 00:17 x86
Microsoft.sqlserver.configuration.sco.dll 13.0.4422.0 2044616 07-Mar-17 00:17 x86
Microsoft.sqlserver.configuration.sstring.dll 13.0.4422.0 33480 07-Mar-17 00:17 x86
Microsoft.sqlserver.deployment.dll 13.0.4422.0 249536 07-Mar-17 00:17 x86
Msmgdsrv.dll 2015.130.4422.0 6507712 07-Mar-17 00:17 x86
Sql_tools_extensions_keyfile.dll 2015.130.4422.0 88768 07-Mar-17 00:17 x86
Xmsrv.dll 2015.130.4422.0 32715456 07-Mar-17 00:17 x86

x64-based versions

SQL Server 2016 Writer

File name File version File size Date Time Platform
Sqlvdi.dll 2015.130.4422.0 168640 07-Mar-17 00:16 x86
Sqlvdi.dll 2015.130.4422.0 197312 07-Mar-17 00:17 x64
Sqlwriter_keyfile.dll 2015.130.4422.0 100544 07-Mar-17 00:17 x64

SQL Server 2016 Analysis Services

File name File version File size Date Time Platform
Msmdsrv.exe 2015.130.4422.0 56698048 07-Mar-17 01:34 x64
Msmgdsrv.dll 2015.130.4422.0 6507712 07-Mar-17 00:17 x86
Msmgdsrv.dll 2015.130.4422.0 7506624 07-Mar-17 00:17 x64
Sql_as_keyfile.dll 2015.130.4422.0 100544 07-Mar-17 00:17 x64
Sqlceip.exe 13.0.4422.0 246976 07-Mar-17 01:34 x86
Tmapi.dll 2015.130.4422.0 4346056 07-Mar-17 00:16 x64
Tmcachemgr.dll 2015.130.4422.0 2825920 07-Mar-17 00:16 x64
Tmpersistence.dll 2015.130.4422.0 1071304 07-Mar-17 00:16 x64
Tmtransactions.dll 2015.130.4422.0 1351368 07-Mar-17 00:16 x64
Xmsrv.dll 2015.130.4422.0 24039104 07-Mar-17 00:16 x64
Xmsrv.dll 2015.130.4422.0 32715456 07-Mar-17 00:17 x86

SQL Server 2016 Database Services Common Core

File name File version File size Date Time Platform
Microsoft.sqlserver.edition.dll 13.0.4422.0 37056 07-Mar-17 00:17 x86
Microsoft.sqlserver.instapi.dll 13.0.4422.0 46272 07-Mar-17 00:17 x86
Microsoft.sqlserver.mgdsqldumper.dll 2015.130.4422.0 75456 07-Mar-17 00:16 x64
Microsoft.sqlserver.mgdsqldumper.dll 2015.130.4422.0 72896 07-Mar-17 00:17 x86
Pbsvcacctsync.dll 2015.130.4422.0 60096 07-Mar-17 00:16 x86
Pbsvcacctsync.dll 2015.130.4422.0 72896 07-Mar-17 00:17 x64
Sql_common_core_keyfile.dll 2015.130.4422.0 100544 07-Mar-17 00:17 x64
Sqlmgmprovider.dll 2015.130.4422.0 364224 07-Mar-17 00:16 x86
Sqlmgmprovider.dll 2015.130.4422.0 404160 07-Mar-17 00:16 x64
Sqlsvcsync.dll 2015.130.4422.0 267456 07-Mar-17 00:16 x86
Sqlsvcsync.dll 2015.130.4422.0 348864 07-Mar-17 00:16 x64
Sqltdiagn.dll 2015.130.4422.0 60608 07-Mar-17 00:16 x86
Sqltdiagn.dll 2015.130.4422.0 67776 07-Mar-17 00:16 x64
Svrenumapi130.dll 2015.130.4422.0 854208 07-Mar-17 00:16 x86
Svrenumapi130.dll 2015.130.4422.0 1115840 07-Mar-17 00:16 x64

SQL Server 2016 Data Quality

File name File version File size Date Time Platform
Microsoft.ssdqs.infra.dll 13.0.4422.0 1876672 07-Mar-17 00:17 x86
Microsoft.ssdqs.infra.dll 13.0.4422.0 1876680 07-Mar-17 00:17 x86

SQL Server 2016 Database Services Core Instance

File name File version File size Date Time Platform
Databasemail.exe 13.0.16100.4 29888 09-Dec-16 00:46 x64
Hkcompile.dll 2015.130.4422.0 1297096 07-Mar-17 00:17 x64
Hkengine.dll 2015.130.4422.0 5599936 07-Mar-17 00:18 x64
Hkruntime.dll 2015.130.4422.0 158912 07-Mar-17 00:18 x64
Microsoft.sqlautoadmin.sqlautoadmin.dll 13.0.4422.0 79552 07-Mar-17 01:34 x86
Microsoft.sqlserver.types.dll 2015.130.4422.0 391872 07-Mar-17 00:16 x86
Microsoft.sqlserver.vdiinterface.dll 2015.130.4422.0 71360 07-Mar-17 00:17 x64
Qds.dll 2015.130.4422.0 843968 07-Mar-17 00:17 x64
Sql_engine_core_inst_keyfile.dll 2015.130.4422.0 100544 07-Mar-17 00:17 x64
Sqlaccess.dll 2015.130.4422.0 462528 07-Mar-17 00:16 x64
Sqlagent.exe 2015.130.4422.0 565952 07-Mar-17 01:33 x64
Sqlceip.exe 13.0.4422.0 246976 07-Mar-17 01:34 x86
Sqldk.dll 2015.130.4422.0 2584768 07-Mar-17 00:17 x64
Sqllang.dll 2015.130.4422.0 39375552 07-Mar-17 00:17 x64
Sqlmin.dll 2015.130.4422.0 37597896 07-Mar-17 00:16 x64
Sqlos.dll 2015.130.4422.0 26304 07-Mar-17 00:17 x64
Sqlscriptdowngrade.dll 2015.130.4422.0 27840 07-Mar-17 00:16 x64
Sqlscriptupgrade.dll 2015.130.4422.0 5797056 07-Mar-17 00:17 x64
Sqlservr.exe 2015.130.4422.0 392896 07-Mar-17 01:33 x64
Sqltses.dll 2015.130.4422.0 8897216 07-Mar-17 00:16 x64
Stretchcodegen.exe 13.0.4422.0 56000 07-Mar-17 01:34 x86
Xpstar.dll 2015.130.4422.0 422592 07-Mar-17 00:17 x64

SQL Server 2016 Database Services Core Shared

File name File version File size Date Time Platform
Microsoft.sqlserver.integrationservice.hadoopconnections.ui.dll 13.0.4422.0 70848 07-Mar-17 00:16 x86
Microsoft.sqlserver.integrationservice.hadooptasks.dll 13.0.4422.0 73408 07-Mar-17 00:16 x86
Microsoft.sqlserver.integrationservice.hadooptasks.ui.dll 13.0.4422.0 63680 07-Mar-17 00:16 x86
Microsoft.sqlserver.management.pssnapins.dll 13.0.4422.0 215232 07-Mar-17 00:17 x86
Microsoft.sqlserver.management.sdk.scripting.dll 13.0.14510.3 30912 12-Oct-16 10:35 x86
Microsoft.sqlserver.replication.dll 2015.130.4422.0 1639104 07-Mar-17 00:17 x64
Sql_engine_core_shared_keyfile.dll 2015.130.4422.0 100544 07-Mar-17 00:17 x64
Sqlmergx.dll 2015.130.4422.0 346824 07-Mar-17 00:16 x64
Txdatacollector.dll 2015.130.4422.0 367296 07-Mar-17 00:16 x64

SQL Server 2016 sql_extensibility

File name File version File size Date Time Platform
Launchpad.exe 2015.130.4422.0 1013960 07-Mar-17 00:17 x64
Sql_extensibility_keyfile.dll 2015.130.4422.0 100544 07-Mar-17 00:17 x64
Sqlsatellite.dll 2015.130.4422.0 837312 07-Mar-17 00:17 x64

SQL Server 2016 Full-Text Engine

File name File version File size Date Time Platform
Fd.dll 2015.130.4422.0 660160 07-Mar-17 00:17 x64
Sql_fulltext_keyfile.dll 2015.130.4422.0 100544 07-Mar-17 00:17 x64

SQL Server 2016 sql_inst_mr

File name File version File size Date Time Platform
Imrdll.dll 13.0.4422.0 23744 07-Mar-17 01:34 x86
Sql_inst_mr_keyfile.dll 2015.130.4422.0 100544 07-Mar-17 00:17 x64

SQL Server 2016 Integration Services

File name File version File size Date Time Platform
Microsoft.sqlserver.integrationservice.hadooptasks.dll 13.0.4422.0 73408 07-Mar-17 00:16 x86
Microsoft.sqlserver.integrationservice.hadooptasks.dll 13.0.4422.0 73408 07-Mar-17 00:17 x86
Msdtssrvr.exe 13.0.4422.0 216768 07-Mar-17 01:34 x64
Sql_is_keyfile.dll 2015.130.4422.0 100544 07-Mar-17 00:17 x64
Sqlceip.exe 13.0.4422.0 246976 07-Mar-17 01:34 x86

SQL Server 2016 Reporting Services

File name File version File size Date Time Platform
Microsoft.reportingservices.datarendering.dll 13.0.4422.0 166088 07-Mar-17 00:17 x86
Microsoft.reportingservices.diagnostics.dll 13.0.4422.0 1621184 07-Mar-17 00:17 x86
Microsoft.reportingservices.excelrendering.dll 13.0.4422.0 657608 07-Mar-17 00:17 x86
Microsoft.reportingservices.htmlrendering.dll 13.0.4422.0 1069760 07-Mar-17 00:17 x86
Microsoft.reportingservices.portal.interfaces.dll 13.0.4422.0 125128 07-Mar-17 00:17 x86
Microsoft.reportingservices.portal.services.dll 13.0.4422.0 4920512 07-Mar-17 00:17 x86
Microsoft.reportingservices.portal.web.dll 13.0.4422.0 10417344 07-Mar-17 00:17 x86
Microsoft.reportingservices.portal.webhost.exe 13.0.4422.0 93888 07-Mar-17 01:34 x64
Microsoft.reportingservices.processingcore.dll 13.0.4422.0 5951168 07-Mar-17 00:17 x86
Microsoft.reportingservices.sharepoint.server.dll 13.0.4422.0 245952 07-Mar-17 00:16 x86
Microsoft.reportingservices.spbprocessing.dll 13.0.4422.0 298176 07-Mar-17 00:16 x86
Microsoft.reportingservices.upgradescripts.dll 13.0.4422.0 501960 07-Mar-17 00:16 x86
Microsoft.sqlserver.types.dll 2015.130.4422.0 391872 07-Mar-17 00:16 x86
Microsoft.sqlserver.types.dll 2015.130.4422.0 396992 07-Mar-17 00:17 x86
Msmgdsrv.dll 2015.130.4422.0 6507712 07-Mar-17 00:17 x86
Msmgdsrv.dll 2015.130.4422.0 7506624 07-Mar-17 00:17 x64
Reportingserviceslibrary.dll 13.0.4422.0 2521800 07-Mar-17 00:17 x86
Reportingservicesnativeclient.dll 2015.130.4422.0 114368 07-Mar-17 00:16 x86
Reportingservicesnativeclient.dll 2015.130.4422.0 108744 07-Mar-17 00:17 x64
Reportingservicesnativeserver.dll 2015.130.4422.0 99008 07-Mar-17 00:17 x64
Reportingserviceswebserver.dll 13.0.4422.0 2707648 07-Mar-17 00:17 x86
Sql_rs_keyfile.dll 2015.130.4422.0 100544 07-Mar-17 00:17 x64
Xmsrv.dll 2015.130.4422.0 24039104 07-Mar-17 00:16 x64
Xmsrv.dll 2015.130.4422.0 32715456 07-Mar-17 00:17 x86

SQL Server 2016 sql_shared_mr

File name File version File size Date Time Platform
Smrdll.dll 13.0.4422.0 23752 07-Mar-17 00:17 x86
Sql_engine_core_shared_keyfile.dll 2015.130.4422.0 100544 07-Mar-17 00:17 x64

SQL Server 2016 sql_tools_extensions

File name File version File size Date Time Platform
Microsoft.analysisservices.project.dll 2015.130.4422.0 2023104 07-Mar-17 00:17 x86
Microsoft.sqlserver.chainer.infrastructure.dll 13.0.4422.0 433856 07-Mar-17 00:16 x86
Microsoft.sqlserver.chainer.infrastructure.dll 13.0.4422.0 433856 07-Mar-17 00:17 x86
Microsoft.sqlserver.configuration.sco.dll 13.0.4422.0 2044608 07-Mar-17 00:16 x86
Microsoft.sqlserver.configuration.sco.dll 13.0.4422.0 2044616 07-Mar-17 00:17 x86
Microsoft.sqlserver.configuration.sstring.dll 13.0.4422.0 33472 07-Mar-17 00:16 x86
Microsoft.sqlserver.configuration.sstring.dll 13.0.4422.0 33480 07-Mar-17 00:17 x86
Microsoft.sqlserver.deployment.dll 13.0.4422.0 249536 07-Mar-17 00:16 x86
Microsoft.sqlserver.deployment.dll 13.0.4422.0 249536 07-Mar-17 00:17 x86
Msmgdsrv.dll 2015.130.4422.0 6507712 07-Mar-17 00:17 x86
Msmgdsrv.dll 2015.130.4422.0 7506624 07-Mar-17 00:17 x64
Sql_tools_extensions_keyfile.dll 2015.130.4422.0 100544 07-Mar-17 00:17 x64
Xmsrv.dll 2015.130.4422.0 24039104 07-Mar-17 00:16 x64
Xmsrv.dll 2015.130.4422.0 32715456 07-Mar-17 00:17 x86

Stay informed about the latest updates and fixes for SQL Server 2016 SP1 by regularly checking the Microsoft Download Center and relevant Microsoft documentation. Applying Cumulative Updates is a crucial step in maintaining a stable, secure, and high-performing SQL Server environment.

If you have installed this Cumulative Update, or if you have any questions or experiences to share, please feel free to leave a comment below! Your feedback is valuable to the community.

Post a Comment