SQL Server 2017 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 2017 that have been released in Year 2022. The list is daily updated.

• 5018050 Improvement: Add new Azure SQL Database service tier options to the Stretch Database feature Q5018050 KB5018050 September 29, 2022
• 5016884 Cumulative Update 31 for SQL Server 2017 Q5016884 KB5016884 September 29, 2022
• 5013756 Cumulative Update 30 for SQL Server 2017 Q5013756 KB5013756 September 29, 2022
• 5017551 FIX: Installing SQL Server CUs may trigger IndexOutOfRangeException Q5017551 KB5017551 September 28, 2022
• 4458593 Update adds lightweight query profiling hint in SQL Server 2016 and 2017 Q4458593 KB4458593 September 22, 2022
• 4340742 FIX: Access to SSAS by using HTTP fails in SQL Server Q4340742 KB4340742 September 22, 2022
• 4135137 FIX: SSMS and SSDT do not escape double quotation marks when you export data as CSV Q4135137 KB4135137 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
• 5018231 FIX: Error 20598 after adding columns that have default constraints as part of the primary key for an existing table and configuring transactional replication Q5018231 KB5018231 September 20, 2022
• 5017788 FIX: ParameterRuntimeValue is missing from the Showplan XML when you use the DMV sys.dm_exec_query_statistics_xml Q5017788 KB5017788 September 20, 2022
• 5008184 FIX: ForceLastGoodPlan doesn't account for aborted and timed out queries in regression detection logic Q5008184 KB5008184 September 20, 2022
• 4047329 SQL Server 2017 build versions Q4047329 KB4047329 September 20, 2022
• 5010786 Cumulative Update 29 for SQL Server 2017 Q5010786 KB5010786 September 13, 2022
• 4577467 Cumulative Update 22 for SQL Server 2017 Q4577467 KB4577467 September 2, 2022
• 5008084 Cumulative Update 28 for SQL Server 2017 Q5008084 KB5008084 August 17, 2022
• 5006944 Cumulative Update 27 for SQL Server 2017 Q5006944 KB5006944 August 17, 2022
• 5005226 Cumulative Update 26 for SQL Server 2017 Q5005226 KB5005226 August 17, 2022
• 5003830 Cumulative Update 25 for SQL Server 2017 Q5003830 KB5003830 August 17, 2022
• 5001228 Cumulative Update 24 for SQL Server 2017 Q5001228 KB5001228 August 17, 2022
• 5000685 Cumulative Update 23 for SQL Server 2017 Q5000685 KB5000685 August 17, 2022
• 4557397 Cumulative Update 21 for SQL Server 2017 Q4557397 KB4557397 August 17, 2022
• 4541283 Cumulative Update 20 for SQL Server 2017 Q4541283 KB4541283 August 17, 2022
• 4535007 Cumulative Update 19 for SQL Server 2017 Q4535007 KB4535007 August 17, 2022
• 4527377 Cumulative Update 18 for SQL Server 2017 Q4527377 KB4527377 August 17, 2022
• 4515579 Cumulative Update 17 for SQL Server 2017 Q4515579 KB4515579 August 17, 2022
• 4508218 Cumulative Update 16 for SQL Server 2017 Q4508218 KB4508218 August 17, 2022
• 4498951 Cumulative Update 15 for SQL Server 2017 Q4498951 KB4498951 August 17, 2022
• 4484710 Cumulative Update 14 for SQL Server 2017 Q4484710 KB4484710 August 17, 2022
• 4466404 Cumulative Update 13 for SQL Server 2017 Q4466404 KB4466404 August 17, 2022
• 4464082 Cumulative Update 12 for SQL Server 2017 Q4464082 KB4464082 August 17, 2022
• 4462262 Cumulative Update 11 for SQL Server 2017 Q4462262 KB4462262 August 17, 2022
• 4342123 Cumulative Update 10 for SQL Server 2017 Q4342123 KB4342123 August 17, 2022
• 4341265 Cumulative Update 9 for SQL Server 2017 Q4341265 KB4341265 August 17, 2022
• 4338363 Cumulative Update 8 for SQL Server 2017 Q4338363 KB4338363 August 17, 2022
• 4229789 Cumulative Update 7 for SQL Server 2017 Q4229789 KB4229789 August 17, 2022
• 4101464 Cumulative Update 6 for SQL Server 2017 Q4101464 KB4101464 August 17, 2022
• 4092643 Cumulative Update 5 for SQL Server 2017 Q4092643 KB4092643 August 17, 2022
• 4056498 Cumulative Update 4 for SQL Server 2017 Q4056498 KB4056498 August 17, 2022
• 4052987 Cumulative Update 3 for SQL Server 2017 Q4052987 KB4052987 August 17, 2022
• 4052574 Cumulative Update 2 for SQL Server 2017 Q4052574 KB4052574 August 17, 2022
• 4038634 Cumulative Update 1 for SQL Server 2017 Q4038634 KB4038634 August 17, 2022
• 5013181 FIX: A subscription is still active after the distribution retention period expires Q5013181 KB5013181 August 11, 2022
• 4052133 FIX: Access violation when SQL Server 2016 tries to start Query Store Manager during startup Q4052133 KB4052133 August 2, 2022
• 5014047 Improvement: Match the lock escalation policy for the change tracking table to that of the base table Q5014047 KB5014047 July 13, 2022
• 4470811 FIX: Log message displays “N/A” when using ring buffer target to hold extended event data in memory in SQL Server Q4470811 KB4470811 June 21, 2022
• 4463320 FIX: Intermittent failures when you back up to Azure storage from SQL Server 2014, 2016 and 2017 Q4463320 KB4463320 June 21, 2022
• 4460203 FIX: Pacemaker may kill the resource agent processes when operation times out in SQL Server 2017 AlwaysOn Availability Group Q4460203 KB4460203 June 21, 2022
• 4459576 Update makes you set order for processing of business rules for Master Data Services database in SQL Server Q4459576 KB4459576 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
• 4340134 FIX: Error when a role that is defined with a restricted column is used to run a drillthrough query in SSAS Q4340134 KB4340134 June 21, 2022
• 4339875 Improvements for Always On Availability Groups on a Pacemaker cluster in SQL Server Q4339875 KB4339875 June 21, 2022
• 4338960 FIX: "PAGE_FAULT_IN_NONPAGED_AREA" Stop error when enumerating contents in a SQL Server FileTable directory Q4338960 KB4338960 June 21, 2022
• 4338296 FIX: Memory leak after dropping an LOB or off-row column from a memory-optimized table in SQL Server on Linux Q4338296 KB4338296 June 21, 2022
• 4295233 FIX: Database recovery could stop responding if it contains in-memory objects and a recovery failure is encountered during a race condition in SQL Server 2017 Q4295233 KB4295233 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
• 4092997 FIX: VC++ 2015 Redistributable installation returns error 1638 when newer version already installed Q4092997 KB4092997 June 21, 2022
• 4078302 FIX: Processing a tabular model database, table, or partition takes long to process in SSAS 2017 Q4078302 KB4078302 June 21, 2022
• 4077103 FIX: In-Memory databases in Availability Group hang during recovery in SQL Server 2017 Q4077103 KB4077103 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
• 5014553 Description of the security update for SQL Server 2017 CU29: June 14, 2022 Q5014553 KB5014553 June 14, 2022
• 5014354 Description of the security update for SQL Server 2017 GDR: June 14, 2022 Q5014354 KB5014354 June 14, 2022
• 4567166 FIX: Assertion failure occurs when you try to insert record into a page in fully logged mode in SQL Server 2017 and 2019 Q4567166 KB4567166 June 2, 2022
• 4561305 FIX: Concurrent inserts against tables with columnstore indexes may cause queries to stop responding in SQL Server Q4561305 KB4561305 June 2, 2022
• 4538275 FIX: Database initialization may fail by using automatic seeding in SQL Server 2017 Q4538275 KB4538275 June 2, 2022
• 4538205 Improvement: Download new CAB files that have fixes for R/Python runtime features Q4538205 KB4538205 June 2, 2022
• 4536005 FIX: Fix incorrect memory page accounting that causes out-of-memory errors in SQL Server Q4536005 KB4536005 June 2, 2022
• 4532432 Mssql-conf tool fails if IPV6 is disabled on the Linux system Q4532432 KB4532432 June 2, 2022
• 4529876 FIX: Memory may not get released when you process partitions with data in SQL Server Q4529876 KB4529876 June 2, 2022
• 4522405 FIX: Non-yielding scheduler error occurs when you run batch query with sort operation in SQL Server 2017 and 2019 Q4522405 KB4522405 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
• 4513237 FIX: Async secondary replica receives logs from primary replica in SQL Server 2017 on Linux but it does not harden or redone Q4513237 KB4513237 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
• 4508623 FIX: "sys.fn_hadr_backup_is_preferred_replica(database)" query fails for WSFC type in SQL Server 2017 Q4508623 KB4508623 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
• 4502532 FIX: Query takes long time if you enable Batch Mode Adaptive Join in SQL Server 2017 Q4502532 KB4502532 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
• 4501542 FIX: Refresh command stops responding occasionally because of thread deadlock in SSAS 2017 Tabular mode Q4501542 KB4501542 June 2, 2022
• 4499423 FIX: Performance issues and timeouts may occur while connecting with SQL Server 2017 Q4499423 KB4499423 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
• 4490144 Improvement: New XEvent sqlserver.security_authentication_perf_interrogate_login is added in SQL Server 2017 Q4490144 KB4490144 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
• 4488026 FIX: Access violation occurs when automatic statistics update happens on tables with incremental statistics in SQL Server 2017 Q4488026 KB4488026 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
• 4530955 FIX: Error 18456 occurs when you run DMV queries on the SQL Server 2019 or 2017 instance after rebuilding system databases Q4530955 KB4530955 May 17, 2022
• 5013207 FIX: Python is broken after the runtime upgrades to Python 3.7 Q5013207 KB5013207 March 30, 2022
• 5008296 FIX: Missing change data capture cleanup execution isn't identified because of a deadlock without an error message Q5008296 KB5008296 March 30, 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