Friday, March 30, 2012

MS SQL Vs ORACLE

I am looking for comparisons between these 2 RDBMS , in
terms of preformance and advenatges vs disadvantages.
Can some one direct me to the resourse / link etc ?Hi Suri.
Many "comparisons" are often one-sided attempts to demonstrate one being
superior in one way or another over the other. This one seems fairly
balanced though:
http://www.dbasupport.com/oracle/ora9i/SQLServer_compare.shtml
Regards,
Greg Linwood
SQL Server MVP
"Suri" <suryakant_shaha@.hotmail.com> wrote in message
news:037401c3afb1$8950ec40$a401280a@.phx.gbl...
> I am looking for comparisons between these 2 RDBMS , in
> terms of preformance and advenatges vs disadvantages.
> Can some one direct me to the resourse / link etc ?
>|||Thanks Greg Linwood
>--Original Message--
>Hi Suri.
>Many "comparisons" are often one-sided attempts to
demonstrate one being
>superior in one way or another over the other. This one
seems fairly
>balanced though:
>http://www.dbasupport.com/oracle/ora9i/SQLServer_compare.s
html
>Regards,
>Greg Linwood
>SQL Server MVP
>"Suri" <suryakant_shaha@.hotmail.com> wrote in message
>news:037401c3afb1$8950ec40$a401280a@.phx.gbl...
>> I am looking for comparisons between these 2 RDBMS , in
>> terms of preformance and advenatges vs disadvantages.
>> Can some one direct me to the resourse / link etc ?
>
>.
>|||Not a bad review but not the whole story. Oracle costs =0A=become better if you are licensing per user rather than =0A=per proc. Also not that in Oracle readers to not block =0A=writers and vice versa. This can lead to better =0A=performance when you are running oltp and dss against the =0A=same database. Also if you go to tpc.org check out the =0A=non-clusterred results. Unix hardware generally scales =0A=vertically much better. Also look at the tpc-h =0A=benchmarks, SQL Server only plays at the shallow end of =0A=the pool. =0A=>--Original Message-- =0A=>Hi Suri. =0A=> =0A=>Many "comparisons" are often one-sided attempts to =0A=demonstrate one being =0A=>superior in one way or another over the other. This one =0A=seems fairly =0A=>balanced though: =0A=> =0A=>http://www.dbasupport.com/oracle/ora9i/=0A=
SQLServer_compare.shtml =0A=> =0A=>Regards, =0A=>Greg Linwood =0A=>SQL Server MVP =0A=> =0A=>"Suri" <suryakant_shaha@.hotmail.com> wrote in message =0A=>news:037401c3afb1$8950ec40$a401280a@.phx.gbl... =0A=>> I am looking for comparisons between these 2 RDBMS , =0A=in =0A=>> terms of preformance and advenatges vs disadvantages. =0A=>> Can some one direct me to the resourse / link etc ? =0A=>> =0A=> =0A=> =0A=>. =0A=>|||Dear Anonymous
1. Expense - SQL Server is cheaper up to 3000 gb source
Transaction Processing Council.
http://www.tpc.org/tpch/results/tpch_price_perf_results.asp
2. Speed, yes for OLAP transactions Oracle is faster
http://www.tpc.org/tpcc/results/tpcc_results.asp?
orderby=hardware
3. E-Commerce however SQL Server is much faster
http://www.tpc.org/tpcw/results/tpcw_results.asp?
orderby=hardware
Secondly your comment that 'SQL Server only plays at the
shallow end of the pool' for tpc-h applications is
misleading. If you check comparatble hardware i.e. non
Unix than SQL Server is faster, and is easily the second
fastest on the board.
The following article has more details than the link posted
http://www.dbasupport.com/oracle/ora9i/SQLServer_compare2.s
html
Please note the conclusion.
Peter
>--Original Message--
>Not a bad review but not the whole story. Oracle costs
>become better if you are licensing per user rather than
>per proc. Also not that in Oracle readers to not block
>writers and vice versa. This can lead to better
>performance when you are running oltp and dss against the
>same database. Also if you go to tpc.org check out the
>non-clusterred results. Unix hardware generally scales
>vertically much better. Also look at the tpc-h
>benchmarks, SQL Server only plays at the shallow end of
>the pool.
>>--Original Message--
>>Hi Suri.
>>Many "comparisons" are often one-sided attempts to
>demonstrate one being
>>superior in one way or another over the other. This one
>seems fairly
>>balanced though:
>>http://www.dbasupport.com/oracle/ora9i/
>SQLServer_compare.shtml
>>Regards,
>>Greg Linwood
>>SQL Server MVP
>>"Suri" <suryakant_shaha@.hotmail.com> wrote in message
>>news:037401c3afb1$8950ec40$a401280a@.phx.gbl...
>> I am looking for comparisons between these 2 RDBMS ,
>in
>> terms of preformance and advenatges vs disadvantages.
>> Can some one direct me to the resourse / link etc ?
>>
>>.
>.
>

No comments:

Post a Comment