<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=612681139262614&amp;ev=PageView&amp;noscript=1">
Skip to content

Need help? Talk to an expert: phone(904) 638-5743

Home / SQL Server / SQL Server Performance Tuning

SQL Server Performance Tuning

Master the art and science of SQL Server performance tuning. Gain tools and knowledge to ensure efficient, reliable SQL Servers. Experience advanced tuning and optimization in your DBA work. Boost your performance tuning skills.

Free Community Plan View Pricing Plans
SQL Server Performance Tuning
  • Course Info
  • Instructor
  • System Requirements
  • What to know beforehand

Course Description

SQL Server performance is as much an art form as it is a science. Many times a server will give conflicting information about the state that it is in. The SQL Server Performance Tuning training is designed to provide SQL DBAs with the tools and knowledge that is required to keep their SQL Servers running efficiently and reliably. Additionally, you will experience how to perform advanced performance tuning and optimization in your everyday DBA work.

Course Outline ( Free Preview)

SQL Server Performance Tuning - What you need to get started

Module 01 - Class Introduction 10 min.

Module 02A - Understanding Queries in SQL Server (Query Basics)

Module 02B - Understanding Queries in SQL Server(Relational Engine Query Process)

Module 02C - Understanding Queries in SQL Server (Parallelism) 21 min.

Module 03A - Index Tuning (Basic Tuning) 39 min.

Module 03B - Index Tuning (Columnstore Indexes and Maintenance) 35 min.

Module 04 - Locking, Blocking, Deadlocks and Latches 29 min.

Module 05 - Waits and Queues Methodology 21 min.

Module 06 - Baselines 19 min.

Module 07 - Monitoring and Alerting 12 min.

Module 08 - Extended Events 37 min.

This course includes:

  • 4+ hours of training
  • 12 Modules
  • * Access on mobile and browser
  • Certificate of Completion
Free Community Plan View Pricing