Understanding the circumstances under which SQL Server creates a snapshot when running CHECKDB, I followed a link to this KB that states:
Database snapshots are available only in SQL Server Enterprise.
I'm trying to plan some maintenance work and need to understand potential I/O bottlenecks that could extend this maintenance window.
Does this snapshot limitation imply that running DBCC commands on SQL Server Standard SKUs will always run against the actual database, or is an internal snapshot still used?
Best Answer
You can refer to Paul Randal's blog (the guy who wrote DBCC CHECKDB) :
CHECKDB From Every Angle: Complete description of all CHECKDB stages :
As a side note, since you are using Standard edition,
DBCC CHECKDB
will not perform parallel checking of objects as opposed to Enterprise edition wherein it honors the MAXDOP setting configured for the server instance.Also, BOL has a clear writeup on CHECKDB Internal Database Snapshot