Re: Microsoft destroys TPC-C records!

SQL Server 2000 achieved its impressive scores using a new feature called distributed partitioned views. This configuration let Microsoft physically distribute slices of a single table across multiple servers but logically access the table as an integrated whole. Microsoft calls this configuration a "federated database," a precursor to the 100 percent shared-nothing cluster architecture plans for Yukon (the version after SQL Server 2000). Microsoft spread the federated database across 12 Compaq servers, each running 8 CPUs for a combined total of 96 CPUs. The best Oracle score came on a single SMP-based IBM machine running 24 CPUs.

In comp.databases.sybase Rick Jones <foo_at_bar.baz.invalid> wrote:
> If someone can do a benchmark in a "shared nothing" manner (or perhaps
> a "shared hardly anything" manner) the benchmark becomes more about
> how many systems can you get your hands-on for the measurement than
> anything else, and it will tend to scale even if you link the nodes
> with lengths of wet string :)
 

> rick jones
> --
> these opinions are mine, all mine; HP might not want them anyway... :)
> feel free to email, OR post, but please do NOT do BOTH...
> my email address is raj in the cup.hp.com domain...
Received on Fri Mar 03 2000 - 00:00:00 CST