Home Forums SQL Server 2005 Administering Index rebuild and fragmentation level RE: Index rebuild and fragmentation level
SQL_DBA_3
SSCarpal Tunnel
Points: 4772
More actions
November 6, 2008 at 3:27 pm
#895255
use DBCC SHOWCONTIG(tablename) WITH FAST .
This will not lock the table while execution and also gives you results quicker(in seconds).
Then check logical scan fragmentation .It should be less than 1% for an index which was just rebuilt.