Course Title

SQL Server Performance Tuning - Fast Track

Modules

Content Type

 

Duration

Module 0: Introduction

Lecture

Full Module

16:39:00

Before You Begin The Demos

Lecture

Before You Begin The Demos

7:42:00

Module 1: Performance Troubleshooting Methodology

Lecture

Intro & Agenda

1:30:00

Lecture

Where Shall I Begin?

1:54:00

Lecture

An Ocean Within An Ocean

3:40:00

Lecture

Installation and Configuration Best Practices

11:33:00

Demos

Demos: Reviewing Power Plan Configuration

12:01:00

Demos

Demos: Tempdb Data Files Configuration

18:23:00

Demos

Demos: Rewriting T-SQL Code

9:11:00

Lecture

Performance Monitoring, Benchmarking & Baselining

10:10:00

Lecture

Developing a Performance Troubleshooting Methodology

6:35:00

Lecture

Tools & Utilities
Summary

7:10:00

Total Duration

82:07:00

Module 2: Wait Statistics

Lecture

Intro & Agenda
Query Execution

5:24:00

Lecture

Waiting & Queuing (1)

3:54:00

Lecture

Waiting & Queuing (2)

4:14:00

Lecture

Putting It Together

2:46:00

Lecture

Working With Wait Stats
Common Wait Types
System Wait Types

11:18:00

Demos

Demos: Working With Waits

16:43:00

Lecture

PAGEIOLATCH Wait Type

3:15:00

Demos

Demos: PAGEIOLATCH Wait Type

12:05:00

Lecture

CXPACKET Wait Type

6:16:00

Demos

Demos: CXPACKET Wait Type

19:04:00

Lecture

ASYNC_NETWORK_IO Wait Type

1:05:00

Demos

Demos: ASYNC_NETWORK_IO Wait Type

10:40:00

Lecture

RESOURCE_SEMAPHORE Wait Type

3:13:00

Demos

Demos: RESOURCE_SEMAPHORE Wait Type

15:40:00

Lecture

Summary

1:40:00

Demos

Bonus Demos: Capturing Wait Stats Using Extended Events

13:50:00

Demos

Bonus Demos: Capturing Session Level Waits

7:12:00

Trivia

Trivia Time :)

1:38:00

Total Duration

139:57:00

Module 3: The Awesome Foursome – CPU, Memory, IO, Tempdb

Lecture

Intro & Agenda

1:11:00

Lecture

A Classic Example

6:00:00

Lecture

CPU Troubleshooting

11:59:00

Demos

Demos: CPU Troubleshooting (Proactive)

16:49:00

Demos

Demos: CPU Troubleshooting (Realtime)

24:58:00

Demos

Demos: CPU Troubleshooting (Reactive)

8:16:00

Lecture

Memory Troubleshooting

15:20:00

Demos

Demos: Memory Overview & Tracking Consumption

9:41:00

Demos

Demos: Memory Troubleshooting

10:30:00

Lecture

IO Troubleshooting

8:11:00

Demos

Demos: IO Troubleshooting
Virtual File Stats
Most Expensive Queries

21:02:00

Lecture

Tempdb Troubleshooting

9:28:00

Demos

Demos: Tempdb Troubleshooting (Tempdb Usage Monitoring)

15:25:00

Demos

Demos: Tempdb Troubleshooting (Allocations/De-allocations/Contention Tracking)

11:36:00

Demos

Demos: Tempdb Troubleshooting (Eager Writes)

12:20:00

Lecture

Summary

2:02:00

Demos

Bonus Demos: Performance Monitor Counters

24:30:00

Trivia

Trivia Time :)

2:12:00

Total Duration

211:30:00

Module 4: Query Tuning

Lecture

Intro & Agenda
Understanding Execution Plans

13:09:00

Demos

Demos: Understanding Execution Plans & Common Plan Iterators/Operators

41:36:00

Lecture

Statistics & Cardinality Estimation

10:39:00

Lecture

Bad Bookmark Lookups

3:30:00

Demos

Demos: Bad Bookmark Lookups

16:45:00

Lecture

Expensive Sorts

3:09:00

Demos

Demos: Expensive Sorts

20:35:00

Lecture

Implict Coversion

1:21:00

Demos

Demos: Implicit Conversion

6:11:00

Lecture

Non-SARG-Ability

1:29:00

Demos

Demos: Non-SARG-Ability

10:25:00

Lecture

Stale Statistics

12:58:00

Demos

Demos: Stale Statistics

6:31:00

Lecture

Parameter Sniffing

1:59:00

Demos

Demos: Parameter Sniffing

16:28:00

Lecture

Re-Writing TSQL Code

1:45:00

Demos

Demos: Re-Writing TSQL Code

12:48:00

Lecture

Query Store

3:08:00

Demos

Demos: Query Store

10:56:00

Lecture

Automatic Tuning

1:35:00

Demos

Demos: Automatic Tuning

20:56:00

Lecture

Intelligent Query Processing

4:59:00

Demos

Demos: Intelligent Query Processing

11:14:00

Lecture

Summary

1:57:00

Trivia

Trivia Time :)

1:50:00

Total Duration

237:53:00

Module 5: Index Tuning

Lecture

Intro & Agenda
Index Architecture

3:08:00

Lecture

Clustered Index Architecture

4:26:00

Lecture

Non Clustered Index Architecture

5:05:00

Lecture

Index Fragmentation

8:01:00

Demos

Demos: Index Fragmentation

10:49:00

Lecture

Index Tuning Guidelines

8:03:00

Demos

Demos: Speeding Aggregates and Removing Sorts

16:03:00

Demos

Demos: Removing Sorts

14:09:00

Demos

Demos: Removing Bookmark Lookups

12:29:00

Demos

Demos: Indexing for AND & OR Operator

14:20:00

Demos

Demos: Index Column Order

19:35:00

Demos

Demos: Index for Joins

10:08:00

Lecture

Identifying Missing Indexes

1:53:00

Demos

Demos: Identifying Missing Indexes

3:39:00

Lecture

Identifying Unused Indexes

1:31:00

Demos

Demos: Identifying Unused Indexes

2:32:00

Lecture

Summary

1:07:00

Trivia

Trivia Time :)

1:51:00

Total Duration

138:49:00

Module 6: Concurrency Troubleshooting

Lecture

Intro & Agenda

0:50:00

Lecture

Data Modification & Concurrency Architecture

5:40:00

Lecture

Concurrency & Locking Architecture

3:53:00

Lecture

Isolation Level - READ UNCOMMITTED

2:11:00

Lecture

Isolation Level - READ COMMITTED

1:15:00

Lecture

Isolation Level - REPEATABLE READ

5:19:00

Lecture

Isolation Level - SERIALIZABLE
Consurrency Problems vs Isolation Levels

6:09:00

Demos

Demos: Isolation Level - Dirty Reads

5:53:00

Demos

Demos: Isolation Level - Non-Repeatable Reads

6:22:00

Demos

Demos: Isolation Level - Phantom Reads

7:13:00

Lecture

Troubleshooting Locking & Blocking

3:22:00

Demos

Demos: Troubleshooting Blocking

5:01:00

Lecture

Best Practices - Locking
Troubleshooting Deadlocks
Best Practices - Deadlocks

6:05:00

Demos

Demos: Troubleshooting Deadlocks

23:15:00

Demos

Demos: Fixing Deadlocks

5:28:00

Lecture

Summary

2:35:00

Trivia

Trivia Time :)

2:10:00

Trivia

Trivia Time :)

0:00:13

Total Duration

92:41:13

Module 7: Wrap Up

Lecture

Full Module

4:03:00

Total Course Duration (MM:SS:00)

907:13:00

Total Course Duration (HH:MM:SS)

15 hrs 12 mins

Total Lecture Time

5 hrs 43 mins

Total Demo Time

9 hrs 29 mins

Yeah, demos are the real value !