I need a help with the one of parameter of DatabaseIntegrityCheck proc in Ola Hallengreen maintenace script. can anyone help me with @DatabaseInParallel parameter?
If you want to use @DatabaseInParallel, you would need to create multiple SQL Server Agent Jobs, with the exact same command, and that parameter set to 'Y'. If you do that, you will get the integrity checks done in parallel for as many databases as you have jobs.
If you have multiple jobs with the same schedule and NOT have this parameter set to 'Y', your jobs will attempt to run integrity checks on the same database from multiple jobs, which will most probably fail.
16 People are following this question.