Home Forums SQL Server 2008 SQL Server 2008 - General fragmentation in database RE: fragmentation in database
vikingDBA
SSCertifiable
Points: 5356
More actions
March 25, 2013 at 9:35 am
#1600373
Totally agree. Page count is the main one other than avg frag %.
I use > 30% and > 50 pages to rebuild. Less on either just gets a reorg.