Tuning Indexes to Avoid Blocking
06/26/2025
11:00 AM CT
Online
Indexing can make or break your SQL Server performance. You need just the right balance: enough indexes to speed up your queries, but not so many that they drag down your inserts, updates, and deletes.
Join world-renowned SQL Server expert Brent Ozar as he breaks down the “5 & 5 indexing rule”—a practical approach to tuning indexes for maximum efficiency and minimum contention. Through real-world demos, Brent will show how a single poorly chosen index can bring your system to a crawl with blocking issues.
Whether you're troubleshooting slow transactions or proactively tuning your SQL Server for performance, this session will give you actionable strategies you can use immediately.
Who should attend?
DBAs, SQL Developers, Database Engineers, and anyone responsible for SQL Server performance.
You’ll learn:
- How to strike the right indexing balance
- The “5 & 5” rule and why it works
- How to spot and resolve blocking caused by indexes
- Real-world tuning tactics you can apply today
Secure your spot and gain practical tuning knowledge from one of the top SQL minds in the world.