Datasheet

Edition of SQL Server allows you to have high-availability options, Enterprise Edition far outdoes its
sister edition with higher-end clustering as well as more advance mirroring and log-shipping options.
The counter to this, of course, is the price. This edition of SQL Server will cost you more than $20,000 per
processor if you choose that licensing model. (We discuss licensing later in this chapter.)
The Evaluation Edition of SQL Server is a variant of SQL Server Enterprise Edition that expires after a
given time. After the allotted evaluation period, SQL Server will no longer start. The Developer Edition
of SQL Server allows you to run all the Enterprise Edition features in a development environment.
Neither of these editions is licensed for production use.
Operating System
The edition of SQL Server that you can install varies widely based on the operating system on your
server or workstation, as summarized in the following table.
Operating System SQL Express Workgroup Standard Developer Enterprise
Windows 2000 Professional
(with SP4+)
✓✓✓✓
Windows 2000 Server
(with SP4 +)
✓✓✓✓✓
Windows 2003 Server
(SP1+)
✓✓✓✓✓
Windows XP Home
Edition (with SP2+)
✓✓
Windows XP Professional
Edition (with SP2+)
✓✓✓✓✓
Maximum Capacity of SQL Server
Memory and the number of processors is a huge contributing factor when you’re scaling SQL Server. As
you can imagine, the amount of memory you can scale and the number of processors will vary based on
the edition of SQL Server you purchase. In some cases, your scalability is restricted only to the operating
system’s maximum memory or number of processors. This is where 64 bit becomes really useful. (We
cover 64-bit scalability much more in Chapter 15.)
Capacity SQL Express Workgroup Standard Enterprise
Memory Supported 32 bit 1GB 3GB OS Maximum OS Maximum
Memory Supported 64 bit N/A N/A OS Maximum OS Maximum
Maximum Database Size 4 GB No Limit No Limit No Limit
Number Processors 1 2 4 Non Limit
13
SQL Server 2005 Architecture
04_055200 ch01.qxp 10/31/06 12:37 PM Page 13