Why is running database integrity checks in parallel beneficial if you are following best practice on Enterprise Edition?
3
votes
2
answers
573
views
On Enterprise Edition and Development edition, database integrity checks (e.g.
DBCC CHECKDB
) can run in parallel. According to best practice, backups should be tested regularly. So if I'm following best practice, I would be regularly restoring my production Enterprise Edition box's backups on to a non-production Development edition box and running CHECKDB
there. This means that **I would never actually be running database integrity checks on my production Enterprise Edition box**. So, why is running database integrity checks in parallel beneficial if you are following best practice on Enterprise Edition?
The exception to this is system databases, but they're so tiny that running CHECKDB
in parallel is unlikely to matter.
Asked by J. Mini
(1225 rep)
Jan 15, 2025, 07:15 AM
Last activity: Feb 6, 2025, 11:00 AM
Last activity: Feb 6, 2025, 11:00 AM