OK, timing is impeccable. My boss just got the Oracle Bill, new licensing model $40k per processor for web based apps and flipped. I have some MSCE's working here pushing him to switch to SQL*server. Does anyone know where I can find reasons to stay w/ Oracle? Some things already mentioned here, but the MSCE's would say this list is bias, go figure :)
Does SQLServer 2000 support blobs, row level locking, etc?
Thanks,
Gene
PS. Do I move on to another Oracle shop or switch to SQLserver? OMG, the thought of working only on windoze makes me puke. I know this answer!
>>> regdba_at_yahoo.com 04/05/02 14:11 PM >>>
There are some technical points worth considering.
For example, SQL Server does not have true row level
locking. It's table level locking, or some really
creative SQL to fake it. This has a direct impact on
scalability and performance.
- DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM> wrote:
> Oops, a couple of items I didn't make clear:
> - I was never able to compare the cost of Oracle
> support with the cost of
> Microsoft support. Oracle prices annual maintenance,
> which includes the
> right to upgrade to a new version of Oracle. MS
> prices out per incident or
> for all MS software at a location. If you can
> estimate the number of
> calls/month, then you could compare.
> - Oracle DBA salary vs. MS SQL DBA salary. I feel
> the difference is
> primarily due to less experience, training. I find
> it ironic that this
> probably causes less reliability for Microsoft
> (Microsoft has even
> complained that organizations don't assign their
> best people to administer
> MS products), yet then Microsoft brags about how you
> can save money because
> their people ar cheaper.
>
> -----Original Message-----
> Sent: Friday, April 05, 2002 11:14 AM
> To: Multiple recipients of list ORACLE-L
>
>
> I recently prepared a total cost comparison between
> Oracle and MS SQL. I
> appreciate the support several people on this list
> provided me. In return,
> here are some of the main points I learned.
> - For smaller systems, investigate whether Oracle
> Standard Edition will
> meet your requirements. For example, most people
> assume that to use
> replication, you need EE. For our purposes the basic
> replication that comes
> with SE was adequate.
> - Microsoft also offers SQL in both EE and SE
> versions. Thanks very much
> to Gints Plivna for providing me a
> feature-by-feature comparison between the
> different versions. MS SE is not equivalent to
> Oracle SE. In most cases, the
> more valid comparison is between MS SQL EE and
> Oracle SE.
> - For maintenance, there are two parts to
> consider: Upgrade privilege and
> support. Oracle bundles both of these together. Make
> sure Microsoft is
> priced with Software Assurance, which gives upgrade
> privilege. Microsoft
> prices support by the incident or by the location
> (all Microsoft software).
> I was never able to get a comparison.
> - MS SQL EE with Software Assurance is actually
> more expensive than Oracle
> SE. Priced by the CPU.
> - Since pricing is by CPU and RISC systems offer
> higher database
> performance (according to many people on this list)
> and Oracle offers higher
> performance in a head-to-head comparison (according
> to the recently
> published Eweek benchmark), I compared Oracle SE on
> a 1-CPU Sun box with MS
> SQL on a 2-CPU Intel box. The Intel box was cheaper,
> but those two CPUs
> really kill you on licensing! In my mind I am
> convinced that both setups
> could offer equivalent performance.
> - I was provided figures that the average DBA
> salary (including health,
> vacation, etc.) on Oracle is $85,000 and on MS SQL
> $68,500. A lading
> industry analyst stated that the main reason MS SQL
> sites have less
> reliability is because there are few processes to
> ensure high availability,
> high performance. Developing these processes in the
> MS SQL world is more
> trial-and-error while these are well-documented in
> the Oracle world. I would
> add that several authors that participate in this
> list have created that
> documentation.
>
> Dennis Williams
> DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.COM
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.COM
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Pete Barnett
Lead Database Administrator
The Regence Group
pnbarneregence.com
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Peter Barnett
INET: regdba_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gene Sais
INET: gsais_at_co.palm-beach.fl.us
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Fri Apr 05 2002 - 18:23:21 CST
