Extent Fragmentation on indexes

KYDutchie

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,

Regards,

Willy

Willy

kriki

I did some duckbingling and found these links:
https://decipherinfosys.wordpress.com/2008/06/10/dbcc-showcontig-and-extent-scan-fragmentation/
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/83848ef3-47f6-41bb-a068-d03c0527a82e/dbcc-showcontig-vs-dmdbphysicalindexstats-extent-fragmentation?forum=sqldatabaseengine
https://sqlblogging.wordpress.com/tag/extent-fragmentation/

In short : nothing to worry about.

KYDutchie

Thanks Kriki!

Regards,

Willy