Home » RDBMS Server » Performance Tuning » about add more cpus..
about add more cpus.. [message #261963] Fri, 24 August 2007 03:42 Go to next message
Messages: 8
Registered: July 2007
Junior Member
Dear All:
Our database version is 8.1.7 for IBM AIX5L,
we add cpus from 4 processor to 8 processor.
Does any parameter need to modify?

Re: about add more cpus.. [message #261968 is a reply to message #261963] Fri, 24 August 2007 04:01 Go to previous messageGo to next message
Michel Cadot
Messages: 65090
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Nothing to do if you didn't hard-code parallelism degree.

Take care that doubling the number of processors does not necessarily means halfing the response time, it can make things worse.


[Edit: one word missing]

[Updated on: Fri, 24 August 2007 06:13]

Report message to a moderator

Re: about add more cpus.. [message #261991 is a reply to message #261968] Fri, 24 August 2007 05:25 Go to previous message
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
It can make things MUCH worse.

Why are you increasing the number of processors?
Have you identified that you are currently CPU bound?
Previous Topic: Baby Tuning !!!
Goto Forum:

Current Time: Thu Jul 27 16:06:34 CDT 2017

Total time taken to generate the page: 0.10503 seconds