L3000 vs N4000

[Brian Abdallah_2]

We have a L3000, dual 550 cpu,
2.0gb ram, VA7100 Array attached. A N4000, single 750 cpu, 1.5gb ram. A oracle
customer tracking system was moved over to the L3000 recently. User's are stating that it is alot slower now than on the N Class. It takes
2-3 minutes to get a report vs
10 seconds. I am taking cpu and memory utilization stats via glance now.
Does anyone have any advice on what I should look for? What parameters to tune?
Is a dual 550 cpu better than a single 750 cpu. I thought the L3000 was a better model than the N4000 (it is only 1.5 years old) It also has more memory, 2gb vs 1.5gb.
Any other advise is much appreciated.
Thanks to all who contribute!

[Pete Randall]

Brian,

Quoting from A. Clay Stephenson in this thread:
http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x86408b82cc91d711abdc0090277a778c,00.html

"Databases typically are not CPU bound but rather I/O bound."

Where did the database reside when it was on the N4000?


Pete

[Massimo Bianchi]

Hi,

usually N-class are better, but from your config there should be not such difference.

Oracle consume a lot of CPU, so a faster CPU is better. But from 750 to 550 ...

A little list of checks:

- Are oracle file config the same (initSID.ora)?

- Is kernel well tuned, like source instance ?

- Is there also a new application on the server

- where there any changes ? Code, release, apps...

HTH,
Massimo

[Jeff Schussele]

Hi Brian,

You don't mention what type of disk susbsystem you have on the N. Oracle is generally more I/O intensive than CPU.
Also the lower RAM count can't help.
First thing I'd suggest is the kernel parms. Look at the L's parms & match the N to them. 2nd thing to do would be raise the RAM on the N to at least 2GB.
Actually the N class is generally faster than L mainly due to more & faster I/O slots. Also can hold more CPUs & memory.

HTH,
Jeff

[Leif Halvarsson_2]

Hi,
There should not be a such difference, something must be wrong. If two 550 processors is better then one 750 depends on the application but even if the application only uses one processor the difference should not be much greater then the difference in processor speed.

How about the disk system ? Disk system performance can have very big impact on databases .

[Ravi_8]

Hi,
L3000 is rp 5470 and N4000 is rp7400 models,
ofcourse there are differences between the two.

Databases(oracle)are not bound to CPU, rather they bound to I/O speed.

could u check the disk speed(10Krpm or 15K rpm)on each machine, propably L3000 has 10K rpm disks

[Michael Steele_2]

Real time measurements can be collected and pasted in with your next post:

sar -d 5 5
sar -u 5 5
sar -v 5 5
vmstat 5 5
swapinfo -tam