SQL Server 2008 R2: How to Manage CPUs, Cores, and CPU Groups

Presenter: Thomas Grosher

Session 22 (09:00 GMT on May 20)

Session Details

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.