Skip to main content

SQL Server Indexes: The Forgotten Fill-Factor

Rate:  

About This Video
While we all know the fill factor index option when creating or rebuilding an index, few know about the huge impact a fill factor has on the performance of your machine.

Most DBA’s treat the fill-factor as a static server setting and “forget about it”.

“What number should I set the fill-factor to?” is a very challenging question that most DBA’s should bother about. High fill-factors have high data densities, while low fill-factors can cope better with non-sequential IO.

The challenge is to find a statistical model that will minimize fragmentation, optimize insert performance while reducing disk usage overhead and all this without stressing the maintenance window. By using a different approach for specific use cases this session will give you the tools to find the most optimal fill-factor for your tables.

More info on http://www.sqlserverdays.be.

 

Published Date: November 30, 2012
Presented By: Karel Coenye

 

 

Downloads

Video: WMV | MP4 | WMV (ZIP)

 

Microsoft is conducting an online survey to understand your opinion of the MSDN Web site. If you choose to participate, the online survey will be presented to you when you leave the MSDN Web site.

Would you like to participate?