RE: How many of you use S.A.M.E?
- From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- To: <ax.mount@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 1 Feb 2007 15:47:34 -0700
I use S.A.M.E to some extent, but not blindly. It all depends on your
performance needs, available funds/hardware, OS, etc. If you have the
time and resources to fine tune for every type of I/O your database
performs and continually maintain such a configuration in order to get
an extra 5-10% performance boost, then go for it, but I prefer the
simplicity and generally very good peformance of of S.A.M.E. All my
systems have I/O times under 10ms, but that is of course a function of
how many spindles you stripe across, the amount of cache you have (for
the DB, the OS & the SAN), how many IOPS, etc. I prefer to spend my
time tuning the queries to reduce their I/O demands - that is by far
where you get the biggest ROI (unless you happen to have a very well
tuned application, which is quite rare).
Regards,
Brandon
Privileged/Confidential Information may be contained in this message or
attachments hereto. Please advise immediately if you or your employer do not
consent to Internet email for messages of this kind. Opinions, conclusions and
other information in this message that do not relate to the official business
of this company shall be understood as neither given nor endorsed by it.
Other related posts:
