Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 page denisty

Author  Topic 

ruan4u
Posting Yak Master

132 Posts

Posted - 2005-05-23 : 08:59:54
Avg. Page Density (full).....................: 92.53%
What does this mean?

robvolk
Most Valuable Yak

15732 Posts

Posted - 2005-05-23 : 21:04:04
Books Online describes this output under DBCC SHOWCONTIG. In any event it seems pretty obvious (to me anyway) that, on average, your data pages for that table are 92% full, meaning that less than 8% of the space is unused.
Go to Top of Page
   

- Advertisement -