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.
Slide Deck 6.3 MB , WMV Video 213 MB