Lessons Learned from 128 Core OLTP Testing

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. Recently, the SQL CAT team had a customer in the lab to test a banking application at high scale-up. Previously, we had test runs for the same application on 32-cores – but now the time had come to stress the app to 128 Cores.
In this session, I will talk about the lessons we learned from stress testing an OLTP workload at this scale. You will see some interesting bottlenecks and get an idea of what sort of numbers are achievable on a big SQL Server box. Of course, I will also provide you with the guidance on how to get those numbers.

Thomas Kejser

Thomas has been working with SQL Server since version 6.5 and performance tuned cubes since OLAP Server 7.0. He has worked on some of the largest cubes in the world. Performing fast loading of warehousing and removing every bottleneck is one of Thomas specialties. He holds a master degree in computer science and has 10+ years of experience with developer coaching and scalable architectures on both OLTP and OLAP systems.

Thomas Kejser's blog http://sqlcat.com

---

Downloads

File Type Ext ContentName Presentation .pptx Slide Deck

<< 1 >>

---

Other sessions from this conference

Denormalisation –having your cake and eating it.

Design patterns for SSIS Performance

Designing and Tuning high speed data loading

Event Driven Cube Performance and Security Monitoring

Fast Track Foundations: Get Serious about Sequential I/O

Getting Started with SQL Azure

High Availability in the Real World!

High performance functions

Improving Database Performance by Removing the Database

Inside the SQL Server Query Optimizer

Introduction to Performance Tuning Analysis Services 2008

Make your DBA life better using SQL Server technologies - notes from field & best practices

Monitoring and Tuning Parallel Query Execution

Non-Functional Dependencies - A talktorial on getting performance and scalability right through proper Database Design and understanding Set and Relational theory

Optimizing tempdb and temporary object use

Performance Management for SQL Server with SCOM 2007

Performance Monitoring & Tuning - Documented Tips & Tricks

Performance Troubleshooting made easy with PAL

Photograph: SQL Server Crash Dump Analysis

Scaleout scenarios with Service Broker

SQL Server 2008 Reporting Services Scalability and Performance

Supercharge MDX performance using MDX Studio

Transaction Log Performance Tuning, Stop shouting Timber!