22-25 April 2026 
SQLBits 2011
High Scale OLTP - LL From SQLCAT Performance Labs
In this session, I will talk about the lessons we have learned and the methodology we follow when diagnosing and resolving issues with real customer workloads running on 64 and 128 logical cores
With the combination of Windows Server 2008 R2 and SQL Server 2008 R2 it has now become possible to run SQL Server on up to 256 Cores. Multi-core x64 systems continue to decrease in price, more customers are using 24, 32 or >64 CPU core systems.
In this session, I will talk about the lessons we have learned and the methodology we follow when diagnosing and resolving issues with real customer workloads running on 64 and 128 logical cores. You will see some interesting real-life bottlenecks and get an insight into how we resolve them and what sort of numbers are achievable on a big SQL Server box.
Speakers
Ewan Fairweather's previous sessions
Building Big - In The Cloud
The Azure CAT team has successfully architected, designed and built hundreds of cloud projects. In this session we will share the learnings on how to design a cloud application to scale to handle large, complex workloads.
SQL Server in Windows Azure Infrastructure as a Service
Ewan Fairweather and Silvano Coriani from the SQL CAT team will take you on a tour of the new features that make up the Windows Azure Virtual Machines and Virtual Networks running SQL Server 2012 in a Virtual Machine.
High Scale OLTP - LL From SQLCAT Performance Labs
In this session, I will talk about the lessons we have learned and the methodology we follow when diagnosing and resolving issues with real customer workloads running on 64 and 128 logical cores