Session Title: Scaling SQL Server Beyond 1 Core
Speaker(s): Thomas Grohser
Abstract: The data we have to manage grows faster and faster and the queries we analyze it are getting more and more complex. Many applications and workloads can not easily be converted to scale out solutions. This session explains how to scale up SQL Server and what you need to do to end up with a system that scales well.
We will look at 2,4,8 and 32 socket systems and see how we can optimize for latency, throughput and concurrency. We look at hardware options, OS configurations and SQL Server settings.
500+ sessions are now available on-demand from Data Platform Summit 2022, 2021 & 2020 at no cost. Browse all sessions.
Stay tuned, more learning coming your way.