RE: Hardware performance Was: Does anyone run test win vs. linux and can share how muchfaster is linux than windows, please?
- From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- To: <john.kanagaraj@xxxxxxx>
- Date: Wed, 10 Aug 2005 12:15:17 -0700
Regardless of your OS, your I/O subsystem is MUCH more important to your
database performance than the OS is. This is also where you would see the
tremendous slowness of a badly written query - when you're running it on a slow
I/O system. If you run a bad query on super fast I/O, or on cached buffers,
then it might appear to perform just fine, but again, this is dependend on the
I/O speed - not the OS. I think the main differences to consider between
operating systems are stability, cost, manageability, in-house experience,
flexibility, compatibility, etc. - not performance.
Regards,
Brandon Allen
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of John Kanagaraj
Sent: Wednesday, August 10, 2005 12:05 PM
To: 'jkstill@xxxxxxxxx'; VerreyB@xxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx; 'Stephane Faroult'
Subject: Now: Hardware performance Was: Does anyone run test win vs. linux and
can share how muchfaster is linux than windows, please?
Actually, this makes an interesting topic.... Our very own Stephane Faroult
wrote an excellent article for SELECT Q2 '04 titled "How Hardware performance
translates into Oracle Performance". In it he showed how a *badly* written
query shows a tremendous increase in performance when the hardware is upgraded
while a well written query shows only marginal improvement when running on
better hardware... Now I am not invalidating Jared's tests, nor am I claiming
that Linux is better than Windows, but just pointing out that there could be a
different twist to this whole thing. Maybe Stephane can summarize the findings
here?
John Kanagaraj
_____
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Jared Still
Sent: Wednesday, August 10, 2005 7:22 AM
To: VerreyB@xxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Does anyone run test win vs. linux and can share how muchfaster is
linux than windows, please?
On 8/9/05, Billy Verreynne (JW) < VerreyB@xxxxxxxxxxxx> wrote:
Anyone that thinks that deploying Oracle on Linux will result in a
faster system than deploying Oracle on Windows on the same h/w
platform, is sorely mistaken.
Disagree.
I've run an application database on two nearly identical servers,
one running linux, one running windows.
These were not quite identical, as the windows box had more disk.
Both boxes had the same type of physical disks. The linux box
had 3 RAID1 volumes for everything.
The win32 box had dedicated RAID1 volumes for redo, RAID10
for data/index, separate RAID10 for archives.
Running the same data feeding the same application, the linux
box was noticably faster. No, I didn't measure it, it was not
important at the time.
The linux server was actually running 3 databases at the time.
As for the Perl script, run strace on it. It generates time() calls
a million times.
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
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:
