Monitoring, Maintaining, and Tuning, For Database Administrators, For IT Professionals

SQT07 Index Tuning and Maintenance Demystified


2:00PM - 3:15PM

Level: Introductory to Intermediate

Don Jones


Curriculum Director for IT Pro Content


Dig deep into SQL Server index tuning. Learn exactly how SQL Server builds, maintains, and uses indexes under the hood, and review best practices for building and maintaining indexes. You’ll also walk through a complete index performance-tuning example using SQL Profiler, giving you a practical scenario that you can put to use as soon as you get home. You’ll learn about all of the ins and outs of indexes, including file placement, read vs. write workload, statistics maintenance, fragmentation and page splits, rebuilding and reorganizing, and much more. If you’re just getting started as a DBA, or need a quick review of index tuning essentials, this is the perfect session for you.