question

Dnirmania avatar image
Dnirmania asked

Ola hallengreen - Database Integrity Check

Hi Everyone
I need a help with the one of parameter of DatabaseIntegrityCheck proc in Ola Hallengreen maintenace script. can anyone help me with @DatabaseInParallel parameter?

Thanks,

Dinesh

procedureparameter
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

What's your question? What do you need help with?


The documentation indicates you need to set up multiple jobs with the @DatabasesInParallel Parameter set to 'Y', and all the other paremeters set to the same value(s).

It appears that you need to set these jobs to all run off the same schedule.

If that's not working, then perhaps @Ola Hallengren himself could sort you out?

0 Likes 0 ·

1 Answer

·
Magnus Ahlkvist avatar image
Magnus Ahlkvist answered

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.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.