Sample Header Ad - 728x90

Duration of DatabaseIntegrityCheck SQL Agent job

0 votes
0 answers
31 views
I am trying to estimate likely duration of the DatabaseIntegrityCheck SQL Agent job for our AG PROD environment based on its duration in the Test stand-alone environment and I would appreciate comments please, on my approach Total size (TB) of all dbs in TEST is 1TB using following script: select CONVERT(decimal(10,2), (sum(size * 8.00)/1024.00/1024.00/1024.00))as total_all_dbs_TB from master.sys.master_files The job takes about an hour in TEST. PROD total size using same script is about 48TB. Would I be correct to expect about 48hours (2 days) duration for the DatabaseIntegrityCheck job in PROD?
Asked by PTL_SQL (427 rep)
Jul 16, 2025, 08:46 AM