Watch Brent Tune Servers: Ignite 2015

At Microsoft Ignite 2015 in Chicago, I demonstrated how to tune a few SQL Server workloads with my favorite process:

  • Measure how fast the SQL Server is going
  • Check its bottlenecks
  • Apply some easy-to-tweak configuration settings and measure the difference

How to Get the Stack Overflow Demo Database

The nice folks at Stack Exchange make all of their data available online. Well, it’s technically your data since you’re the one answering questions. Well, technically it’s someone else’s, because you’re one of those lazy people who never answers questions. You only log in to downvote my answers. But I digress.

The thing is, it’s available in XML because people use all kinds of databases. (Stack uses Microsoft SQL Server, but they cleanse the data and export it to a more universal format.) For you to get a SQL Server database copy, you have to:

  1. Download the XML data dump via BitTorrent
  2. Extract it (it’s around 60GB as of this writing)
  3. Use the Stack Overflow Data Dump Importer (SODDI) to bring it into SQL Server

I documented the full Stack Overflow data dump import process here.

How to Follow Along with My Demos

Here’s the full demo script:

1 Comment.