Welcome to class! Here’s your resources for this week’s live 3-day class: For live chat and Q&A – go to https://SQLslack.com to get an invite, then join the #BrentOzarUnlimited channel. I won’t be using the GoToWebinar Q&A or chat – I like using one window that everybody can see, and you folks can talk to…
0.1 Dec 27-29 Class Resources
Welcome to class! Here’s your resources for this week’s live 3-day class: For live chat and Q&A – go to https://SQLslack.com to get an invite, then join the #BrentOzarUnlimited channel. I won’t be using the GoToWebinar Q&A or chat – I like using one window that everybody can see, and you folks can talk to…
You'll need a membership to access this course. Check out my training classes.
- 1.1 Indexes: How to Think Like the Engine (110m)
- 1.2 Queries: How SQL Server Builds Plans and Cardinality Estimates (47m)
- 1.3 Indexes: How to Performance Tune Nonclustered Indexes with sp_BlitzIndex (70m)
- 1.4 Waits: LCK: Find and Fight Blocking (49m)
- 2.1 Queries: How to Identify and Fix Parameter Sniffing (84m)
- 2.2 Queries: Watch Brent Tune Queries with SQL Server 2017 (106m)
- 2.3 Waits: CXPACKET – Parallelism Gone Wild (34m)
- 2.4 Waits: PAGEIOLATCH – Slow Storage (77m)
- 3.1 Processes: How to Triage Performance Emergencies (84m)
- 3.2 Waits: ASYNC_NETWORK_IO, RESOURCE_SEMAPHORE, and WRITELOG (40m)
- 3.3 DBA: Corruption 201 – Optimizing CHECKDB Performance (43m)