| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: SQL-Server Presentation/Reality Check
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).
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
 |
 |