Run DBCC CHECKDB WITH PHYSICAL_ONLY automatically in the background
When RAID controllers are idle, they automatically check the storage to make sure it's still okay. Why not SQL Server too?
Some of the pieces are there – for example, SQL Server already has the ability to watch for idle CPU times and run Agent jobs when it’s bored. For starters, that’d probably be good enough to save a lot of small businesses from heartache. For the databases over, say, 100GB, it’d be really awesome to have resumable physical_only corruption checking – tracking which pages have been checked (just like how the differential bitmap tracks page changes), with page activity reset when the page is changed (again, just like the differential bitmap.) This wouldn’t count the same as a real CHECKDB, which needs to do things like compare index contents – but it'd be a big improvement over what we have now in environments where folks just aren't aware that the onus for data integrity is on them, not SQL Server.
This aligns with our vision for improved manageability, particularly for VLDBs. Will consider for future development.
Olivier Ducruet commented
Yes please implement it
I 542nd this motion.
Jeff Moden commented
This is a great idea. Just one thing to add, though... please make it optional by database.
Norman Heyen commented
YES! This would be a great help in keeping data safe and being able to show management that best efforts were made. Being able to spread a DBCC CHECKDB across a couple of evenings for VLDBs would be awesome.
I support this recommandation
It will be amazing. I support this recommendation from Brent!
please put your info in
Joe Pelish commented
This would be AWESOME!
This would be great
Rob Mark commented
That would be a great feature. Of course this needs to be controllable by a DBA for that one server that is behaves incorrectly for. Maybe something more than disabling the job, like some parameters that say priorities for system databases or exclude / include specific databases.
John Lehew commented
This is even more important now that software RAID is replacing hardware RAID. I didn't notice Software RAID / Storage Spaces performing a background scan when the server was next to my desk in the morning when I arrived for the day.
So - is it going to be enabled for 2019?
Alex McRoberts commented
Yes please. Slow DBCC CheckDB can result in no DBCC CheckDB in VLDB's.
Donald Kolenda commented
Please, please, pretty please!
good information well done
John Zabroski commented
This would significantly aid Microsoft SQL Server competition with Amazon Aurora.
Kevin Riley commented
This is a must! First rule of a DBA and of a database engine is to PROTECT THE DATA.
Richard Armstrong-Finnerty commented
More no-brainers in a long list of SQL Server "Should have been built-in aeons ago" no-brainers.
Come on, Microsoft, look lively.
Sreekanth Bandarla commented
Resumable physical_only corruption checking sounds like an amazing idea! Voted.
Mötz Jensen commented
I believe it should be a standard feature.