Integrity checks are important on a regular basis to find out errors.
Even on servers involved in availability groups.
we can normally find out how long it took to run?
It is a known fact that dbcc checkdb use a great deal of resources.
So I have run it to one of my databases - 170 Gb size. with estimate only:
dbcc checkdb(DEV_My_Database) with estimateonly
It came out:
DBCC results for 'DEV_My_Database'. Estimated TEMPDB space (in KB) needed for CHECKDB on database DEV_My_Database = 44320313. DBCC execution completed. If DBCC printed error messages, contact your system administrator.
However, I never saw any extra usage of tempdb as everything seemed to fit in there for this purpose.
How can I work out the right usage of resources, including tempdb, for my dbcc?
