SQL Server 2022: Boost Performance with Cumulative Update 11 (KB5032679)

Table of Contents

SQL Server 2022 Cumulative Update 11

Summary of Cumulative Update 11

This article details Cumulative Update package 11 (CU11) for Microsoft SQL Server 2022. Released on January 11, 2024, this update package brings the version to 16.0.4105.2. It is designed to enhance the stability, performance, and security of your SQL Server 2022 instances. CU11 incorporates a total of 16 crucial fixes addressing various issues encountered since the release of SQL Server 2022 Cumulative Update 10.

The update applies to key components of SQL Server 2022. Specifically, the SQL Server Database Engine is updated to product version 16.0.4105.2 with file version 2022.160.4105.2. The Analysis Services component is updated to product version 16.0.43.222 with file version 2022.160.43.222. Installing this cumulative update ensures these core components are brought up to the latest build incorporating the necessary bug fixes and improvements.

Known Issue with Read-Scale Availability Groups in CU10

SQL Server 2022 CU10 introduced a specific issue affecting read-scale availability groups. This problem stemmed from fix 2714261, which caused inaccurate reporting in sys.dm_hadr_database_replica_cluster_states. Consequently, users might have observed that the Availability Databases folder within SQL Server Management Studio (SSMS) did not correctly list the databases belonging to the availability group (AG).

A temporary mitigation for this issue was to roll back the installed patch to CU9. However, it’s important to note that a permanent resolution for this particular problem has been included in a subsequent update. Users experiencing this specific issue should be aware that it is effectively fixed in SQL Server 2022 CU12, not this CU11.

A comprehensive Excel workbook detailing the build versions, their support lifecycle, and detailed fix lists for SQL Server 2022, SQL Server 2019, and SQL Server 2017 is typically made available by Microsoft. This resource is invaluable for tracking updates and understanding the contents of each release. While a direct link is not provided here as per instructions, such a resource is part of the broader SQL Server documentation.

For a detailed understanding of the specific bugs resolved and enhancements delivered in this Cumulative Update 11, you can refer to the information typically provided in associated Microsoft Knowledge Base articles. The following table summarizes the fixes included in this package. Note that bug reference IDs often correspond to specific internal tracking numbers.

Bug Reference Description Fix Area Component Platform
2767578 Fixes an issue where the Find Parent feature fails in Master Data Services if the target node is part of the search results. Master Data Services Master Data Services Windows
2773751 Addresses an issue in Master Data Services where downloading an attachment fails for a newly created entity if its code value already exists in a previously deleted record. Master Data Services Master Data Services Windows
2807414 Resolves a dump issue and a specific exception (INVALID_POINTER_WRITE_c0000005_sqllang.dll!CBatch::PTaskGetWithAddRef). This occurs when the reference count on a connection object, obtained by the session monitor, isn’t correctly released under failure conditions, potentially leading to dangling session objects. SQL Connectivity SQL Connectivity All
2702535 Fixes an access violation encountered at InitCollationSensitiveLookupHash when performing a point search on a string column within an In-Memory OLTP columnstore table. SQL Server Engine Column Stores Windows
2710571 Addresses an issue where the creation of a contained availability group fails, resulting in a dump, if a login holds the sysadmin role along with other server-level roles specific only to that SQL Server instance. This could cause the instance to become unresponsive. SQL Server Engine High Availability and Disaster Recovery All
2766491 Fixes an access violation dump issue observed when dropping a distributed availability group (AG) that contains a suspect AG database on a forwarder replica. SQL Server Engine High Availability and Disaster Recovery All
2765109 Resolves a performance degradation in query execution time after running the OPTIMIZE operation on a delta table stored in S3-compatible object storage. This fix also improves querying performance for delta tables hosted on Azure Blob Storage and Azure Data Lake Storage Gen2. SQL Server Engine PolyBase All
2766490 Fixes an intra-query deadlock that could occur during the execution of certain query plans involving nested loop joins when running in batch mode. SQL Server Engine Query Execution All
2770546 Addresses an assertion failure (Location: IntSafeWrapperRetail.cpp:31; Expression: !"Arithmetic operation failed") encountered when using the LIKE predicate in queries. SQL Server Engine Query Execution All
2787964 Fixes an issue where the Cardinality Estimation (CE) feedback mechanism incorrectly generated an empty USE HINT clause when suggesting query hints. SQL Server Engine Query Execution All
1982808 Corrects an issue where the distribution agent fails during transactional replication setup involving memory-optimized tables at the Subscriber, specifically when the “replication support only” option is used. This previously resulted in error 12302 when the MSupd_articlename stored procedure failed. SQL Server Engine Replication Windows
2782283 Resolves an error (Msg 2601) that occurs when cloning a database with a large, partitioned full-text index and subsequently running DBCC CHECKDB. The error indicated a duplicate key insertion into an object with a unique index during the check. SQL Server Engine Search All
2789527 Fixes error 9833 encountered when executing the sp_helplogins stored procedure against a database configured with UTF-8 character encoding. The error message indicated invalid data for UTF-8 encoded characters. SQL Server Engine Security Infrastructure All
2744933 Addresses a non-yielding scheduler dump issue related to sqldk!SOS_Node::SpreadMultipleTasksAcrossNodes. This occurred on hardware configurations with more than 64 logical processors per NUMA node. The fix now causes SQL Server service shutdown upon detecting this configuration at startup, aligning with compute capacity limits. SQL Server Engine SQL OS All
2782340 Resolves a “Stalled Resource Monitor” dump issue that could be triggered following out-of-memory (OOM) exceptions, such as error 701. This improves the stability of the SQL OS component during memory pressure situations. SQL Server Engine SQL OS All
2724957 Fixes a setup failure where the SQL_SNAC_SDK feature might not be added correctly during SQL Server installation. This happened if a later version of the SQL_SNAC_CORE feature (from msoledbsql.msi) was already installed on the machine than the one included with the SQL Server installation media. The setup now blocks this scenario to prevent failure. A workaround involving modifying the OLE DB Driver installation is also provided. SQL Setup Deployment Platform Windows

Each fix addresses a specific scenario, ranging from stability issues (dumps, access violations, deadlocks) and performance problems (PolyBase, Query Execution) to specific feature bugs (Master Data Services, Replication, Full-Text Search) and setup concerns. Applying this cumulative update helps ensure your SQL Server 2022 environment benefits from these critical corrections.

Obtaining and Installing Cumulative Update 11

Keeping your SQL Server instance updated with the latest cumulative updates is a recommended practice for maintaining a stable and high-performing database environment. Microsoft provides multiple channels to obtain and install CU11 for SQL Server 2022, depending on your operating system and deployment method.

Obtaining the Update for Windows

For Windows installations of SQL Server 2022, the cumulative update package can typically be obtained from the Microsoft Download Center or the Microsoft Update Catalog.

The Microsoft Download Center is usually the primary location to download the latest CU package directly. Visiting the specific download page for SQL Server 2022 cumulative updates will provide access to the executable file (e.g., SQLServer2022-KB5032679-x64.exe) needed for installation. This method is often preferred for manual installations or for updating offline servers.

Alternatively, the update package is also available through the Microsoft Update Catalog. This catalog is a comprehensive resource listing all software updates released by Microsoft. Searching for the specific Knowledge Base article number (KB5032679) will yield the download link for the CU11 package. The Update Catalog is also the source used by Windows Update and Windows Server Update Services (WSUS). This means that if your servers are configured to receive updates via WSUS, CU11 might be deployed automatically or made available for approval through that system. It is generally recommended to install the latest cumulative update available to ensure you have the most current set of fixes and improvements.

Obtaining the Update for Linux

For SQL Server 2022 instances running on Linux, the update process leverages the platform’s native package management system. To update to CU11, you must first ensure that the Cumulative Update repository for SQL Server on Linux is correctly configured on your system.

Once the repository is set up, you can update the SQL Server packages using the standard update command for your specific Linux distribution (e.g., apt update && apt install mssql-server for Ubuntu, yum update mssql-server for RHEL/CentOS, or zypper update mssql-server for SLES). The package manager will then download and install the latest available cumulative update, which includes CU11. Detailed installation instructions and direct links to repository configurations are provided in the official SQL Server 2022 Release Notes documentation for Linux.

File Information for Cumulative Update 11

Understanding the files included in a cumulative update and verifying their integrity is an important part of the installation process. For the Windows package (SQLServer2022-KB5032679-x64.exe), you can verify the integrity of the downloaded file by computing its SHA256 hash. Using a command-line tool like certutil (available on Windows), you can execute the command certutil -hashfile SQLServer2022-KB5032679-x64.exe SHA256 and compare the output hash with the expected value provided by Microsoft.

The expected SHA256 hash for the SQLServer2022-KB5032679-x64.exe file is:
A7C447E35606C4B64817CD1C4CB6FB18DAAECC13D5998C052E81BC2AC574CB5D

The cumulative update package contains updated files for various SQL Server components. The file attributes, including name, version, size, date, time (in Coordinated Universal Time - UTC), and platform, are typically listed for the updated files. When viewing this information locally, the date and time will be converted to your local time zone based on your system settings. The tables below list a subset of the files updated in this package for x64-based versions across different components.

SQL Server 2022 Analysis Services

File Name File Version File Size Date Time Platform
Asplatformhost.dll 2022.160.43.222 336944 14-Nov-2023 19:01 x64
Microsoft.analysisservices.server.core.dll 16.0.43.222 2903608 14-Nov-2023 19:01 x86
Microsoft.data.mashup.sqlclient.dll 2.108.3243.0 24480 14-Nov-2023 19:03 x86
Microsoft.data.sqlclient.dll 1.14.21068.1 1920960 14-Nov-2023 19:03 x86
Microsoft.identity.client.dll 4.14.0.0 1350048 14-Nov-2023 19:03 x86
Microsoft.identitymodel.jsonwebtokens.dll 5.6.0.61018 65952 14-Nov-2023 19:03 x86
Microsoft.identitymodel.logging.dll 5.6.0.61018 26528 14-Nov-2023 19:03 x86
Microsoft.identitymodel.protocols.dll 5.6.0.61018 32192 14-Nov-2023 19:03 x86
Microsoft.identitymodel.protocols.openidconnect.dll 5.6.0.61018 103328 14-Nov-2023 19:03 x86
Microsoft.identitymodel.tokens.dll 5.6.0.61018 162720 14-Nov-2023 19:03 x86
Msmdctr.dll 2022.160.43.222 38960 14-Nov-2023 19:01 x64
Msmdlocal.dll 2022.160.43.222 53974984 14-Nov-2023 19:01 x86
Msmdlocal.dll 2022.160.43.222 71833648 14-Nov-2023 19:01 x64
Msmdpump.dll 2022.160.43.222 10335296 14-Nov-2023 19:01 x64
Msmdredir.dll 2022.160.43.222 8132032 14-Nov-2023 19:01 x86
Msmdsrv.exe 2022.160.43.222 71384624 14-Nov-2023 19:01 x64
Msmdsrv.rll 2022.160.43.222 956976 14-Nov-2023 19:01 x64
… (other Msmdsrv.rll files) …
Msmdsrvi.rll 2022.160.43.222 955440 14-Nov-2023 19:01 x64
… (other Msmdsrvi.rll files) …
Msmgdsrv.dll 2022.160.43.222 10083888 14-Nov-2023 19:01 x64
Msmgdsrv.dll 2022.160.43.222 8265680 14-Nov-2023 19:01 x86
Msolap.dll 2022.160.43.222 10970568 14-Nov-2023 19:01 x64
Msolap.dll 2022.160.43.222 8745008 14-Nov-2023 19:01 x86
Msolui.dll 2022.160.43.222 289736 14-Nov-2023 19:01 x86
Msolui.dll 2022.160.43.222 308272 14-Nov-2023 19:01 x64
Newtonsoft.json.dll 13.0.1.25517 704448 14-Nov-2023 19:03 x86
Sni.dll 1.1.1.0 555424 14-Nov-2023 19:03 x64
Sql_as_keyfile.dll 2022.160.4105.2 137152 14-Nov-2023 19:00 x64
Sqlceip.exe 16.0.4105.2 300992 14-Nov-2023 19:03 x86
Sqldumper.exe 2022.160.4105.2 370728 14-Nov-2023 19:03 x86
Sqldumper.exe 2022.160.4105.2 436280 14-Nov-2023 19:03 x64
System.identitymodel.tokens.jwt.dll 5.6.0.61018 83872 14-Nov-2023 19:03 x86
Tmapi.dll 2022.160.43.222 5884480 14-Nov-2023 19:01 x64
Tmcachemgr.dll 2022.160.43.222 5575104 14-Nov-2023 19:01 x64
Tmpersistence.dll 2022.160.43.222 1481264 14-Nov-2023 19:01 x64
Tmtransactions.dll 2022.160.43.222 7198256 14-Nov-2023 19:01 x64
Xmsrv.dll 2022.160.43.222 26593856 14-Nov-2023 19:01 x64
Xmsrv.dll 2022.160.43.222 35896256 14-Nov-2023 19:01 x86

SQL Server 2022 Database Services Common Core

File Name File Version File Size Date Time Platform
Instapi150.dll 2022.160.4105.2 104488 14-Nov-2023 19:03 x64
Instapi150.dll 2022.160.4105.2 79912 14-Nov-2023 19:03 x86
Microsoft.analysisservices.adomdclient.dll 16.0.43.222 2633776 14-Nov-2023 19:00 x86
… (duplicate entry) …
Microsoft.analysisservices.core.dll 16.0.43.222 2933296 14-Nov-2023 19:00 x86
Microsoft.analysisservices.xmla.dll 16.0.43.222 2323504 14-Nov-2023 19:00 x86
… (duplicate entry) …
Microsoft.sqlserver.mgdsqldumper.dll 2022.160.4105.2 104392 14-Nov-2023 19:03 x64
Microsoft.sqlserver.mgdsqldumper.dll 2022.160.4105.2 92112 14-Nov-2023 19:03 x86
Microsoft.sqlserver.rmo.dll 16.0.4105.2 554952 14-Nov-2023 19:03 x86
… (duplicate entry) …
Msasxpress.dll 2022.160.43.222 27696 14-Nov-2023 19:00 x86
Msasxpress.dll 2022.160.43.222 32720 14-Nov-2023 19:00 x64
Sql_common_core_keyfile.dll 2022.160.4105.2 137152 14-Nov-2023 19:00 x64
Sqldumper.exe 2022.160.4105.2 370728 14-Nov-2023 19:03 x86
Sqldumper.exe 2022.160.4105.2 436280 14-Nov-2023 19:03 x64
Sqlmgmprovider.dll 2022.160.4105.2 395304 14-Nov-2023 19:03 x86
Sqlmgmprovider.dll 2022.160.4105.2 456640 14-Nov-2023 19:03 x64

SQL Server 2022 Data Quality Client

File Name File Version File Size Date Time Platform
Microsoft.ssdqs.studio.infra.dll 16.0.4105.2 309200 14-Nov-2023 19:03 x86
Microsoft.ssdqs.studio.views.dll 16.0.4105.2 2070568 14-Nov-2023 19:03 x86
Sql_dqc_keyfile.dll 2022.160.4105.2 137152 14-Nov-2023 19:03 x64

SQL Server 2022 Data Quality

File Name File Version File Size Date Time Platform
Microsoft.ssdqs.core.dll 16.0.4105.2 600008 14-Nov-2023 19:03 x86
… (duplicate entry) …
Microsoft.ssdqs.dll 16.0.4105.2 174120 14-Nov-2023 19:03 x86
Microsoft.ssdqs.infra.dll 16.0.4105.2 1857576 14-Nov-2023 19:03 x86
… (duplicate entry) …
Microsoft.ssdqs.proxy.dll 16.0.4105.2 370624 14-Nov-2023 19:03 x86
… (duplicate entry) …

SQL Server 2022 Database Services Core Instance

File Name File Version File Size Date Time Platform
Adal.dll 3.6.1.64359 1618832 14-Nov-2023 20:12 x64
Adalsqlrda.dll 3.6.1.64359 1618832 14-Nov-2023 20:12 x64
Aetm-enclave-simulator.dll 2022.160.4105.2 4719144 14-Nov-2023 19:48 x64
Aetm-enclave.dll 2022.160.4105.2 4673600 14-Nov-2023 19:48 x64
Aetm-sgx-enclave-simulator.dll 2022.160.4105.2 4909128 14-Nov-2023 19:48 x64
Aetm-sgx-enclave.dll 2022.160.4105.2 4874616 14-Nov-2023 19:48 x64
Dcexec.exe 2022.160.4105.2 96312 14-Nov-2023 20:12 x64
Fssres.dll 2022.160.4105.2 100288 14-Nov-2023 20:12 x64
Hadrres.dll 2022.160.4105.2 227264 14-Nov-2023 20:12 x64
Hkcompile.dll 2022.160.4105.2 1411024 14-Nov-2023 20:12 x64
Hkengine.dll 2022.160.4105.2 5769256 14-Nov-2023 20:12 x64
Hkruntime.dll 2022.160.4105.2 190520 14-Nov-2023 20:12 x64
Hktempdb.dll 2022.160.4105.2 71616 14-Nov-2023 20:12 x64
Microsoft.analysisservices.applocal.xmla.dll 16.0.43.222 2322368 14-Nov-2023 20:12 x86
Microsoft.sqlserver.xevent.linq.dll 2022.160.4105.2 333864 14-Nov-2023 20:12 x64
Microsoft.sqlserver.xevent.targets.dll 2022.160.4105.2 96192 14-Nov-2023 20:12 x64
Odsole70.rll 16.0.4105.2 30760 14-Nov-2023 20:12 x64
… (many other Odsole70.rll files) …
Qds.dll 2022.160.4105.2 1800232 14-Nov-2023 20:12 x64
Rsfxft.dll 2022.160.4105.2 55336 14-Nov-2023 20:12 x64
Secforwarder.dll 2022.160.4105.2 84008 14-Nov-2023 20:12 x64
Sql_engine_core_inst_keyfile.dll 2022.160.4105.2 137152 14-Nov-2023 20:12 x64
Sqlaccess.dll 2022.160.4105.2 444352 14-Nov-2023 20:12 x64
Sqlagent.exe 2022.160.4105.2 714688 14-Nov-2023 20:12 x64
Sqlceip.exe 16.0.4105.2 300992 14-Nov-2023 20:12 x86
Sqlctr160.dll 2022.160.4105.2 129064 14-Nov-2023 20:12 x86
Sqlctr160.dll 2022.160.4105.2 157648 14-Nov-2023 20:12 x64
Sqldk.dll 2022.160.4105.2 4011968 14-Nov-2023 20:12 x64
Sqlevn70.rll 2022.160.4105.2 1755176 14-Nov-2023 19:48 x64
… (many other Sqlevn70.rll files) …
Sqliosim.com 2022.160.4105.2 387008 14-Nov-2023 20:12 x64
Sqliosim.exe 2022.160.4105.2 3057704 14-Nov-2023 20:12 x64
Sqllang.dll 2022.160.4105.2 48699328 14-Nov-2023 20:12 x64
Sqlmin.dll 2022.160.4105.2 51193912 14-Nov-2023 20:12 x64
Sqlos.dll 2022.160.4105.2 51144 14-Nov-2023 20:12 x64
Sqlrepss.dll 2022.160.4105.2 137152 14-Nov-2023 20:12 x64
Sqlscriptdowngrade.dll 2022.160.4105.2 51240 14-Nov-2023 20:12 x64
Sqlscriptupgrade.dll 2022.160.4105.2 5830696 14-Nov-2023 20:12 x64
Sqlservr.exe 2022.160.4105.2 882624 14-Nov-2023 20:12 x64
Sqltses.dll 2022.160.4105.2 9386040 14-Nov-2023 20:12 x64
Sqsrvres.dll 2022.160.4105.2 305104 14-Nov-2023 20:12 x64
Svl.dll 2022.160.4105.2 247848 14-Nov-2023 20:12 x64
Xe.dll 2022.160.4105.2 718904 14-Nov-2023 20:12 x64
Xpqueue.dll 2022.160.4105.2 100288 14-Nov-2023 20:12 x64
Xpstar.dll 2022.160.4105.2 534584 14-Nov-2023 20:12 x64

SQL Server 2022 Database Services Core Shared

File Name File Version File Size Date Time Platform
Commanddest.dll 2022.160.4105.2 272336 14-Nov-2023 19:03 x64
Datacollectortasks.dll 2022.160.4105.2 227272 14-Nov-2023 19:04 x64
Distrib.exe 2022.160.4105.2 260032 14-Nov-2023 19:03 x64
Dteparse.dll 2022.160.4105.2 133056 14-Nov-2023 19:03 x64
Dteparsemgd.dll 2022.160.4105.2 178232 14-Nov-2023 19:03 x64
Dtepkg.dll 2022.160.4105.2 153552 14-Nov-2023 19:03 x64
Dtexec.exe 2022.160.4105.2 76736 14-Nov-2023 19:03 x64
Dts.dll 2022.160.4105.2 3266512 14-Nov-2023 19:04 x64
Dtscomexpreval.dll 2022.160.4105.2 493608 14-Nov-2023 19:03 x64
Dtsconn.dll 2022.160.4105.2 550848 14-Nov-2023 19:04 x64
Dtshost.exe 2022.160.4105.2 120256 14-Nov-2023 19:03 x64
Dtspipeline.dll 2022.160.4105.2 1337280 14-Nov-2023 19:03 x64
Dtuparse.dll 2022.160.4105.2 104488 14-Nov-2023 19:03 x64
Dtutil.exe 2022.160.4105.2 166336 14-Nov-2023 19:03 x64
Exceldest.dll 2022.160.4105.2 284624 14-Nov-2023 19:03 x64
Excelsrc.dll 2022.160.4105.2 305088 14-Nov-2023 19:03 x64
Execpackagetask.dll 2022.160.4105.2 182312 14-Nov-2023 19:03 x64
Flatfiledest.dll 2022.160.4105.2 423992 14-Nov-2023 19:03 x64
Flatfilesrc.dll 2022.160.4105.2 440360 14-Nov-2023 19:03 x64
Logread.exe 2022.160.4105.2 788432 14-Nov-2023 19:03 x64
Microsoft.analysisservices.applocal.core.dll 16.0.43.222 2933816 14-Nov-2023 19:03 x86
Microsoft.data.sqlclient.dll 3.15.23292.1 2047112 14-Nov-2023 19:03 x86
Microsoft.data.sqlclient.sni.dll 3.0.1.0 470928 14-Nov-2023 19:03 x64
Microsoft.datatransformationservices.scalehelper.dll 16.0.4105.2 30760 14-Nov-2023 19:03 x86
Microsoft.identity.client.dll 4.36.1.0 1503672 14-Nov-2023 19:03 x86
Microsoft.identitymodel.jsonwebtokens.dll 5.5.0.60624 66096 14-Nov-2023 19:03 x86
Microsoft.identitymodel.logging.dll 5.5.0.60624 32296 14-Nov-2023 19:03 x86
Microsoft.identitymodel.protocols.dll 5.5.0.60624 37416 14-Nov-2023 19:03 x86
Microsoft.identitymodel.protocols.openidconnect.dll 5.5.0.60624 109096 14-Nov-2023 19:03 x86
Microsoft.identitymodel.tokens.dll 5.5.0.60624 167672 14-Nov-2023 19:03 x86
Microsoft.sqlserver.maintenanceplantasks.dll 16.0.4105.2 391224 14-Nov-2023 19:03 x86
Microsoft.sqlserver.replication.dll 2022.160.4105.2 1705920 14-Nov-2023 19:03 x64
Microsoft.sqlserver.rmo.dll 16.0.4105.2 555048 14-Nov-2023 19:03 x86
Msdtssrvrutil.dll 2022.160.4105.2 124984 14-Nov-2023 19:03 x64
Msgprox.dll 2022.160.4105.2 313280 14-Nov-2023 19:03 x64
Msoledbsql.dll 2018.186.7.0 2729960 14-Nov-2023 19:04 x64
Msoledbsql.dll 2018.186.7.0 153560 14-Nov-2023 19:03 x64
Newtonsoft.json.dll 13.0.1.25517 704408 14-Nov-2023 19:04 x86
Oledbdest.dll 2022.160.4105.2 288704 14-Nov-2023 19:03 x64
Oledbsrc.dll 2022.160.4105.2 313384 14-Nov-2023 19:03 x64
Qrdrsvc.exe 2022.160.4105.2 522280 14-Nov-2023 19:03 x64
Rawdest.dll 2022.160.4105.2 227368 14-Nov-2023 19:03 x64
Rawsource.dll 2022.160.4105.2 214992 14-Nov-2023 19:03 x64
Rdistcom.dll 2022.160.4105.2 940072 14-Nov-2023 19:03 x64
Recordsetdest.dll 2022.160.4105.2 206888 14-Nov-2023 19:03 x64
Repldp.dll 2022.160.4105.2 337856 14-Nov-2023 19:03 x64
Replerrx.dll 2022.160.4105.2 198600 14-Nov-2023 19:03 x64
Replisapi.dll 2022.160.4105.2 419776 14-Nov-2023 19:03 x64
Replmerg.exe 2022.160.4105.2 596008 14-Nov-2023 19:03 x64
Replprov.dll 2022.160.4105.2 890936 14-Nov-2023 19:03 x64
Replrec.dll 2022.160.4105.2 1058856 14-Nov-2023 19:03 x64
Replsub.dll 2022.160.4105.2 501696 14-Nov-2023 19:03 x64
Spresolv.dll 2022.160.4105.2 300992 14-Nov-2023 19:03 x64
Sql_engine_core_shared_keyfile.dll 2022.160.4105.2 137152 14-Nov-2023 19:03 x64
Sqlcmd.exe 2022.160.4105.2 276416 14-Nov-2023 19:03 x64
Sqldistx.dll 2022.160.4105.2 268224 14-Nov-2023 19:03 x64
Sqlmergx.dll 2022.160.4105.2 423976 14-Nov-2023 19:03 x64
Sqltaskconnections.dll 2022.160.4105.2 210880 14-Nov-2023 19:04 x64
Ssradd.dll 2022.160.4105.2 100288 14-Nov-2023 19:03 x64
Ssravg.dll 2022.160.4105.2 100288 14-Nov-2023 19:04 x64
Ssrmax.dll 2022.160.4105.2 100304 14-Nov-2023 19:03 x64
Ssrmin.dll 2022.160.4105.2 100288 14-Nov-2023 19:03 x64
Txagg.dll 2022.160.4105.2 395304 14-Nov-2023 19:03 x64
Txbdd.dll 2022.160.4105.2 190504 14-Nov-2023 19:04 x64
Txdatacollector.dll 2022.160.4105.2 468928 14-Nov-2023 19:04 x64
Txdataconvert.dll 2022.160.4105.2 333864 14-Nov-2023 19:04 x64
Txderived.dll 2022.160.4105.2 632872 14-Nov-2023 19:03 x64
Txlookup.dll 2022.160.4105.2 608312 14-Nov-2023 19:03 x64
Txmerge.dll 2022.160.4105.2 243752 14-Nov-2023 19:03 x64
Txmergejoin.dll 2022.160.4105.2 301008 14-Nov-2023 19:03 x64
Txmulticast.dll 2022.160.4105.2 145464 14-Nov-2023 19:03 x64
Txrowcount.dll 2022.160.4105.2 145352 14-Nov-2023 19:03 x64
Txsort.dll 2022.160.4105.2 276432 14-Nov-2023 19:03 x64
Txsplit.dll 2022.160.4105.2 620584 14-Nov-2023 19:03 x64
Txunionall.dll 2022.160.4105.2 194512 14-Nov-2023 19:03 x64
Xe.dll 2022.160.4105.2 718904 14-Nov-2023 19:04 x64

SQL Server 2022 sql_extensibility

File Name File Version File Size Date Time Platform
Commonlauncher.dll 2022.160.4105.2 100392 14-Nov-2023 19:03 x64
Exthost.exe 2022.160.4105.2 247864 14-Nov-2023 19:03 x64
Launchpad.exe 2022.160.4105.2 1447872 14-Nov-2023 19:03 x64
Sql_extensibility_keyfile.dll 2022.160.4105.2 137152 14-Nov-2023 19:00 x64
Sqlsatellite.dll 2022.160.4105.2 1255480 14-Nov-2023 19:03 x64

SQL Server 2022 Full-Text Engine

File Name File Version File Size Date Time Platform
Fd.dll 2022.160.4105.2 710592 14-Nov-2023 19:03 x64
Fdhost.exe 2022.160.4105.2 153640 14-Nov-2023 19:03 x64
Fdlauncher.exe 2022.160.4105.2 100288 14-Nov-2023 19:03 x64
Sql_fulltext_keyfile.dll 2022.160.4105.2 137152 14-Nov-2023 19:00 x64

SQL Server 2022 Integration Services

File Name File Version File Size Date Time Platform
Attunity.sqlserver.cdccontroltask.dll 7.0.0.133 78272 14-Nov-2023 19:09 x86
… (duplicate entries) …
Attunity.sqlserver.cdcsplit.dll 7.0.0.133 39320 14-Nov-2023 19:09 x86
… (duplicate entries) …
Attunity.sqlserver.cdcsrc.dll 7.0.0.133 79808 14-Nov-2023 19:09 x86
… (duplicate entries) …
Commanddest.dll 2022.160.4105.2 231464 14-Nov-2023 19:09 x86
Commanddest.dll 2022.160.4105.2 272336 14-Nov-2023 19:09 x64
Dteparse.dll 2022.160.4105.2 116672 14-Nov-2023 19:09 x86
Dteparse.dll 2022.160.4105.2 133056 14-Nov-2023 19:09 x64
Dteparsemgd.dll 2022.160.4105.2 165928 14-Nov-2023 19:09 x86
Dteparsemgd.dll 2022.160.4105.2 178232 14-Nov-2023 19:09 x64
Dtepkg.dll 2022.160.4105.2 129064 14-Nov-2023 19:09 x86
Dtepkg.dll 2022.160.4105.2 153552 14-Nov-2023 19:09 x64
Dtexec.exe 2022.160.4105.2 64960 14-Nov-2023 19:09 x86
Dtexec.exe 2022.160.4105.2 76736 14-Nov-2023 19:09 x64
Dts.dll 2022.160.4105.2 2861096 14-Nov-2023 19:09 x86
Dts.dll 2022.160.4105.2 3266512 14-Nov-2023 19:10 x64
Dtscomexpreval.dll 2022.160.4105.2 444368 14-Nov-2023 19:09 x86
Dtscomexpreval.dll 2022.160.4105.2 493608 14-Nov-2023 19:09 x64
Dtsconn.dll 2022.160.4105.2 464952 14-Nov-2023 19:09 x86
Dtsconn.dll 2022.160.4105.2 550848 14-Nov-2023 19:10 x64
Dtsdebughost.exe 2022.160.4105.2 114624 14-Nov-2023 19:09 x64
Dtsdebughost.exe 2022.160.4105.2 94760 14-Nov-2023 19:09 x86
Dtshost.exe 2022.160.4105.2 98256 14-Nov-2023 19:09 x86
Dtshost.exe 2022.160.4105.2 120256 14-Nov-2023 19:09 x64
Dtspipeline.dll 2022.160.4105.2 1144768 14-Nov-2023 19:09 x86
Dtspipeline.dll 2022.160.4105.2 1337280 14-Nov-2023 19:10 x64
Dtuparse.dll 2022.160.4105.2 88016 14-Nov-2023 19:09 x86
Dtuparse.dll 2022.160.4105.2 104488 14-Nov-2023 19:09 x64
Dtutil.exe 2022.160.4105.2 142392 14-Nov-2023 19:09 x86
Dtutil.exe 2022.160.4105.2 166336 14-Nov-2023 19:09 x64
Exceldest.dll 2022.160.4105.2 247848 14-Nov-2023 19:09 x86
Exceldest.dll 2022.160.4105.2 284624 14-Nov-2023 19:09 x64
Excelsrc.dll 2022.160.4105.2 264232 14-Nov-2023 19:09 x86
Excelsrc.dll 2022.160.4105.2 305088 14-Nov-2023 19:09 x64
Execpackagetask.dll 2022.160.4105.2 149544 14-Nov-2023 19:09 x86
Execpackagetask.dll 2022.160.4105.2 182312 14-Nov-2023 19:09 x64
Flatfiledest.dll 2022.160.4105.2 374720 14-Nov-2023 19:09 x86
Flatfiledest.dll 2022.160.4105.2 423992 14-Nov-2023 19:09 x64
Flatfilesrc.dll 2022.160.4105.2 391104 14-Nov-2023 19:09 x86
Flatfilesrc.dll 2022.160.4105.2 440360 14-Nov-2023 19:09 x64
Isdbupgradewizard.exe 16.0.4105.2 120776 14-Nov-2023 19:09 x86
… (duplicate entry) …
Microsoft.analysisservices.applocal.core.dll 16.0.43.222 2933816 14-Nov-2023 19:01 x86
… (duplicate entry) …
Microsoft.sqlserver.integrationservices.isserverdbupgrade.dll 16.0.4105.2 509888 14-Nov-2023 19:09 x86
… (duplicate entry) …
Microsoft.sqlserver.maintenanceplantasks.dll 16.0.4105.2 391224 14-Nov-2023 19:09 x86
Msdtssrvr.exe 16.0.4105.2 219176 14-Nov-2023 19:09 x64
Msdtssrvrutil.dll 2022.160.4105.2 100288 14-Nov-2023 19:09 x86
Msdtssrvrutil.dll 2022.160.4105.2 124984 14-Nov-2023 19:09 x64
Msmdpp.dll 2022.160.43.222 10165808 14-Nov-2023 19:01 x64
Newtonsoft.json.dll 13.0.1.25517 704408 14-Nov-2023 19:09 x86
… (multiple duplicate entries) …
Odbcdest.dll 2022.160.4105.2 342056 14-Nov-2023 19:09 x86
Odbcdest.dll 2022.160.4105.2 383016 14-Nov-2023 19:09 x64
Odbcsrc.dll 2022.160.4105.2 350248 14-Nov-2023 19:09 x86
Odbcsrc.dll 2022.160.4105.2 399400 14-Nov-2023 19:09 x64
Oledbdest.dll 2022.160.4105.2 247848 14-Nov-2023 19:09 x86
Oledbdest.dll 2022.160.4105.2 288704 14-Nov-2023 19:09 x64
Oledbsrc.dll 2022.160.4105.2 268328 14-Nov-2023 19:09 x86
Oledbsrc.dll 2022.160.4105.2 313384 14-Nov-2023 19:09 x64
Rawdest.dll 2022.160.4105.2 190520 14-Nov-2023 19:09 x86
Rawdest.dll 2022.160.4105.2 227368 14-Nov-2023 19:09 x64
Rawsource.dll 2022.160.4105.2 186424 14-Nov-2023 19:09 x86
Rawsource.dll 2022.160.4105.2 214992 14-Nov-2023 19:09 x64
Recordsetdest.dll 2022.160.4105.2 174120 14-Nov-2023 19:09 x86
Recordsetdest.dll 2022.160.4105.2 206888 14-Nov-2023 19:09 x64
Sql_is_keyfile.dll 2022.160.4105.2 137152 14-Nov-2023 19:01 x64
Sqlceip.exe 16.0.4105.2 300992 14-Nov-2023 19:10 x86
Sqldest.dll 2022.160.4105.2 256040 14-Nov-2023 19:09 x86
Sqldest.dll 2022.160.4105.2 288704 14-Nov-2023 19:10 x64
Sqltaskconnections.dll 2022.160.4105.2 174032 14-Nov-2023 19:09 x86
Sqltaskconnections.dll 2022.160.4105.2 210880 14-Nov-2023 19:10 x64
Txagg.dll 2022.160.4105.2 346152 14-Nov-2023 19:09 x86
Txagg.dll 2022.160.4105.2 395304 14-Nov-2023 19:10 x64
Txbdd.dll 2022.160.4105.2 149560 14-Nov-2023 19:09 x86
Txbdd.dll 2022.160.4105.2 190504 14-Nov-2023 19:10 x64
Txbestmatch.dll 2022.160.4105.2 567336 14-Nov-2023 19:09 x86
Txbestmatch.dll 2022.160.4105.2 661440 14-Nov-2023 19:10 x64
Txcache.dll 2022.160.4105.2 169920 14-Nov-2023 19:09 x86
Txcache.dll 2022.160.4105.2 202688 14-Nov-2023 19:10 x64
Txcharmap.dll 2022.160.4105.2 280512 14-Nov-2023 19:09 x86
Txcharmap.dll 2022.160.4105.2 325672 14-Nov-2023 19:10 x64
Txcopymap.dll 2022.160.4105.2 165824 14-Nov-2023 19:09 x86
Txcopymap.dll 2022.160.4105.2 202688 14-Nov-2023 19:10 x64
Txdataconvert.dll 2022.160.4105.2 288824 14-Nov-2023 19:09 x86
Txdataconvert.dll 2022.160.4105.2 333864 14-Nov-2023 19:10 x64
Txderived.dll 2022.160.4105.2 559144 14-Nov-2023 19:09 x86
Txderived.dll 2022.160.4105.2 632872 14-Nov-2023 19:10 x64
Txfileextractor.dll 2022.160.4105.2 186408 14-Nov-2023 19:09 x86
Txfileextractor.dll 2022.160.4105.2 219176 14-Nov-2023 19:10 x64
Txfileinserter.dll 2022.160.4105.2 186424 14-Nov-2023 19:09 x86
Txfileinserter.dll 2022.160.4105.2 219176 14-Nov-2023 19:10 x64
Txgroupdups.dll 2022.160.4105.2 354344 14-Nov-2023 19:09 x86
Txgroupdups.dll 2022.160.4105.2 403496 14-Nov-2023 19:10 x64
Txlineage.dll 2022.160.4105.2 128960 14-Nov-2023 19:09 x86
Txlineage.dll 2022.160.4105.2 157632 14-Nov-2023 19:10 x64
Txlookup.dll 2022.160.4105.2 522296 14-Nov-2023 19:09 x86
Txlookup.dll 2022.160.4105.2 608312 14-Nov-2023 19:10 x64
Txmerge.dll 2022.160.4105.2 194600 14-Nov-2023 19:09 x86
Txmerge.dll 2022.160.4105.2 243752 14-Nov-2023 19:10 x64
Txmergejoin.dll 2022.160.4105.2 256040 14-Nov-2023 19:09 x86
Txmergejoin.dll 2022.160.4105.2 301008 14-Nov-2023 19:10 x64
Txmulticast.dll 2022.160.4105.2 116680 14-Nov-2023 19:09 x86
Txmulticast.dll 2022.160.4105.2 145464 14-Nov-2023 19:10 x64
Txpivot.dll 2022.160.4105.2 198696 14-Nov-2023 19:09 x86
Txpivot.dll 2022.160.4105.2 239656 14-Nov-2023 19:10 x64
Txrowcount.dll 2022.160.4105.2 116672 14-Nov-2023 19:09 x86
Txrowcount.dll 2022.160.4105.2 145352 14-Nov-2023 19:10 x64
Txsampling.dll 2022.160.4105.2 153536 14-Nov-2023 19:09 x86
Txsampling.dll 2022.160.4105.2 186408 14-Nov-2023 19:10 x64
Txscd.dll 2022.160.4105.2 198696 14-Nov-2023 19:09 x86
Txscd.dll 2022.160.4105.2 235560 14-Nov-2023 19:10 x64
Txsort.dll 2022.160.4105.2 231360 14-Nov-2023 19:09 x86
Txsort.dll 2022.160.4105.2 276432 14-Nov-2023 19:10 x64
Txsplit.dll 2022.160.4105.2 550952 14-Nov-2023 19:09 x86
Txsplit.dll 2022.160.4105.2 620584 14-Nov-2023 19:10 x64
Txtermextraction.dll 2022.160.4105.2 8648744 14-Nov-2023 19:09 x86
Txtermextraction.dll 2022.160.4105.2 8702008 14-Nov-2023 19:10 x64
Txtermlookup.dll 2022.160.4105.2 4138944 14-Nov-2023 19:09 x86
Txtermlookup.dll 2022.160.4105.2 4184120 14-Nov-2023 19:10 x64
Txunionall.dll 2022.160.4105.2 153640 14-Nov-2023 19:09 x86
Txunionall.dll 2022.160.4105.2 194512 14-Nov-2023 19:10 x64
Txunpivot.dll 2022.160.4105.2 178216 14-Nov-2023 19:09 x86
Txunpivot.dll 2022.160.4105.2 214992 14-Nov-2023 19:10 x64
Xe.dll 2022.160.4105.2 640960 14-Nov-2023 19:09 x86
Xe.dll 2022.160.4105.2 718904 14-Nov-2023 19:10 x64

SQL Server 2022 sql_polybase_core_inst

File Name File Version File Size Date Time Platform
Dms.dll 16.0.1032.0 559672 14-Nov-2023 20:13 x86
Dmsnative.dll 2022.160.1032.0 152632 14-Nov-2023 20:13 x64
Dwengineservice.dll 16.0.1032.0 45120 14-Nov-2023 20:13 x86
Instapi150.dll 2022.160.4105.2 104488 14-Nov-2023 20:13 x64
Microsoft.sqlserver.datawarehouse.backup.backupmetadata.dll 16.0.1032.0 67640 14-Nov-2023 20:13 x86
Microsoft.sqlserver.datawarehouse.catalog.dll 16.0.1032.0 293432 14-Nov-2023 20:13 x86
Microsoft.sqlserver.datawarehouse.common.dll 16.0.1032.0 1958464 14-Nov-2023 20:13 x86
Microsoft.sqlserver.datawarehouse.configuration.dll 16.0.1032.0 169528 14-Nov-2023 20:13 x86
Microsoft.sqlserver.datawarehouse.datamovement.common.dll 16.0.1032.0 647232 14-Nov-2023 20:13 x86
Microsoft.sqlserver.datawarehouse.datamovement.manager.dll 16.0.1032.0 246328 14-Nov-2023 20:13 x86
Microsoft.sqlserver.datawarehouse.datamovement.messagetypes.dll 16.0.1032.0 139320 14-Nov-2023 20:13 x86
Microsoft.sqlserver.datawarehouse.datamovement.messagingprotocol.dll 16.0.1032.0 79928 14-Nov-2023 20:13 x86
Microsoft.sqlserver.datawarehouse.diagnostics.dll 16.0.1032.0 51256 14-Nov-2023 20:13 x86
Microsoft.sqlserver.datawarehouse.distributor.dll 16.0.1032.0 88624 14-Nov-2023 20:13 x86
Microsoft.sqlserver.datawarehouse.engine.dll 16.0.1032.0 1129528 14-Nov-2023 20:13 x86
Microsoft.sqlserver.datawarehouse.engine.statsstream.dll 16.0.1032.0 80952 14-Nov-2023 20:13 x86
Microsoft.sqlserver.datawarehouse.eventing.dll 16.0.1032.0 70712 14-Nov-2023 20:13 x86
Microsoft.sqlserver.datawarehouse.fabric.appliance.dll 16.0.1032.0 35384 14-Nov-2023 20:13 x86
Microsoft.sqlserver.datawarehouse.fabric.interface.dll 16.0.1032.0 30784 14-Nov-2023 20:13 x86
Microsoft.sqlserver.datawarehouse.fabric.polybase.dll 16.0.1032.0 46648 14-Nov-2023 20:13 x86
Microsoft.sqlserver.datawarehouse.fabric.xdbinterface.dll 16.0.1032.0 21552 14-Nov-2023 20:13 x86
Microsoft.sqlserver.datawarehouse.failover.dll 16.0.1032.0 26680 14-Nov-2023 20:13 x86
Microsoft.sqlserver.datawarehouse.hadoop.hadoopbridge.dll 16.0.1032.0 131648 14-Nov-2023 20:13 x86
Microsoft.sqlserver.datawarehouse.loadercommon.dll 16.0.1032.0 86584 14-Nov-2023 20:13 x86
Microsoft.sqlserver.datawarehouse.loadmanager.dll 16.0.1032.0 100928 14-Nov-2023 20:13 x86
Microsoft.sqlserver.datawarehouse.localization.dll 16.0.1032.0 293432 14-Nov-2023 20:13 x86
Microsoft.sqlserver.datawarehouse.localization.resources.dll 16.0.1032.0 120384 14-Nov-2023 20:13 x86
… (many other localization.resources.dll files) …
Microsoft.sqlserver.datawarehouse.nodes.dll 16.0.1032.0 72760 14-Nov-2023 20:13 x86
Microsoft.sqlserver.datawarehouse.nulltransaction.dll 16.0.1032.0 22072 14-Nov-2023 20:13 x86
Microsoft.sqlserver.datawarehouse.parallelizer.dll 16.0.1032.0 37432 14-Nov-2023 20:13 x86
Microsoft.sqlserver.datawarehouse.resourcemanagement.dll 16.0.1032.0 129088 14-Nov-2023 20:13 x86
Microsoft.sqlserver.datawarehouse.sql.dll 16.0.1032.0 3064896 14-Nov-2023 20:13 x86
Microsoft.sqlserver.datawarehouse.sql.parser.dll 16.0.1032.0 3955768 14-Nov-2023 20:13 x86
Microsoft.sqlserver.datawarehouse.sql.parser.resources.dll 16.0.1032.0 118336 14-Nov-2023 20:13 x86
… (many other parser.resources.dll files) …
Microsoft.sqlserver.datawarehouse.sqldistributor.dll 16.0.1032.0 67640 14-Nov-2023 20:13 x86
Microsoft.sqlserver.datawarehouse.transactsql.scriptdom.dll 16.0.1032.0 2682936 14-Nov-2023 20:13 x86
Microsoft.sqlserver.datawarehouse.utilities.dll 16.0.1032.0 2436664 14-Nov-2023 20:13 x86
Mpdwinterop.dll 2022.160.4105.2 296896 14-Nov-2023 20:13 x64
Mpdwsvc.exe 2022.160.4105.2 7796688 14-Nov-2023 20:13 x64
Secforwarder.dll 2022.160.4105.2 84008 14-Nov-2023 20:13 x64
Sharedmemory.dll 2022.160.1032.0 61488 14-Nov-2023 20:13 x64
Sqldk.dll 2022.160.4105.2 4011968 14-Nov-2023 20:13 x64
Sqldumper.exe 2022.160.4105.2 436280 14-Nov-2023 20:13 x64
Sqlevn70.rll 2022.160.4105.2 1755176 14-Nov-2023 20:13 x64
… (many other Sqlevn70.rll files) …
Sqlncli17e.dll 2017.1710.5.1 1902528 14-Nov-2023 20:13 x64
Sqlos.dll 2022.160.4105.2 51144 14-Nov-2023 20:13 x64
Sqlsortpdw.dll 2022.160.1032.0 4841536 14-Nov-2023 20:13 x64
Sqltses.dll 2022.160.4105.2 9386040 14-Nov-2023 20:13 x64

These tables provide a snapshot of the numerous files across various components that are updated as part of Cumulative Update 11. The specific list installed will depend on the features enabled on your SQL Server instance.

Important Considerations for Applying Cumulative Updates

Before applying Cumulative Update 11, please be aware of the following prerequisites and general guidelines:

Prerequisites

To successfully apply this cumulative update package, your server must be running a supported version of SQL Server 2022. Attempting to apply the update to an older version or a different product might result in installation errors.

Restart Information

Applying this cumulative update package will likely require a restart of the SQL Server services. In some cases, a full computer restart might be necessary for all updates to take effect completely. It is recommended to plan for this downtime and perform the installation during a scheduled maintenance window.

Registry Information

Applying this specific cumulative update package does not require any manual modifications to the Windows registry. The installation process handles all necessary registry changes automatically.

General CU Information and Recommendations

Beginning with SQL Server 2017, the version numbers for Analysis Services and the SQL Server Database Engine may not always align. This is by design, and you should refer to the official documentation to verify the correct build version for each component after applying updates.

It is important to understand that each new cumulative update for SQL Server is cumulative, meaning it contains all the fixes that were included in previous CUs for the same version. This simplifies the patching process as you only need to install the latest available CU to get all recent fixes. SQL Server CUs undergo rigorous testing and are certified to the same quality level as service packs. Therefore, they should be installed with a similar level of confidence. Microsoft strongly recommends a proactive approach to installing cumulative updates as they become available. Historical data consistently shows that a significant portion of support cases could be resolved by applying an already released CU. Beyond just bug fixes, CUs often include valuable updates related to supportability, manageability, and reliability, further improving the overall SQL Server experience. It is always a best practice to test cumulative updates in a non-production environment that closely mirrors your production setup before deploying them widely.

Hybrid Environment Deployment

Deploying updates in hybrid SQL Server environments, such as those utilizing Always On Availability Groups, Replication, Failover Cluster Instances, or Database Mirroring, requires careful planning to minimize downtime and potential data loss. Microsoft provides specific guidance for updating each of these configurations:

  • Failover Cluster Instances: Refer to the documentation on upgrading a SQL Server failover cluster instance. If a rolling update method isn’t used, the update should be installed on passive nodes first, followed by active nodes (which requires a service restart).
  • Always On Availability Groups: Consult the documentation on upgrading and updating availability group servers with minimal downtime. Special considerations apply if the SSISDB catalog is enabled with Always On; refer to the specific guidance for SSIS with Always On deployments.
  • Transactional Replication and Database Mirroring: Guidance is available on applying hotfixes in environments configured with transactional replication and database mirroring.
  • Replication Topology: Specific steps are provided for applying hotfixes within a general SQL Server replication topology.
  • Database Mirroring: Information on upgrading mirrored instances is available in the documentation.

Understanding and following these environment-specific guidelines is crucial for a smooth and successful update process in complex SQL Server deployments.

Component Updates

A single cumulative update package for SQL Server 2022 contains updates for all components (features) available for that version. However, the installation process is intelligent; it only updates the components that are currently installed on the specific SQL Server instance being patched. If you install CU11 and later decide to add another SQL Server feature (like Analysis Services or Integration Services) to that instance, you must reapply the CU11 package after adding the new feature to ensure the newly installed component is also updated to the CU11 build level.

Uninstalling the Update

If necessary, Cumulative Update 11 can be uninstalled from your SQL Server 2022 instance.

Uninstalling on Windows

  1. Open the Control Panel on your Windows server.
  2. Navigate to Programs > Programs and Features.
  3. In the left-hand pane, select View installed updates.
  4. Locate the entry corresponding to this cumulative update package, usually listed under SQL Server 2022 and identified by its Knowledge Base number (KB5032679).
  5. Right-click (or press and hold) the update entry and select Uninstall. Follow the on-screen prompts to complete the removal.

Uninstalling on Linux

To uninstall this cumulative update on a Linux installation of SQL Server, you will need to use your distribution’s package manager to roll back the SQL Server package to the previous version. The specific command varies depending on your distribution (e.g., sudo apt install mssql-server=previous-version-number on Ubuntu, sudo yum downgrade mssql-server on RHEL/CentOS, or sudo zypper install --oldpackage mssql-server=previous-version-number on SLES). Refer to the official SQL Server on Linux documentation for detailed instructions on rolling back an installation.

Staying current with cumulative updates is a key part of maintaining the health and performance of your SQL Server environment. CU11 for SQL Server 2022 provides valuable fixes across various components, contributing to a more robust database platform.

Have you applied Cumulative Update 11 to your SQL Server 2022 instances? What improvements or changes have you observed? Share your experiences and insights in the comments below!

Post a Comment