SQL Server Indexes: The Forgotten Fill-Factor
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
Tags:
TechNet Video
,
Zune
,
iPod
,
Media
,
Homepage
,
TechNet Edge
,
Karel Coenye
,
Belux
,
SQL Server Days Belgium 2012
,
Fill Factor
,
SQL Server 2012
,
ScreenCasts
|
.png)
