SQL Server Performance Tuning

Part Of The On-Demand Courses


  • SQL Server Index Tuning and Query Tuning best practices
  • To use tools such as Profiler, Extended Events and SQLIO
  • To create a plan that will assist the DBA to monitor servers, alert on issues and resolve slowdowns


This course includes:

Course Description

SQL Server performance is as much an art form as it is a science. Often, a server will give conflicting information about the state that it is in. The SQL Server Performance Tuning course 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.


Click here for a downloadable PDF




Module 01 | Class Introduction
10m 18s total


Module 01A | Class Introduction
10m 18s


Module 02 | Understanding Queries in SQL Server
75m 26s total


Module 02A | Query Basics
18m 35s


Module 02B | Relational Engine Query Process
35m 31s


Module 02C | Parallelism
21m 20s


Module 03 | Index Tuning
64m 12s total


Module 03A | Basic Tuning
38m 42s


Module 03B | Columnstore Indexes and Maintenance
34m 56s


Module 04 | Locking, Blocking, Deadlocks and Latches
29m 18s total


Module 04A | Locking, Blocking, Deadlocks and Latches
29m 18s


Module 05 | Waits and Queues Methodology
20m 42s total


Module 05A | Waits and Queues Methodology
20m 42s


Module 06 | Baselines
19m 13s total


Module 06A | Baselines
19m 13s


Module 07 | Monitoring & Alerting
12m 15s total


Module 07A | Monitoring & Alerting
12m 15s


Module 08 | Extended Events
37m 04s total


Module 08A | Extended Events
37m 04s



Pragmatic Works Trainer
Mitchell Pearson has been with Pragmatic Works for 8 years as a Data Platform Consultant and the Training Content manager. Mitchell has authored books on SQL Server, Power BI and the Power Platform. Data Platform experience includes designing and implementing enterprise level Business Intelligence solutions with the Microsoft SQL Server stack (T-SQL, SSIS, SSAS, SSRS), the Power Platform and Microsoft Azure.


System Requirements

  • Microsoft Windows XP Professional, Microsoft Windows Server 2003, Microsoft Vista, Windows 7, Windows 8, or Windows 10
  • 2 GHz or faster CPU
  • 2 GB of available RAM (recommended 4 GB)
  • 20 GB of free hard drive space
  • SQL Server Developer, Standard or Enterprise Edition 2008/2008R2/2012/2014
    • SQL Server Database Engine
    • SQL Server Management Studio
  • AdventureWorks2012 or AdventureWorks2014 databases installed on the instance
  • AdventureWorksDW2012 or AdventureWorksDW2014 databases installed on the instance

What to Know Before Class

The course assumes attendees have a strong understanding of SQL Server fundamentals. For example, knowing and using the SQL Server Management Studio (SSMS) interface and associated toolbox items before attending this class.

Overall, I enjoyed the class and learned information I can apply to my job.


I was so impressed with the energy and enthusiasm of Manuel Quintana, it motivated me to learn more about ADF. Easy to follow examples, at the same time very practical and relevant to day-to-day use.

Jayasurya P.

I like the way the featured demos incorporated integration, logging patterns, and end-to-end examples, so several things were covered at once.


Start With The Free Community Plan

Pragmatic Works free community plan gives you lifetime access to 7 Microsoft “in a day” courses on Power BI, Excel, Power Apps, Azure Synapse, Power Automate, Paginated Reports and Chatbots.



• Get preview access to all 70+ courses & custom Learning Paths for 7 days

• Labs and files included

• Access courses from our mobile app or desktop

• Access quizzes to practice while you learn

Get Instant Access Now!