SQL Server Performance

DBCC EXTENTINFO - unused pages in these extents (undocumented)

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Sep 4, 2007.

  1. Anonymous New Member

    When it comes to resolving table fragmentation, the basic checkout you perform is to run DBCC INDEXDEFRAG or even run DBCC DBREINDEX statements. As per the default configuraiton SQL Database Engine allocates a new extent to an allocation unit only when it cannot quickly find a page in an existing extent with sufficient space to hold the row being inserted. This allocation goes with extents on the filegroup using a proportional allocation algorithm, that means if that filegroup with multiple fils...(<a href="http://sqlserver-qa.net/blogs/tools/archive/2007/09/04/dbcc-extentinfo-unused-pages-in-these-extents-undocumented.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=1856" width="1" height="1">

Share This Page