Sample Header Ad - 728x90

Ola Hallengren's Parallel job processing - Maximum number of parallel jobs

-1 votes
0 answers
22 views
I've been working on running some of our SQL Agent Maintenance jobs using Ola Hallengren's scripts and they are fantastic. Thank you. Using parallel processing is my current focus, to reduce runtime. Our database sizes range from about 300GB to 3TB and over 200 in total. What would be the kind of maximum value of **n** that I should be looking at for running parallel jobs? I'm currently testing different values but just wonder if there's a maximum that it would not be advisable to go above?
Asked by PTL_SQL (431 rep)
Sep 18, 2025, 08:22 AM