Next Level Scalability on SQL Server 2022
Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only! Grab it Discover the latest scalability enhancements in SQL Server 2022, the most cloud-enabled release to date, in this 51-minute conference talk from SQLBits. Explore default improvements and new capabilities that database administrators can enable to create a highly available and performant platform. Delve into tempdb performance optimization, buffer pool parallel scan operations, columnstore index improvements, and optimized transactional locking mechanisms. Learn about critical aspects such as object allocation contention, metadata contention, and various types of tempdb contention. Gain insights into current best practices for tempdb and understand how SQL Server 2022 addresses these challenges. Presented by Ajay Jagannathan, Principal Group Program Manager for Azure SQL Database and SQL Server Engine PM team, and David Pless, this talk provides valuable knowledge for database professionals looking to leverage the latest scalability features in SQL Server 2022.