| different performance on old server [message #140605] |
Tue, 04 October 2005 23:02  |
mjschwenger
Messages: 137
Registered: July 2005
Location: US
|
Senior Member |
|
|
I do not know even if this is the right forum for this question but as I saw so much help, and it's a performance related, let me start...
In June 05I used an old server to run some performance benchmarks. Ora 10.1.0.4, AIX 5.2, client machines linux redhat 9. Running the application on 3 linux boxes, I was connecting to the database and benchmarking the performance by the # of inserts in a few tables, some application specific results like records into audit tables, etc. and CPU/memory utilization of the client machines and DB server. Today, using the same datasets, I started a new prformance testing on my old box as my new one was hardware broken... OK, the results were terrible! I run the same version of the app, on the same client linux machines, using the same datasets and the same DB server (no changes to the Ora install there have been made!) - everything is the same - or at least it looks the same - the results are twice lower. Systemwide, the differences were in the inserted records - 50% less inserts and the CPU on the client machines was abut 50% higher. I did check that no updates have been installed on the either of the 4 machines, no patches, etc. I tired to consult with my network admin but he said he has no clue - i have my results from June documented and we could see the huge difference.
I guess my question is what I can look at on the DB side... My statpack is almost similar to what we had before. I guess if there's a difference this will be between the clients and DB server, but how the DB server could to push the application to spin more??? I also tried to run the same app from the different client (4th linux machine)... the same results - then the network guys said it's difinately database problem...
I do not know where to start if the statpack is almost the same... I run even system stats... all other stats, etc... using the sniffer did not show anything useful...
Any idea is greatly appreciated.
Thanks a lot, mj
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
