Software requirements
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:
|
Operating System
|
Enterprise Edition
|
Standard Edition
|
Personal Edition
|
Developer Edition
|
Desktop Engine
|
SQL Server CE
|
|
Windows CE
|
No
|
No
|
No
|
No
|
No
|
Yes
|
|
Windows 9x
|
No
|
No
|
Yes
|
No
|
Yes
|
No
|
|
Windows NT 4.0 Workstation with Service Pack 5
|
No
|
No
|
Yes
|
Yes
|
Yes
|
No
|
|
Windows NT 4.0 Server with Service Pack 5
|
Yes
|
Yes
|
Yes
|
Yes
|
Yes
|
No
|
|
Windows NT 4.0 Server Enterprise Edition with Service Pack 5
|
Yes
|
Yes
|
Yes
|
Yes
|
Yes
|
No
|
|
Windows 2000 Professional
|
No
|
No
|
Yes
|
Yes
|
Yes
|
No
|
|
Windows 2000 Server
|
Yes
|
Yes
|
Yes
|
Yes
|
Yes
|
No
|
|
Windows 2000 Advanced Server
|
Yes
|
Yes
|
Yes
|
Yes
|
Yes
|
No
|
|
Windows 2000 DataCenter
|
Yes
|
Yes
|
Yes
|
Yes
|
Yes
|
No
|
|
Windows XP Professional
|
No
|
No
|
Yes
|
Yes
|
Yes
|
No
|
DB2 Universal Database v8.1 comes in six editions:
DB2 Enterprise Server Edition (ESE)
DB2 Workgroup Server Edition (WSE)
DB2 Workgroup Server Unlimited Edition (WSUE)
DB2 Personal Edition (PE)
DB2 Universal Developer's Edition (UDE)
DB2 Personal Developer's Edition (PDE)
and requires the following software:
|
Platform
|
Operating System Version
|
Required Patches
|
|
Windows-based
|
Windows NT 4.0
|
Service Pack 6a or higher
|
|
Windows-based
|
Windows 2000
|
Service Pack 2 is required for
Windows Terminal Server
|
|
Windows-based
|
Windows XP
|
Not Necessary
|
|
AIX-Based
|
AIX 4.3.3 (32-bit)
|
Maintenance Level 9 or later, and
APARs IY22308, Y32690, and IY33024
|
|
AIX-Based
|
AIX 5L (32-bit)
|
Maintenance Level 2 or later
|
|
AIX-Based
|
AIX 5.1.0 (32-bit)
|
Maintenance Level 2 or later, and
APARs IY31254, IY32217, IY32905,
IY33023, and IY29345
|
|
AIX-Based
|
AIX 5.1.0 (64-bit)
|
Maintenance Level 2 or later, and
APARs IY31254, IY32217, IY32905,
Y33023, and IY32466
|
|
HP-UX
|
HP-UX 11i
|
December 2001 GOLDBASE11i,
December 2001 GOLDAPPS11i bundles
|
|
Linux
|
For Intel 32-bit:
kernel level 2.4.9 or later
glibc 2.2.4 or later
RPM 3 or later
For Intel 64-bit and z-Series:
Red Hat Linux 7.2
SuSE Linux SLES-7
|
Not Necessary
|
|
Sun Solaris
|
Solaris 7 (32-bit)
|
patch 106327-10
|
|
Sun Solaris
|
Solaris 7 (64-bit)
|
patch 106300-11
|
|
Sun Solaris
|
Solaris 8 (32-bit)
|
patch 108434-03 and 108528-12
|
|
Sun Solaris
|
Solaris 8 (64-bit)
|
patch 108435-03 and 108528-12
|
|
Sun Solaris
|
Solaris 9
|
Not Necessary
|
Performance comparison
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.
TPC tests
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.
» 
Comment and Contribute
