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.

• 4522405 FIX: Non-yielding scheduler error occurs when you run batch query with sort operation in SQL Server 2017 and 2019 Q4522405 KB4522405 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
• 5018050 Improvement: Add new Azure SQL Database service tier options to the Stretch Database feature Q5018050 KB5018050 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
• 5008184 FIX: ForceLastGoodPlan doesn't account for aborted and timed out queries in regression detection logic Q5008184 KB5008184 September 20, 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
• 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
• 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
• 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