Friday, March 9, 2012

Is it better to run maintenance sequentially or pralell

we have a maintenance process which does various dbcc maintenance tasks such
as dbreindex, indexdefrag and updateusage. This process can take over 4
hours for some of the databases.
Is there any drawback to running these maintenance processes parallel on all
databases or is it better to run them sequentially?
Hi
There is no issue with running them in parallel, but, can your disk
subsystem keep up? These taks are very IO intensive.
If they run in parallel, the sum of all the jobs might decrease, but each
individual job will take longer to complete.
Regards
Mike
"DBA72" wrote:

> we have a maintenance process which does various dbcc maintenance tasks such
> as dbreindex, indexdefrag and updateusage. This process can take over 4
> hours for some of the databases.
> Is there any drawback to running these maintenance processes parallel on all
> databases or is it better to run them sequentially?

No comments:

Post a Comment