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