course
Workshop SQL Server Performance Tuning Fundamentals
Understand and practice with the basics of SQL Server Performance Tuning
Description
During this training you will learn to recognize common performance issues in SQL Server. This includes topics such as indexing & statistics best practices and learning how to read query plans. After this, you will solve these issues yourself through a series of hands-on labs.
Prior Knowledge
Students are expected to have solid experience in T-SQL querying.
Subjects
- 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
Schedule
All courses can also be conducted within your organization as customized or incompany training.
Our training advisors are happy to help you provide personal advice or find Incompany training within your organization.
"Extremely good teacher"Sander
-
Hoge waardering
-
Praktijkgerichte trainingen
-
Gecertificeerde trainers
-
Eigen docenten