$250 or 2 monthly payments of $125

SQL Server Performance Engineering

Course
102 Lessons

Every SQL Server professional needs to understand not just what makes queries fast, but what makes them slow. This knowledge is essential whether you're aiming to become a performance wizard or trying to make those problematic queries stop holding up the business. By the end of this course, you'll have the tools and confidence to diagnose and resolve performance issues without resorting to guesswork or prayer.

Buy now

00 Welcome.pdf

Welcome! (8 minutes)

01 Good Setting Bad Setting.pdf

Good Setting, Bad Setting (20 minutes)

CPU Waits

The videos in this section are all about wait stats that relate to CPU usage.

02 CPU Waits.pdf

Wait Stats Analysis (Lecture, 8 minutes)

02a Important Wait Stats.sql

Waits Analysis (Demo, 30 minutes)

SOS_SCHEDULER_YIELD Waits (Lecture, 11 minutes)

02b CPU Waits SOS.sql

SOS_SCHEDULER_YIELD Waits (Demo, 24 minutes)

The CX Waits (Lecture, 23 minutes)

02c CPU Waits CX.sql

02d CTFP Example.sqlplan

02e Branches and Threads.sqlplan

The CX Waits (Demo, 34 minutes)

THREADPOOL Waits (Lecture, 13 minutes)

02f CPU Waits THREADPOOL.sql

02g CPU Waits THREADPOOL Thread Example.sqlplan

THREADPOOL Waits (Demo, 21 minutes)

Memory Waits

This section contains all the videos related to memory waits.

03 Memory Waits.pdf

Memory Waits (Lecture, 13 minutes)

03a Memory Waits.sql

Memory Waits (Demo, 24 minutes)

Query Compile Waits (Lecture, 5 minutes)

03b RSQC Waits.sql

03c RSQC Waits.sqlplan

Query Compile Waits (Demo, 11 minutes)

Query Compile Locks (Demo, 10 minutes)

Memory Grants (Lecture, 8 minutes)

Memory Grant Waits (Lecture, 9 minutes)

Memory Grant Waits (Demo, 26 minutes)

Disk Waits

This section contains all the videos related to disk waits.

04 Disk Waits.pdf

Disk (Lecture, 14 minutes)

04a Disk.sql

Disk (Demo, 35 minutes)

Disk Waits (Lecture, 13 minutes)

04b Disk Waits.sql

Disk Waits (Demo, 15 minutes)

Blocking and Deadlocking

This section contains all the videos about blocking and deadlocking.

05 Locking and Blocking.pdf

Blocking and Deadlocking (Lecture, 26 minutes)

Analyzing Blocking (Lecture, 8 minutes)

Analyzing Deadlocks (Lecture, 8 minutes)

05a Blocking and Deadlocking Analysis.sql

Blocking and Deadlocking Analysis (Demo, 28 minutes)

Overindexing Problems (Lecture, 17 minutes)

05b Unhelpful Indexes.sql

Overindexing (Demo, 17 minutes)

Helpful Indexes (Lecture, 5 minutes)

05c Helpful Indexes.sql

Helpful Indexes (Demo, 10 minutes)

Isolation Levels

This section has all the videos about isolation levels.

06 Isolation Levels.pdf

Isolation Levels (Lecture, 13 minutes)

Why I love NOLOCK (Lecture, 9 minutes)

06a Why I Love NOLOCK.sql

Why I Love NOLOCK (Demo, 15 minutes)

Read Committed Problems (Lecture, 13 minutes)

06b Read Committed Perils Part 1.sql

Read Committed Problems Part 1 (Demo, 10 minutes)

06c Read Committed Perils Part 2.sql

Read Committed Problems Part 2 (Demo, 10 minutes)

Read Queries Blocking Write Queries (Lecture, 6 minutes)

06d Read Blocker.sql

Read Blocker (Demo, 14 minutes)

Read Queries Deadlocking With Write Queries (Lecture, 6 minutes)

06e Read Deadlocker.sql

Read Deadlocker (Demo, 11 minutes)

Optimistic (Row Versioning) Isolation Levels (Lecture, 9 minutes)

Bad Query Patterns For Row Versioning (Lecture, 5 minutes)

06f Race Condition.sql

Optimistic (Row Versioning) Isolation Levels (Demo, 18 minutes)

Query and Index Tuning

This section covers the query and index tuning material.

07 Finding Bad Queries.pdf

Finding Bad Queries (Lecture, 19 minutes)

07a Finding Bad Queries.sql

08 Fixing Bad Queries.pdf

Fixing Bad Queries

08b Fixing Bad Queries.sql

Finding Bad Queries (Demo, 22 minutes)

Table Variables

This section contains all the materials about Table Variables

01a Table Variables.sql

01b Table Variables.sqlplan

Table Variables (Demo, 21 minutes)

Local Variables

This section contains all the materials about Local Variables

02a Local Variables.sql

Local Variables (Demo, 21 minutes)

Scalar UDFs

This section contains all the materials about Scalar UDFs

03a UDFs.sql

03b UDFs.sqlplan

Scalar UDFS (Demo, 19 minutes)

Eager Index Spools

This section contains all the materials about Eager Index Spools

04a Eager Index Spool.sql

Eager Index Spools

Common Table Expressions

This section contains all the materials about Common Table Expressions

05a CTEs.sql

Common Table Expressions (Demo, 20 minutes)

JOIN ON OR

This section contains all the materials about Joins with an OR clause

06a Joins On Or.sql

Join OR Clause

Left Join vs Not Exists

This section contains all the materials about Left Joins vs Not Exists

07a Left Join vs Not Exists.sql

Left Join vs Not Exists (Demo, 17 minutes)

Joins With Windowing Functions

This section contains all the materials about Joins to table expressions that contain Windowing Functions

08a Join With Row Number.sql

08b Big Grant String Columns.sqlplan

Joins on Windowing Functions

Optional Parameters

This section contains all the materials about Optional Parameters

09a Optional Parameters.sql

Optional Parameters

Parameter Sniffing

This section contains all the materials about Parameter Sniffing

10a Parameter Sniffing.sql

10b VoteTypeId 2.sqlplan

Parameter Sniffing (Demo, 30 minutes)