Although I understand that Check DB automatically creates a database snapshot when running in multi-user mode?
Will the following solution require me to place the DB into single user mode?
Run DBCC CHECKDB in OFFLINE mode (WITH TABLOCK)
It doesn't *require* single user mode, but you must ensure that no one is using the database at all for the entire duration
I am restoring a previous backup of the DB in question (overwriting the current database files) to see if this resolves the issue. Obviously the data will be slightly outdated.
Highly unlikely to do anything other than lose data (by restoring to an earlier time). As the blog post stated, this is a resource problem.
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass