DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2001


    Currently the parallel_max_servers is set at 28 for the databse which is on a 8 CPU box. The parallel servers seem quite busy and execution times are going up for some jobs. I am worndering about increasing parallel_max_servers. Is there a formula to kepp in mind for how high I can go for an 8 CPU machine? Thanks.

  2. #2
    Join Date
    Jun 2006
    A starting point would be 2*

    Some things to watch for when setting this and tuning:
    What are the CPU times is there a wait for cpu contention on the system?
    Are you staturating the I/O subsystem?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.