RE: Slightly-OT: Throw HW at a SW/DB problem
Date: Mon, 27 Jun 2011 09:32:29 -0700
Message-ID: <D29F9902E534D5478F2E83FD6A44B3063B039D4F87_at_mail02.mba.xifin.com>
Faster CPU, more cores, more RAM, faster disks, SAME, all those do not help a poor design. Trust me from experience.
Is the bottleneck at IO or code or design?
Michael Dinh
NOTICE OF CONFIDENTIALITY - This material is intended for the use of the individual or entity to which it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable laws. BE FURTHER ADVISED THAT THIS EMAIL MAY CONTAIN PROTECTED HEALTH INFORMATION (PHI). BY ACCEPTING THIS MESSAGE, YOU ACKNOWLEDGE THE FOREGOING, AND AGREE AS FOLLOWS: YOU AGREE TO NOT DISCLOSE TO ANY THIRD PARTY ANY PHI CONTAINED HEREIN, EXCEPT AS EXPRESSLY PERMITTED AND ONLY TO THE EXTENT NECESSARY TO PERFORM YOUR OBLIGATIONS RELATING TO THE RECEIPT OF THIS MESSAGE. If the reader of this email (and attachments) is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. Please notify the sender of the error and delete the e-mail you received. Thank you.
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Niall Litchfield
Sent: Monday, June 27, 2011 8:22 AM
To: rjoralist2_at_society.servebeer.com
Cc: oracle-l_at_freelists.org
Subject: Re: Slightly-OT: Throw HW at a SW/DB problem
I'm not sure how many people are advocating hardware based tuning - but I do have some sympathy with what the guy is saying. We don't get to see what the tuning process was, but a quick triage might go along the lines of
"this problem workload currently does 10 million I/Os at 10ms each on average, that takes nearly all the 30 minutes elapsed time. If we hire an external guy at $1500 a day for a week then we think we can probably reduce that by half and understand our application better. Or we could pay $5000 for an SSD device and reduce the time taken by 80%."
Now obviously my numbers might be off, but I suspect they aren't off by enough to void the point that sometimes hardware outperforms expertise. The problem is of course all those times where the hardware doesn't out perform expertise. On Mon, Jun 27, 2011 at 3:45 PM, Rich Jesse <rjoralist2_at_society.servebeer.com<mailto:rjoralist2_at_society.servebeer.com>> wrote: I think I'm gonna be sick:
http://www.sqlmag.com/article/Performancetuning/ssds-performance-tuning-experts-milkman-139591
This mentality **in a database professional** completely escapes me. It brings to mind that I just "upgraded" my Blackberry to one that has 2x the CPU and 5x the RAM -- and still works just as bad as the one it replaced (if not worse).
Anyone from the Oracle camp advocating/predicting hardware-based "tuning"?
Rant over.
Rich
--
http://www.freelists.org/webpage/oracle-l
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jun 27 2011 - 11:32:29 CDT