Currently we are using hallengren for Database integrity (DBCC).
@Databases = 'USER_DATABASES',
@PhysicalOnly = 'Y',
@LogToTable = 'Y'
Which is working fine with no issue. taking 5 hours in prod envi. (Which is expected).
Is there any way i can reduce the executing time by dividing DBCC job or in someother way. so that i want only to run max 2 hrs.
Or any Microsft provided script which can improve?
This is SQL Server 2016 AlwaysOn (Primrary+Secondary)