DBCC SHOWCONTIG & dm_db_index_physical_stats doc clarification request

Question

Hello,

Could I please request some clarification in BOL for DBCC SHOWCONTIG vs dm_db_index_physical_stats.  For full info, please refer to the following thread:
http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/8d01a374-1493-43c3-8cea-5bf5de723b4d?prof=required&ppud=4

In summary, DBCC SHOWCONTIG BOL states for Extent Scan Fragmentation: Percentage of out-of-order extents in scanning the leaf pages of an index. This number is not relevant to heaps. An out-of-order extent is one for which the extent that contains the current page for an index is not physically the next extent after the extent that contains the previous page for an index.

This would seem to be incorrect as it is Extent Scan Fragmentation that is used by the dm_db_index_physical_stats to indicate fragmentation level on a heap. 
It is Logical Scan fragmentation that is not relevant to heaps, not Extent Scan Fragmentation.

Cheers,
Rob

Answer 1

Hi Rob,
Thank you for reporting this issue.  We will investigate and update the topic as appropriate.

Kind regards,
Gail

---

Gail Erickson [MS] This posting is provided "AS IS" with no warranties, and confers no rights

Answer 2

Great, thanks Gail.