Parallel_max_servers
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Parallel_max_servers

  1. #1
    Join Date
    Jan 2001
    Posts
    138

    Parallel_max_servers

    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
    Posts
    259
    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