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.
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