GilaMonster (1/22/2013)
ben.brugman (1/22/2013)
CheckDB effectively destroys the cache. (Why?).Because it reads every single allocated page in the database and, like all other operations, reads them through the buffer pool. Unless you happen to have a buffer pool far larger than the database, running CheckDB will throw just about all other pages out of the buffer pool as it runs.
So for checkDB you need a maintenance window, first because it uses resources, secondly because it potentially can 'destroy' performance for other queries.
Because the backup does not do that, I thought wrongly that checkDB would not do that either.
Thanks for setting me strait,
Ben Brugman