关于avg_fragmentation_in_percent ，可以参考这里更加权威的解释http://connect.microsoft.com/SQLServer/feedback/details/690672/avg-fragmentation-in-percent-is-not-precise#detailsThanks for contacting SQL Server team with your question. As seen by you, the SQL Server does not consider data to be fragmented if the extents are not logically contiguous. In other words, if the two logically adjacent pages in an index correspont to the last page in extent X and the first page of extent Y respectively, SQL Server does not consider this to be fragmented. Suppose you rebuild an index on a filegroup that has multiple objects, it is unlikel that you will get physically contiguos extents. show extent fragementation for HEAPs but not for indexes.However, you can use DBCC extentinfo command to look at the extents allocatd to the object. Wondering if you have read the blogs related to fragmentation. Here is the linkhttp://blogs.msdn.com/b/sqlserverstorageengine/archive/2008/03/01/example-data-fragmentation-with-insert-updates-measuring-it-and-fixing-it.aspxavg_fragmentation
关于avg_fragmentation_in_percent ，可以参考这里更加权威的解释http://connect.microsoft.com/SQLServer/feedback/details/690672/avg-fragmentation-in-percent-is-not-precise#detailsThanks for contacting SQL Server team with your question. As seen by you, the SQL Server does not consider data to be fragmented if the extents are not logically contiguous. In other words, if the two logically adjacent pages in an index correspont to the last page in extent X and the first page of extent Y respectively, SQL Server does not consider this to be fragmented. Suppose you rebuild an index on a filegroup that has multiple objects, it is unlikel that you will get physically contiguos extents. show extent fragementation for HEAPs but not for indexes.However, you can use DBCC extentinfo command to look at the extents allocatd to the object. Wondering if you have read the blogs related to fragmentation. Here is the linkhttp://blogs.msdn.com/b/sqlserverstorageengine/archive/2008/03/01/example-data-fragmentation-with-insert-updates-measuring-it-and-fixing-it.aspxavg_fragmentation
解决方案 »
免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货