--System page latch concurrency enhancements!Concurrent updates to global allocation map (GAM) pages and shared global allocation map (SGAM) pages reduce page latch contention while allocating/deallocating data pages and extents. These enhancements apply to all user databases and especially benefit tempdb heavy workloads. --Buffer pool parallel scan!Improves the performance of buffer pool scan operations on large-memory machines by utilizing multiple CPU cores. Learn more about Operations that trigger a buffer pool scan may run slowly on large-memory computers. --Query Store and intelligent query processing!The intelligent query processing (IQP) feature family includes features that improve the performance of existing workloads with minimal implementation effort. |