July 15, 2013 at 2:23 am
Hi,
I am not sure why the index fragmentation for a particular index never decreases, even after rebuilding.
It is currently at 64% fragmented.
The index has the following information(PP = Per page):
Record Count | Fill Factor | NumberOfPages | AVG_Rows_PP | MIN_Rows_PP | MAX_Rows_PP
_______________________________________________________________________________________
59 959 800 | 100 | 148 122 | 404.8 | 404.8 | 404.8
Defined_Free_ Rows_PP | Actual_Free_Rows_PP
_____________________________________________
0 | 135.59
My Guess is that I need to decrease the Fill Factor to about 60, so that the Defined Free Rows > Actual Free Rows.
Is this something to worry about.
Any help will greatly be aprreciated.
Thanks.
July 15, 2013 at 2:35 am
No, you don't need to fiddle with the fill factor to rebuild an index.
Is it an index or is it a heap?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 15, 2013 at 2:40 am
GilaMonster (7/15/2013)
No, you don't need to fiddle with the fill factor to rebuild an index.Is it an index or is it a heap?
It is a NONCLUSTERED Index.
July 15, 2013 at 2:45 am
Autoshrink on? Manual shrink operations?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 15, 2013 at 2:57 am
GilaMonster (7/15/2013)
Autoshrink on? Manual shrink operations?
Autoshrink is off, we do INSERT and DELETE often in the database.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply