MS SQL Server - does dbcc updateusage cause blocking ?

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

does dbcc updateusage cause blocking ?

Hassan

2005-06-30, 1:23 pm

Paul S Randal [MS]

2005-06-30, 8:23 pm

Yes - it takes a table S lock for the duration of the operation so will
block all writes.

--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine

This posting is provided "AS IS" with no warranties, and confers no rights.

"Hassan" <fatima_ja@hotmail.com> wrote in message
news:Ooty9JafFHA.3788@tk2msftngp13.phx.gbl...
>
>

Sponsored Links