|
|
|
|
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 |
7:10:00 |
|
Total Duration |
82:07:00 |
||
Module 2: Wait Statistics |
|||
Lecture |
Intro & Agenda |
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 |
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 |
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 |
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 |
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 |
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 |
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 ! |