Overview
Discover a groundbreaking technique for optimizing SQL Server index performance in this 50-minute conference talk from PASS Data Community Summit. Learn how to establish a near-optimal fill factor value for every index in a database, moving beyond the default setting. Explore the T-SQL behind this innovative approach, developed for a high-activity OLTP database, which continuously tunes based on index fragmentation and bad page splits. Witness how this method achieved a 30% reduction in overall database wait times within 60 days of implementation. Gain insights into how the technique adapts to changes in data skew and evolving application interactions. Download the provided code to implement this performance-enhancing strategy in your own SQL Server environments.
Syllabus
A Self-Tuning Fill Factor Technique for SQL Server - Mike Byrd
Taught by
PASS Data Community Summit