Re: Limitations of MSSQL Server Vs. Oracle OR simply otherwise limitations in general - OT

On Tue, 23 Nov 2004 16:36:17 +0530, VIVEK_SHARMA <vivek_sharma_at_infosys.com> wrote:
> Folks
>
> Limitations of MSSQL Server Vs. Oracle OR simply otherwise General
> limitations of MSSQL Server.
>
> Need to give a presentation to Management on the same=20
>
> Any Good Links, docs etc?
>
> Thanks in advance

I've said before that I think SQL Server is really a rather good product now, unless your target is an application with one or both of very high concurrency or very high transaction rates. Usually of course your management will envisage that any applications they run are world leading in size,scale and importance and so suggesting that MSSQL is limited in terms of scalability or throughput compared with Oracle is a big minus against MSSQL.

There are however a number of important differences.

Read-consistency doesn't exist yet in MSSQL, except by virtue of locking things. It is scheduled for SQL2005 though (and I think it will be there - it is in the Beta). This means that readers block writers and vice versa. This in turn means a well written Oracle app will behave abysmally if just ported to MSSQL, it should be rewritten. You all have well written Oracle apps right? That use Oracle specific features a sensible transaction model, bind variables and all the rest?

If you are looking at Datawarehousing - Oracle's featureset is considerably in advance of Microsofts. The microsoft one rather benefits from ease of understanding and use though :(.

Lex makes an important point in his paper about the split of UNDO and REDO - its probably this 'feature' that single handledly limits the available throughput for MSSQL.

Rebuilding indexes is a highly recommended activity in this environment though so plenty of 'tuning' opportunities there.

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
--
http://www.freelists.org/webpage/oracle-l