SQL Server 2008 R2: How to Manage CPUs, Cores, and CPU Groups
Return to Session Listings
Presenter: Thomas Grosher
Session 22 (09:00 GMT on May 20)
To leverage the increasing number of cores in modern server hardware, SQL Server 2008 R2 supports up to 256 logical cores. In this session, you’ll learn how to use R2 to manage CPU resources and make workloads—especially on systems that host multiple databases—run faster. We’ll talk about CPU Affinity, Hardware NUMA, Software NUMA, and how, when used properly, these features can boost the performance of your workloads.
About the Speaker
Thomas Grosher has spent the last 15 of his 20 years as an IT pro exploring the inner workings of SQL Server while working for leading companies in the entertainment and pharmaceutical industries. His main focus is to architect, plan, and provide a reliable, highly available, secure, and scalable SQL Server infrastructure, including hardware, network, storage systems, operating systems, SQL Server configuration, and application data access.
Grosher currently works with one of the largest SQL Server installations in the world, processing hundreds of millions of transactions daily while moving peta bytes of data in a 24x7 environment. He speaks regularly at conferences and events in North America and Europe and works closely with the Microsoft SQLCAT group to share his knowledge.
Register now for 24 Hours of PASS!