Dear Experts, I would like to know what would be the best time to run DBCC CHECKDB on production servers and how often should i run it. I have around 8 servers with total 150 databases,so restoring the prod backup to non prod servers and running DBCC CHECKDB on non prod servers will be a very big work.
i would run the DBCC CHECKDB if possible during the maintenance window and before taking a full/differential database backup. It does not really make sense to perform a backup of a corrupt database.
The DBCC CHECKDB goes to the whole database content and loads it step by step into memory and checks the integrity. During this period you might see that the page life expectancy is dropping (if the database are big). So the suggestion would be is to run it if possible during the time when no or fewer memory intensive queries are running.