Antw: [suse-oracle] Bad performance on Proliant DL580 G4 2007-06-01 - By Ralf Dieterle
Back
Hi Herman,
We changed from HP DL 580 G3 to G4. Former CPU was XEON 3,66 GHz, now CoreDuo2
3,00 GHz. We changed only to
have more parallel CPU-Power with more cores.
So you should a have a closer look on what you want to achieve with this switch
to the new machine. We have
a high load always at the same times a day. Up to 50 running Processes at the
same time. With only 4 CPU's a
lot had to be queued. Now we have 4 DualCore = 8 CPU and HT for each Core makes
16 usable CPU's and the
highload times are gone.
The new CPU's seem to be exactly as fast as the old 3,66 ones. If you need more
speed for only one process,
you can either try to get a 30 GHz-CPU ( which ist still not available :-)) )
- or try to get your SQL's
running by using the "parallel-option".
Last but not least: Performance normally is not that easy to improve. Try to
find out what statspackreport
tell you to do or jump in the database and find miserably executed SQL's.
Perhaps you can help your
optimizer with some new/changed indexes.
Till then analyze all Indexes and tables - could be done online when
productiontime is not that heavy.....
Greetz
Ralf
Ralf Dieterle
-- ---- ---- ---- ---- ---- ---- --
Leitung KIS Systembetreuung
-- ---- ---- ---- ---- ---- ---- --
Vinzenz von Paul Kliniken gGmbH
Marienhospital Stuttgart
EDV
B?heimstr. 37
D - 70199 Stuttgart
-- ---- ---- ---- ---- ---- ---- --
Phone: (++49) (0) 711/6489-2974
FAX : (++49) (0) 711/6489-2985
mailto: RalfDieterle@(protected)
web: http://www.vinzenz.de/
-- ---- ---- ---- ---- ---- ---- --
Sitz: Stuttgart
Amtsgericht Stuttgart, HRB 18126
Gesch?ftsf?hrer: Dipl.-Volkswirtin Monika R?ther, Dipl.-Betriebswirt (FH)
Friedrich Heinzmann
-- ---- ---- ---- ---- ---- ---- --
>>> <Herman.Maseberg@(protected)> 28.05.2007 21:25 >>>
Hi, recently we migrated from IBM xSeries 445 Suse SLES 9 (32 bits) with 9
GB RAM to HP DL580 G4 SLES9 (AMD64/EM64T) with 16 GB RAM, in both cases
attached to a external FC storage (Hitachi AMS500) running SAP 4.7 on
Oracle 9.2.0.7.
In boths cases we use ext3 filesystems mounted with the writeback option.
After migration we don't see visible better performance and I suspect some
of the hardware components (HBA or ethernet cards) is responsible for the
unexpected performance.
The question is, anyone have the same servers or configuration and have
some tip to help us improve performance?
Thanks!
Herman Maseberg
Analista Sr. de Tecnolog?a
Loma Negra C.I.A.S.A.
Bouchard 680 - Torre Fortabat - Buenos Aires
Tel: (54-11)4319-3000 int. 3249
herman.maseberg@(protected)
.........................................................
Este mensaje, incluyendo sus anexos, contiene informaciones confidenciales
destinadas al individuo y prop?sito espec?ficos, y est? protegido por ley.
Caso no sea el usuario a quien est? dirigido, debe borrar este mensaje.
Est? terminantemente prohibida la utilizaci?n, el acceso, copia o
divulgaci?n no autorizada de las informaciones presentes en este mensaje.
Las informaciones contenidas en este mensaje y en sus anexos son de
responsabilidad de su autor, no representando ideas, opiniones,
pensamientos o cualquier forma de posicionamiento por parte del Grupo Loma
Negra.
Esta mensagem, incluindo os seus anexos, cont?m informa??es confidenciais
destinadas a indiv?duo e prop?sito espec?ficos, e ? protegida por lei.
Caso voc? n?o seja o citado indiv?duo, deve apagar esta mensagem.
? terminantemente proibida a utiliza??o, acesso, c?pia ou divulga??o n?o
autorizada das informa??es presentes nesta mensagem.
As informa??es contidas nesta mensagem e em seus anexos s?o de
responsabilidade de seu autor, n?o representando id?ias, opini?es,
pensamentos ou qualquer forma de posicionamento por parte do Grupo Loma
Negra.
The information contained in this communication is confidential, is law
protected, and is intended only for business use of the addressee. If you
have received this communication in error, please immediately delete it.
It's forbidden the unathorized use, access, copy or disclose of the
information contained in this communication.
The content of this message is responsability of the author, and does not
represent ideas, opinions, thoughts or any kind of statement of Loma Negra
Corporation.
--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
|
|
