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
Links
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