About this document

Debunking SQL Server Myths by renatoperson is a document available to read on EtoBox.

Myth #2: DBCC CHECKDB causes blocking because it takes locks by default. This myth is false. In SQL Server 2005 and later, DBCC CHECKDB was rewritten to use database snapshots, which provide a transactionally-consistent view of the database without taking any locks. This eliminates blocking that could occur from locks in earlier versions of SQL Server.

Author

renatoperson

Language

EN