SQL Server is a mission critical database platform but is sensitive to misconfigurations, bad practices, sub-optimal indexing strategies and poor coding mistakes. Even the fastest hardware can end up performing like a ZX-81 if you get things wrong.
If you are a Database Administrator or Consultant who is responsible for expert performance analysis, problem detection and tuning of the SQL engine then it is important you are able to analyse and tune SQL Server like a BOSS.
In this full training day, I will explain how to identify and resolve serious real world performance problems using concrete examples, demonstrations, possible effects and answers. This workshop will provide over 40 scripts which can be used directly in the workshop on your own machines during the day and we shall simulate performance problems and look to resolve them using a top-down approach.
A selection of things you can look forward to learning and experiencing during the day are:
- Waits and Queues methodology
- Instance and database level configuration
- TempDB importance and optimization
- Index Analysis and tuning
- Humour (yes Germans can be funny too!)