Option to specify a location for the DBCC CHECKDB snapshot
When you run DBCC CHECKDB, by default the snapshot is stored on the same drive as the database data file(s).
It would be nice to be able to specify the location, if you have
- Faster drives elsewhere
- No space on the same hard drive
- Less I/O traffic elsewhere