training
Workshop SQL Server Performance Tuning Fundamentals
Leer de basis van performance tuning en verbeter de performance van je SQL queries
Beschrijving
Je leert de essentiële onderdelen van SQL Server performance tuning kennen.
Denk hierbij aan onderwerpen als indexing best practices en hoe je query plans moet lezen. Vervolgens los je zelf veelvoorkomende problemen op in een serie hands-on labs.
Benodigde voorkennis
Ruime ervaring met T-SQL queries
Onderwerpen
- Table & Query Design
- Indexing in SQL Server
- Query Execution Plans
- Common Database Objects
- Locking, Query Hints and Monitoring
Table & Query Design
In this chapter we will discuss the impact of basic choices in your table design and query strategy.
Goals:
- Learn about normalization and why it is important.
- Understand the benefits of set oriented SQL code
- Learn about Data Types, Keys and constraints in tables
- Get to know temporary tables
Indexing in SQL Server
In this chapter we discuss the different index options in SQL Server and when to use them.
Goals:
- Understand the difference between Heap, Clustered and Nonclustered Indexes
- Know when to create and index
- Check whether your index works as intended
- Learn about the different options when creating indexes
Query Execution Plans
In this chapter we will dive deeper into query execution plans. How to read them, what can you encounter, how can they be used?
Goals:
- Understand the common elements in execution plans
- Learn how to compare the most important aspects of different plans
- Get used to reading alerts and warnings in execution plans
- Understand how statistics impact plan selection
Common database objects
In this chapter the different common database objects (views, functions, stored procedures) and their impact on query performance are discussed.
Goals:
- Know the difference between Views, Functions, Stored Procedures
- Understand Parameter sniffing and dynamic Execution
Locking, Query Hints and Monitoring
In this chapter the impact of multiple processes running queries at the same time is discussed, as well as quick options to find the most troublesome queries.
Goals:
- Understand Locks in SQL Server
- Learn best practices when using transactions and error handling
- Learn about query hints
- Monitor and compare performance with the query store
Planning
Incompany of persoonlijk advies nodig?
Onze opleidingsadviseurs denken graag met je mee om een persoonlijk advies te geven of een incompany training binnen jouw organisatie te vinden.
"Deze training was direct toepasbaar op het project"Cursist
-
Hoge waardering
-
Praktijkgerichte trainingen
-
Gecertificeerde trainers
-
Eigen docenten