Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: SQL-Server Presentation/Reality Check

RE: SQL-Server Presentation/Reality Check

From: Post, Ethan <epost_at_kcc.com>
Date: Wed, 27 Jun 2001 13:34:45 -0700
Message-ID: <F001.0033ADFD.20010627133431@fatcity.com>

Can you provide some references to lack of support of read-consistency. Not that I don't believe you but I just read that to a guy next to me and he is clamoring for evidence. - E

-----Original Message-----
Sent: Wednesday, June 27, 2001 2:07 PM
To: Multiple recipients of list ORACLE-L

Privilege ? Reality? Reality and MS is an oxymoron. I've had the fortune (misfortune) to become a SQL Server DBA in addition to my Oracle duties, due to packaged application requirements. As an admitted defiler of all MS stands for and it's dubious accomplishments, I'll offer a few grains of sand, most of which you might be advised to take up with management away from the MS marketing morons.

First, be aware that MS pricing is not nearly as inexpensive as their hype would have you believe, once you remember that they have always charged for upgrades, their discounts aren't usually as steep, and support... well, what there is of it s****. I've spent 3 calls at $245.00 each only to be told each time the answer was to 'reboot'. This on W2K/SS2K fail-over cluster, with many of their best support people contributing to this non-solution.

On a technical note: Virtually every one of their new speed marks of note have been done on multi-server clusters; Oracle still holds most single-server benchmarks. Additionally, their application benchmarks have no relationship to real world, as even their SAP benchmark was done on a modified SAP installation not available in 'ordinary' SAP applications. The overhead of multi-server/cluster management makes their scalability arguments, even if they could be accommodated by existing software, moot.

Self-Tuning - Bah, Humbug. I've had the opportunity to see some server code from SAP, PeopleSoft and Commerce One designed for SQL Server. Guess what ? The real stuff, that which has to perform, is often hinted (statements like 'option (loop join , force order, maxdop 1 )' which is pretty much self explanatory; 'maxdop 1' = Oracle's noparallel.)

Then there's the entire discussion of read-consistency, which SQL Server doesn't support. A whole thread there, and one reason why SQL Server can be very quick in some operations: No RBS to support. Everything is done from the transaction logs.

And then there's functionality...

Just my 2 cents...

Ed Maurer
Sr. DBA
Acquirex

also send the HELP command for other information (like subscribing).



This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Post, Ethan
  INET: epost_at_kcc.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). Received on Wed Jun 27 2001 - 15:34:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US