Extent Fragmentation on indexes

KYDutchieKYDutchie Member Posts: 345
edited 2014-06-27 in SQL Performance
Hi all,

I have a question on the extent fragmentation. How can I get the percentage of extent fragmentation down?
For example I have an Index on the G/L Entry table ($4) , logical fragmentation 0%, Extent fragmentation 27.27%.
When I do a rebuild on the index the number remains the same. So I tried to drop the index and create it again. Then the fragmentation goes up to 56%.
But when I do rebuild it again, the fragmentation goes back to 27.27%

How severely does the extent fragmentation influence performance?

Thanks in advance for any suggestions,



Fostering a homeless, abused child is the hardest yet most rewarding thing I have ever done.


Sign In or Register to comment.