February 1, 2011 at 2:05 am
SQL citizens,
We all are familiar with the DMV's.
One of the DMV we are used to is sys.dm_db_index_physical_stats to findout the fragmentation level for indexes.:cool:
Some people has delusion of keeping the avg_fragmentation_in_percent value as close to zero as possible for maximum performance and we can achieve this by setting the FILLFACTOR value from 0 to 100. The default value is 100.
We all know - Changing the FILL FACTOR has impact on Read operation.
I have attached one script which has one table with 107 rows in and I tried different fillfactor on Clustered Index without specifying PAD index, and I got numeruos output. I know what could be the best option.
In this forum we will disucss expertise inputs. What could be the appropriate fill factor we can set in this case.
Thanks in advance.
Abhijit - http://abhijitmore.wordpress.com
February 1, 2011 at 5:52 am
There is a very good article which you could refer below which could cover your queries.
http://www.sqlmag.com/blogs/sql-server-questions-answered/sql-server-questions-answered/tabid/1977/entryid/13116/Default.aspx
M&M
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply