Posted by Serge Rielau on 02/07/06 15:31

Tony Rogerson wrote:
> Partitioning works fine, in fact, it helped SQL Server to become the first
> product to break then 1million TPS on the TPC benchmarks - google it.
Are you refering to TPC-C and TpmC? If so the first to break 1M was
Oracle http://www.tpc.org/tpcc/results/tpcc_result_detail.asp?id=103110401
The only > 1M result I see from MS is this one:
http://www.tpc.org/tpcc/results/tpcc_result_detail.asp?id=105112801

I do very much doubt that any vendor including SQL Server is using SMP
paralelism in the TPC-C benchmark because the load is driven by the high
number of concurrent users. SMP parallelism is mostly useful for low
concurrency enviroments (such as warehouses (TPC-H)).

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
DB2 UDB for Linux, Unix, Windows
IBM Toronto Lab

• Next in forum: Re: one for the SQL experts - dare I say TRICKY SQL!
• Prev in forum: Re: one for the SQL experts - dare I say TRICKY SQL!
• Thread view: Re: Views vs Stored Procedures, whats the difference?

[Reply to this message]