Index Optimize jobs question #615
-
|
With your solution, for nightly index/stats maintenance I was wondering is it better to have 1 job and pass in all the dbs you want to perform index maintenance on, or is it better to create multiple jobs with each just looking at one db. I would like to be able to run the index maintenance on multiple dbs in parallel so that they can all complete overnight in a 6 hour time window. If I was to do them sequentially it would take too long to complete. |
Beta Was this translation helpful? Give feedback.
Replies: 1 comment 1 reply
-
|
Make sure you are using the newest version of the solution and use the "DatabasesInParallel" parameter to let it do the work in parallel using the queue table to keep track.
|
Beta Was this translation helpful? Give feedback.
-
|
Thanks, yes I found this after I posted, and it is working perfectly. |
Beta Was this translation helpful? Give feedback.
Make sure you are using the newest version of the solution and use the "DatabasesInParallel" parameter to let it do the work in parallel using the queue table to keep track.