SQL Server 2019 articles, fixes and updates - September 2021

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

• 5003937 Improvement: New XEvents temp_table_cache_trace and temp_table_destroy_list_trace are created in SQL Server 2019 and 2016 Q5003937 KB5003937 September 16, 2021
• 5003596 FIX: Log line is verbose when Always On Availability Group has many databases in SQL Server 2019 and 2016 Q5003596 KB5003596 September 16, 2021
• 4578579 Improvement: Availability Group listener without the load balancer in SQL Server 2016, 2017 and 2019 Q4578579 KB4578579 September 16, 2021
• 4541303 FIX: Non-yielding Scheduler error may occur with Always On availability group in Microsoft SQL Server Q4541303 KB4541303 September 16, 2021
• 4541132 Improvement: Size and retention policy are increased in default XEvent trace system_health in SQL Server 2016, 2017 and 2019 Q4541132 KB4541132 September 16, 2021
• 4537868 Improvement: Enable DNN feature in SQL Server 2016 and 2019 FCI Q4537868 KB4537868 September 15, 2021
• 4515772 FIX: Transaction log isn't truncated on a single node Availability Group in SQL Server Q4515772 KB4515772 September 15, 2021
• 5004750 FIX: SQL Server often crashes when network.forceencryption property is set to '1' Q5004750 KB5004750 September 14, 2021
• 5004734 FIX: Persisted computed columns not being consistently blocked for Columnstore index Q5004734 KB5004734 September 14, 2021
• 5004573 FIX: SQL Server affinity settings are reset after applying CU for SQL Server 2017 and 2019 Q5004573 KB5004573 September 14, 2021