Home Forums SQL Server 2005 Administering Index rebuild and fragmentation level RE: Index rebuild and fragmentation level
Rajaa
SSC Enthusiast
Points: 183
More actions
November 6, 2008 at 2:09 pm
#895224
Yes it may slow down the performance, as it uses parallel sessions to execute the DBCC.
So execute it after peak hours. It took 5 mins in my system for the big table.
DBCC SHOWCONTIG (tablename)