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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy