Scaling the DVD Store from 100 to a million TPM

Come along to see us attempt to optimise and redesign the "Dell DVD Store" sample dot.net/SQL application from a modest 100 transactions per minute to a million transactions per minute.

BIO
Bob Duffy is a SQL Server MVP, currently working as a Database and Solution Architect in Dublin, Ireland. He has over 20 years’ experience in the database sector, with MCA, MCM and Maestro certification.

SYNOPSIS
The Dell DVD store is an open source database and online commerce application used for benchmarking hardware.

Come along to see us attempt to optimise and redesign the "Dell DVD Store" sample dot.net/SQL application from a modest 100 transactions per minute to a million transactions per minute.

In Part I we will see just how far we can optimise the commerce solution using traditional tuning and scale up on a single database server and making use of technologies like the In memory OLTP engine.

In Part II we look to migrate the solution to the cloud taking advantage of scalability features the Microsoft Azure platform and best practices such as sharding, data caching and asynchronous processing.