Objectives

  • Understand how SQL Server uses system resources (CPU, I/O, memory, network) and what to look for when configuring
  • Learn how the Query Optimizer calculates the data path
  • Master the execution plans and the most important operators (index access, sorts, parallelism, etc.)
  • Monitor performance with standard SQL Server tools (Perfmon, Extended Events, Query Store, DMVs)
  • Understand the most common SQL Server wait types

Method

  • Presentations, practical exercises, case studies and question-oriented demonstrations
  • Discussion and networking during breaks and lunch (included)

Target groups

  • The Microsoft SQL Server Performance Tuning course is designed for Database Administrators (DBAs), Network/System/Application Administrators (NSAs) responsible for SQL Server databases or their support.

Prerequisites

  • Good experience and knowledge of SQL Server databases
  • Ideally, you have already taken the SQL Server DBA essentials training

5% discount for SOUG, SwissPUG and DOAG members.

Trainers

Thumbnail [150x150]

Stéphane Haby

Delivery Manager and Senior Consultant

Thumbnail [150x150]

Steven Naudet

Consultant