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.

Andre Kamman

Andre Kamman's blog http://andrekamman.com

Downloads

Other sessions from this conference