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.
André is a freelance SQL Server specialist. He has done a lot of DBA work on 100’s of servers where he discovered his love for Powershell, architecting SQL Server solutions, building and tuning ETL processes (with BIML), and even implementing PDW.
André is a SQL Server MPV, Dutch PASS Chapter Leader and organiser of SQL Saturday Holland