SQL Server optimization stuff you won’t find on Google (yet)

Henk van der Valk from the Unisys performance lab will  be my special guest for this session.

He has a test system that we all would like to have at home, probably until you get the first electricity bill :-)
The ES7000 has 96 Cores and half a Terabyte of RAM (!). 
 
We will look at various ways to push SQL Server workloads by methodically detecting and resolving bottlenecks.
 
A number of tips, tricks and testing methods that Henk tought the (Dutch) SQL Server community over the past years I applied successfully on various troubled systems.
Together we will show you how you can take some lessons learned and apply them on mid-sized and even smaller systems. 
(We’ll even try some of them on a laptop, and of course we will remote connect into the big machine )
 
In this session you will:

  • Learn how to measure what the next bottle-neck is so you don’t have to guess. (Using perfmon and waitstats)
  • Hear about optimization tips that will get the most out of your hardware to speed up your ETL process. 
  • Learn some magic to speed up tablescan  speed from disk and memory (!) significantly.
Presented by Andre Kamman at SQLBits V
  • Downloads
    Slide deck available Slide Deck 6.3 MB
    Video available WMV Video 213 MB
  • SpeakerBIO

    I’m a SQL Server consultant based in the Netherlands. I’m a SQL Server MVP and I’m the co-founder and current chairman of the Dutch PASS Chapter and a member of the volunteer team for the Dutch SQL Saturday’s. I’ve done a whole lot of pure DBA work managing 100′s of servers and learning something new every day.

    These days I spend a lot of time on just a few servers containing some large databases and the better part of the day is spent with SSIS. In both roles I’ve been using Powershell a lot. I joke sometimes that I replaced myself with a powershell script when leaving the DBA role, but these days I automate so much that I have to watch myself and not actually do just that

    http://andrekamman.com http://andrekamman.com/feed
  • Video