Session

A Self-Tuning Fill Factor Technique for SQL Server

This session explores a early AI technique for assigning fill factor values to almost all indexes in a database. It is based on a brute force technique I used back in exploring performance characteristics for a rocket motor with specified performance parametrics. Applying this technique to a fairly active OLAP database has shown about a 30% improvement in performance (and reduced some of those 2 am calls). All scripts are provided through GitHub.

Mike Byrd

ByrdNest Consulting, Senior Database Engineer

Llano, Texas, United States

Actions

Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.

Jump to top