Camillia
asked on
Would runnng dbcc showcontig lockup table?
I have a huge table, maybe 200 million rows, no clustered index. I want to see the fragmentation on it by running dbcc showcontig. Should I be doing this off hours? would it lock up that table? This is SQL Server 2000
try to use the option "FAST". Or, better, use sys.dm_db_index_physical_s tats (but don't know if it works in Sql 2000), with the "LIMITED" option.
ASKER
so it would lock up the table? this is sql 2000, what is "FAST" and i know it doesnt have that sys.dm_db_index_physical
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
so it locks the table.