Home » Workshop SQL Server Performance Tuning Fundamentals

Workshop SQL Server Performance Tuning Fundamentals

Leer de basis van performance tuning en verbeter de performance van je SQL queries
Studie-investeringsformulier
Terug naar overzicht

Cursusbeschrijving

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.

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

    • Materiaal

    Info Support cursusmateriaal

    Voorkennis

    Ruime ervaring met T-SQL queries