March 3, 2005 at 10:43 am
I hope someone can answer this one? I am running DBCC SHOWCONTIG on a large table 77mil rows and it is locking up the table while the DBCC command executes. Is this normal? I am using the WITH FAST option and it's still locking up the table. Is it the size of the table that is affecting this.
Thanks in advance!
March 4, 2005 at 3:18 am
Do an sp_lock whilst running the showcontig. I bet with such a lareg table that it is taking a tablockx.
March 4, 2005 at 1:27 pm
the WITH FAST option improves the speed of the showcontig as it doesn't bother checking certain objects, however, you will still get severe locking.
The best way is to schedule this to run overnight at a time when the server is not accepting many connections.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply