Platinum Sponsor

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
  • Video