A Comparison of SQL Server 2000 with DB2 v8.1 - Page 2
April 9, 2003
SQL Server 2000 comes in six editions: Enterprise, Standard, Personal, Developer, Desktop Engine, and SQL Server CE (a compatible version for Windows CE) and requires the following software:
DB2 Universal Database v8.1 comes in six editions:
and requires the following software:
It is very difficult to make a performance comparison between SQL Server 2000 and DB2 Universal Database v8.1. The performance of your databases depend rather on the experience of the database developers and database administrator, than on the database's provider. You can use both of these RDBMS to build stable and efficient systems. It is possible to define the typical transactions, such as those used in inventory control systems, airline reservation systems and banking systems. After defining these typical transactions, it is possible to run them under different database management systems working on the different hardware and software platforms.
The Transaction Processing Performance Council (TPC.Org) is an independent organization that specifies the typical transactions (transactions used in inventory control systems, airline reservation systems and banking systems) and some general rules these transactions should satisfy.
The TPC produces benchmarks that measure transaction processing and database performance in terms of how many transactions a given system and database can perform per unit of time, e.g., transactions per second or transactions per minute.
The TPC organization made the specification for many tests. There are TPC-C, TPC-H, TPC-R, TPC-W and some old tests, such as TPC-A, TPC-B and TPC-D. The most popular test is the TPC-C test (OLTP test).
At the moment this article was written, SQL Server 2000 held the top TPC-C by performance results with Distributed Partitioned Views-based cluster systems. See Top Ten TPC-C by Performance Version 5 Results
At the moment this article was written, SQL Server 2000 held the top TPC-C by price/performance results. See Top Ten TPC-C by Price/Performance Version 5 Results
Note. Because most organizations really do not run very large databases, the key points on which SQL Server 2000 won the TPC-C benchmarks do not really matter to the vast majority of companies.