SQL Server Benchmark Test

SQL Server Benchmark Test

How good is it?

SQL Server 2000 provides scaling capabilities for e-commerce, data warehousing, and business solutions. The following table summarizes the Benchmark Test Results of SQL Server 2000 under a variety of different applications and workloads. Of the 15 results listed, 9 are optimal on any platform and, regardless of operating system or hardware, all exceed the test results of Oracle, IBM, and other database vendors.

How fast is it?

SQL Server can process 2000 transactions per minute. SQL Server 2000 has further consolidated its position as the world's fastest database. The performance of a 32-node Compaq ProLiant DL760-900-256P system reaches 709,220 transactions per minute (tpmc) at $14.96 per tpmc, surpassing the original record of SQL Server 2000.
In the TPC-C performance list of the Transaction Processing Performance Board (TPC), SQL Server 2000 and Microsoft Windows 2000 accounted for the top three results. For more information about the new results, visit the TPC web site.

For more information, click the name of the application in the benchmark test. These benchmark tests fall into the following categories: industry standard testing, e-commerce, finance and Customer Relationship Management

Industry Standard Test

Workload/Application	Result	Best Platform
TPC-C (non-clustered result)	786,646 tpmc	Windows
TPC-W (item count 10,000)	21,139 wips	Any Platform
TPC-W (item count 100,000)	10,439 wips	Any Platform

E-commerce

Workload/Application	Result	Best Platform
Great Plains	2,400 concurrent users	Any Platform
SAP APO-DP (tier 2)	586,319 characteristic combinations/hr	Any Platform
SAP APO-DP (3-tier)	256,458 characteristic combinations/hr	Any Platform
Sap r/3 retail	3.165 million line items/hr	Any Platform
Sap r/3 sales & Distribution	26,000 concurrent users	Windows
SiebelEBusiness application suite	30,000 concurrent users	Windows

Finance

Workload/Application	Result	Best Platform
PeopleSoft ebill payment	191,694 payments per hour	Any Platform
PeopleSoft financials	13,000 concurrent users	Any Platform

Customer Relationship Management

Workload/Application	Result	Best Platform
Pivotal erelationship	20,000 concurrent users	Any Platform
PeopleSoft 8 CRM	30,000 concurrent users	Any Platform
PeopleSoft 8.4 CRM for services, sales and collaborative selling	25,200 concurrent users	Any Platform
Onyx	57,000 concurrent users	Any Platform