Play by Play: Database Tuning

Rob Sullivan tweaks the performance of a failing database using the Stack Overflow data dump.
Course info
Rating
(80)
Level
Intermediate
Updated
Jun 4, 2011
Duration
1h 4m
Table of contents
Description
Course info
Rating
(80)
Level
Intermediate
Updated
Jun 4, 2011
Duration
1h 4m
Description

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!

About the author
About the author

Rob is a bona fide Alpha Nerd. He is the Senior Data Magistrate for the government in the Prism division where he specializes in data collection and data profiling. When he isn’t lording over AppDevs and Architects, he can be found truncating vast amounts of pizza, ETLing burritos and breaking down the execution plans of video games.

More from the author
A Tour of PostgreSQL
Intermediate
2h 14m
Mar 26, 2012
About the author

Rob Conery co-founded Tekpub and created This Developer's Life. He is an author, speaker, and sometimes a little bit opinionated.

More from the author
Electron Playbook
Intermediate
1h 38m
Mar 2, 2016
On Polyglot Programming
Intermediate
1h 7m
Jan 22, 2016
More courses by Rob Conery
Section Introduction Transcripts
Section Introduction Transcripts

Introduction
[Autogenerated] I'm Rob Connery and welcome to play by play here at Portal site. Our play by Play productions put you in a chair right next to an expert in the field so you can see how they get their work done when confronted with a singular problem or task. These productions air free form an uncut, and we try not to spend much time on explanations. We go full throttle to get the problem solved. The goal of these courses is for you to see how experienced coders solve problems, tools they use and how they think about software development. This differs from a typical, more structured course of coral site, but we think you'll enjoy the less structured, more informal setting. This material can be relatively advanced at times, and we may not slow down to explain ourselves. So I encourage you to stop and re watch the video. If you find yourself getting lost in this our first full throttle episode, I sit down with Rob Sullivan with Crack D B A. Who has a rather tough problem to solve. We've given him a day to drop from the Stack overflow database and prepared a typical starter site using SP dot net MVC and Entity Framework Code first from Microsoft. The code, as written is pretty much what you would find in any SP dot net, NBC website. But we have a problem. Our site has grown so quickly have millions and millions and millions of rows of data in our database. Our queries air started to choke. We're getting time outs everywhere we need to perfect in our database and our website So he wouldn't hired ourselves a d b a for the day. And that's Rob. Let's see what he can do with this mountain of data being choked through Entity Framework using sequel server and ESPN on at NBC three.