What if you’re dealing with a database that already exists, and you need to make it go faster with the minimum changes possible? You need to analyze the current indexes, remove the ones that aren’t helping, and add the right ones. We’ll show you how. Part 1 (19 minutes): Part 2 (51m):
1.3 Indexes: How to Performance Tune Nonclustered Indexes with sp_BlitzIndex (70m)
What if you’re dealing with a database that already exists, and you need to make it go faster with the minimum changes possible? You need to analyze the current indexes, remove the ones that aren’t helping, and add the right ones. We’ll show you how. Part 1 (19 minutes): Part 2 (51m):
You'll need a membership to access this course. Check out my training classes.
- 0.1 Dec 27-29 Class Resources
- 1.1 Indexes: How to Think Like the Engine (110m)
- 1.2 Queries: How SQL Server Builds Plans and Cardinality Estimates (47m)
- 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)