SQL Server 2016 articles, fixes and updates - Year 2022

This list contains all of the known Microsoft Knowledge Base articles, howtos, fixes, hotfixes, webcasts and updates of Microsoft SQL Server 2016 that have been released in Year 2022. The list is daily updated.

• 3194923 FIX: Error 976 occurs when you run DBCC CHECKDB on an unreadable secondary replica of SQL Server 2016 Availability Group Q3194923 KB3194923 November 11, 2022
• 4475776 Cumulative Update 5 for SQL Server 2016 SP2 Q4475776 KB4475776 October 18, 2022
• 4464106 Cumulative Update 4 for SQL Server 2016 SP2 Q4464106 KB4464106 October 18, 2022
• 4458871 Cumulative Update 3 for SQL Server 2016 SP2 Q4458871 KB4458871 October 18, 2022
• 4341569 Cumulative Update 10 for SQL Server 2016 SP1 Q4341569 KB4341569 October 18, 2022
• 4340355 Cumulative Update 2 for SQL Server 2016 SP2 Q4340355 KB4340355 October 18, 2022
• 4338960 FIX: "PAGE_FAULT_IN_NONPAGED_AREA" Stop error when enumerating contents in a SQL Server FileTable directory Q4338960 KB4338960 October 18, 2022
• 4135048 Cumulative Update 1 for SQL Server 2016 SP2 Q4135048 KB4135048 October 18, 2022
• 4100997 Cumulative Update 9 for SQL Server 2016 SP1 Q4100997 KB4100997 October 18, 2022
• 4077064 Cumulative Update 8 for SQL Server 2016 SP1 Q4077064 KB4077064 October 18, 2022
• 4052908 SQL Server 2016 Service Pack 2 release information Q4052908 KB4052908 October 18, 2022
• 4040713 Cumulative Update 8 for SQL Server 2016 Q4040713 KB4040713 October 18, 2022
• 3198751 FIX: Out-of-memory error when you run a query to access LOB columns through In-Memory OLTP in SQL Server 2016 Q3198751 KB3198751 October 18, 2022
• 3157016 FIX: RDL report that's generated programmatically fails to run in SSRS Q3157016 KB3157016 October 18, 2022
• 4458593 Update adds lightweight query profiling hint in SQL Server 2016 and 2017 Q4458593 KB4458593 September 22, 2022
• 4092554 FIX: Errors 627 or 12324 occur when cross database transactions are promoted to distributed transactions in SQL Server Availability Group Q4092554 KB4092554 September 22, 2022
• 3191296 Update extends the Trace extended event with security protocol handshake information in SQL Server Q3191296 KB3191296 September 22, 2022
• 4549825 Cumulative Update 13 for SQL Server 2016 SP2 Q4549825 KB4549825 August 16, 2022
• 4459676 Cumulative Update 11 for SQL Server 2016 SP1 Q4459676 KB4459676 August 16, 2022
• 4037354 Cumulative Update 6 for SQL Server 2016 SP1 Q4037354 KB4037354 August 16, 2022
• 4024305 Cumulative Update 4 for SQL Server 2016 SP1 Q4024305 KB4024305 August 16, 2022
• 4013105 Cumulative Update 5 for SQL Server 2016 Q4013105 KB4013105 August 16, 2022
• 4052133 FIX: Access violation when SQL Server 2016 tries to start Query Store Manager during startup Q4052133 KB4052133 August 2, 2022
• 4463320 FIX: Intermittent failures when you back up to Azure storage from SQL Server 2014, 2016 and 2017 Q4463320 KB4463320 June 21, 2022
• 4340837 FIX: Error 3906 when a hotfix is applied on a server that has a SQL Server database snapshot on a pull subscription database Q4340837 KB4340837 June 21, 2022
• 4340730 FIX: Assertion error occurs when a query that uses a linked server is cancelled in SQL Server 2016 and 2017 Q4340730 KB4340730 June 21, 2022
• 4135113 FIX: Change tracking record is inconsistent during an update on a table that has a clustered or unique index in SQL Server Q4135113 KB4135113 June 21, 2022
• 4074862 FIX: Unexpected error when you create a subcube in SQL Server 2016 and 2017 Analysis Services (Multidimensional model) Q4074862 KB4074862 June 21, 2022
• 4057280 FIX: High CPU use when large index is used in a query on a memory-optimized table in SQL Server Q4057280 KB4057280 June 21, 2022
• 4042948 FIX: Data-driven subscription fails after you upgrade from SSRS 2008 to SSRS 2016 Q4042948 KB4042948 June 21, 2022
• 5015371 Description of the security update for SQL Server 2016 SP3 Azure Connect Feature Pack: June 14, 2022 Q5015371 KB5015371 June 14, 2022
• 5014365 Description of the security update for SQL Server 2016 SP2 GDR: June 14, 2022 Q5014365 KB5014365 June 14, 2022
• 5014355 Description of the security update for SQL Server 2016 SP3 GDR: June 14, 2022 Q5014355 KB5014355 June 14, 2022
• 5014351 Description of the security update for SQL Server 2016 SP2 CU17: June 14, 2022 Q5014351 KB5014351 June 14, 2022
• 4561305 FIX: Concurrent inserts against tables with columnstore indexes may cause queries to stop responding in SQL Server Q4561305 KB4561305 June 2, 2022
• 4536005 FIX: Fix incorrect memory page accounting that causes out-of-memory errors in SQL Server Q4536005 KB4536005 June 2, 2022
• 4529876 FIX: Memory may not get released when you process partitions with data in SQL Server Q4529876 KB4529876 June 2, 2022
• 4521599 FIX: Non-yielding scheduler condition occurs if large number of row-column values are processed in row groups in SQL Server 2016 or 2017 Q4521599 KB4521599 June 2, 2022
• 4512567 FIX: "Non-yielding Scheduler" occurs when you run queries with batch-mode hash join and/or sort in SQL Server 2016 and 2017 Q4512567 KB4512567 June 2, 2022
• 4512151 FIX: Access Violation occurs when you use LOG function with a remote query in SQL Server 2016 and 2017 Q4512151 KB4512151 June 2, 2022
• 4512016 FIX: Syscommittab cleanup causes a lock escalation that will block the syscommittab flush in SQL Server 2014, 2016 and 2017 Q4512016 KB4512016 June 2, 2022
• 4506912 FIX: Concurrent inserts into a CCI can cause deadlock under memory pressure in SQL Server 2016 and 2017 Q4506912 KB4506912 June 2, 2022
• 4502428 FIX: Assertion error occurs when you run a query to access sys.dm_db_xtp_checkpoint_files in SQL Server 2016 and 2017 Q4502428 KB4502428 June 2, 2022
• 4497928 FIX: Indirect checkpoints on tempdb database cause "Non-yielding scheduler" error in SQL Server 2016 and 2017 Q4497928 KB4497928 June 2, 2022
• 4497222 FIX: Database may crash when multiple threads update permissions on the same database in SQL Server 2016 and 2017 Q4497222 KB4497222 June 2, 2022
• 4494805 FIX: Adding new Publication may fail if distribution database is in AG and collation is set to BIN in SQL Server 2016 and 2017 Q4494805 KB4494805 June 2, 2022
• 4494225 FIX: Access violation occurs when you run a query against sys.availability_replicas in SQL Server 2016 and 2017 Q4494225 KB4494225 June 2, 2022
• 4491560 FIX: Access violation occurs when you query sys.dm_hadr_availability_replica_states in SQL Server 2016 and 2017 Q4491560 KB4491560 June 2, 2022
• 4490140 FIX: Stack Dump occurs in the change tracking cleanup process in SQL Server 2014, 2016 and 2017 Q4490140 KB4490140 June 2, 2022
• 4490138 FIX: Filtered NCI over a CCI may not be maintained when the table is updated in a way that none of the key or included columns of the NCI are changed in SQL Server 2016 and 2017 Q4490138 KB4490138 June 2, 2022
• 4486931 FIX: Upgrade to SQL Server 2016 SP2 CU3 or CU4 fails with an error when sysadmin account "sa" is renamed in SQL Server 2016 and 2017 Q4486931 KB4486931 June 2, 2022
• 4483593 Snapshot Isolation and Savepoint support added for Availability Group databases on the same instance with DTC enabled in SQL Server Q4483593 KB4483593 June 2, 2022
• 4480652 FIX: SQL Writer Service can cause undetected deadlocks on system DMV when you do a VSS backup Q4480652 KB4480652 June 2, 2022
• 4470057 FIX: Error 41168 occurs when you try to alter DAG SEEDING_MODE in SQL Server 2016 and 2017 Q4470057 KB4470057 June 2, 2022
• 4469600 FIX: Peer-to-peer replication fails in SQL Server 2016 and 2017 if the host name is not uppercase Q4469600 KB4469600 June 2, 2022
• 4338773 FIX: Deadlock errors when you run an SSIS package in parallel in SQL Server Q4338773 KB4338773 June 2, 2022
• 3195888 FIX: High CPU usage causes performance issues in SQL Server 2016 and 2017 Q3195888 KB3195888 June 2, 2022
• 5014242 Azure connect feature pack for SQL Server 2016 Service Pack 3 Q5014242 KB5014242 May 23, 2022
• 4563115 FIX: Upgrade script fails if you use an Always On high availability group as a secondary replica in SQL Server Q4563115 KB4563115 March 22, 2022