Play by Play: Database Tuning
Rob Sullivan tweaks the performance of a failing database using the Stack Overflow data dump.
What you'll learn
In this single video, Rob Sullivan is tasked with perf-tuning an ASP.NET MVC 3 web application (using EF) so it can handle a StackOverflow data dump. Over 4 million rows of data in the Posts table alone! The application is one that any web developer might build - with holes in it that any developer might fall into. The site is timing out, we're down - we need some help from an amazing DBA!