Re: RAC High End Scalability?

Hi Michael,

setting up RAC successfully highly depends on whether or not the application can be partitioned into logical units (e.g. sales europe/asia/north america) or whether you run independent applications on the nodes (e.g. operational system and DWH).
If the nodes access (modify!) the same dataset frequently, RAC is not an option without an database/application redesign.

But if this is not possible, mssql isn't an option at all. This one literally relies on partitioning. The URL (http://www.microsoft.com/sql/evaluation/features/distpart.asp) mentioned in the documents reads:

The Distributed Partitioned Views feature shares the database-processing load across a group of servers,
 !!!! by horizontally partitioning the SQL Server 2000 data !!!!

in the first sentence.

It may be true that oracle does not scale well in some (a lot?) of scenarios, but I believe mssql to perform even worse.

BTW: TPC-C is partitioned horizontally by design.

Stephan

"Michael Harvey" <mgharvey_at_bigpond.com> wrote in message news:5b945v88h9rg40to39sab6cauio7r855gj_at_4ax.com...
>
> ORACLE make lots of claims about the scalability of RAC that I would
> like to believe.
>
> Microsoft recently (late last year) published a paper disputing some
> of these claims.
>
> http://www.microsoft.com/sql/evaluation/compare/RealityBehind_RAC.pdf
>
Received on Tue Feb 18 2003 - 08:31:15 CST