Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORACLE or SQL SERVER (MS) ?
Comments in-line
John Bell wrote:
>> Actually when it comes to lowend hardware, Oracle and MSSQL are
>>more of an even heat. Both can be deployed on meagre hardware if your
>>thruput requirements are similarly meagre.
>>
>>
>
>I would disagree with that, although I have not done any benchmarks, my
>experience of Oracle on the same windows platform is that SQL Server is that
>SQL server is the more performant. When you start looking at the User tools
>then Oracle with all the overhead and clunkiness of Java means that SQL
>Server wins on productivity and reliability too.
>
>I know there are good third party tools available that will level the score,
>and IMO the need for these with Oracle is higher!
>
Your experience is purely anecdotal. Other people's experience may well
differ. But one thing is definite
and that is that I can put either SQL Server or Oracle on a single CPU
Pentium machine and both will
run. But while SQL Server will only run on the Windows operating system
with Oracle an organization
has the choice to avoid paying hundreds of dollars for the operating
system, they can choose Linux, and
also avoid all of the problems with the huge number of Windows only
virus, worm, and trojan attacks.
>> Storage and memory requirements will be similar for both
>>products. You won't be able to get away with skimping on the disk
>>hardware just because it's a Microsoft database. OTOH, Oracle can run
>>on the same Dell/Compaq hardware that msSQL uses. Just run Linux
>>rather than Solaris.
>>
>>
>
>Oracle on Linux would be a good choice. Whether the poster would want to
>dual boot or buy another machine is different approach.
>
For a server dual boot would be pretty foolish. Servers are not supposed
to be rebooted.
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Wed Oct 22 2003 - 08:59:05 CDT