SQL Server Query Performance Tuning
This intensive masterclass focuses on analysing and optimising query performance in SQL Server. The session combines in-depth knowledge of the internal workings of SQL Server with practical techniques to identify and resolve performance problems.
Attendees gain insight into the architecture of SQL Server, how queries are processed and how execution plans come about. Next, it covers various tools and methods to analyse performance, such as DMVs, Query Store, Extended Events and wait statistics.
The second part of the masterclass focuses on concrete tuning techniques, including indexing strategies, dealing with parameter sniffing, optimising parallelism and correctly applying statistics. In addition, topics such as locking, blocking and isolation levels are covered.
The masterclass concludes with best practices around performance setup, data modelling and secure SQL development, so that attendees are not only able to solve existing problems, but can also prevent future performance issues.
- Understanding how SQL Server works internally (architecture, query processing and storage)
- Reading and interpreting execution plans to identify performance problems
- Analysing performance with tools such as DMVs, Query Store, Extended Events and wait statistics
- Applying effective query tuning techniques
- Recognising and correctly configuring best practices around SQL Server settings
- Recognising and resolving the impact of parallelism and parameter sniffing
- Designing and maintaining an effective indexing strategy
- Understanding and applying the importance of up-to-date statistics
- Analysing and optimising locking, blocking and isolation levels
- Evaluating data models for performance impact (OLTP vs OLAP, dimensional vs Data Vault)
- Applying basic principles of secure SQL development (such as protection against SQL injection)