| 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
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
-----Original Message-----
Sent: Wednesday, June 27, 2001 11:32 AM
To: Multiple recipients of list ORACLE-L
I have the privilege of being tasked to attend a SQL Server presentation to be conducted by Microsoft at our site. Our company's current take on SQL Server is that it's to be used only in the case where a packaged application
requires it, or when there are 'tactical' exceptions, while Oracle is viewed
as
being 'strategic'. However, given the 'challenges' with Oracle's new
pricing
methods, there is being given increased consideration to expanding SQL
Server's use.
Now, I know next to nothing about SQL Server, and while I would appreciate
the
opportunity to learn it, I don't want to go to the presentation and let the
MS marketing droids completely have their way, some reality checks need to
be presented.
So, what questions/issues/considerations should I raise during the
presentation?
TIA!
Jeff T
thomasje_at_tce.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ed Maurer
INET: EMaurer_at_acquirex.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 - 14:57:50 CDT
 |
 |