Understanding Processors and Memory Limits
Each SQL Server 2005 edition has different limits for the number of processors and amount of memory it supports. After you have completed sizing your environment as explained in Chapter 6, and have a reasonably accurate estimate of the number of processors and the amount of memory you will need in the database server, you should determine which SQL Server 2005 edition best fits your needs using the following tables.
Table 2-4 lists the maximum amount of memory supported by each of the SQL Server 2005 editions for both the 32-bit (IA-32) and the 64-bit (IA-64 and x64) platforms.
Table 2-4. Maximum Amount of Memory Supported
SQL Server 2005 Edition | Maximum Memory Supported (IA-32) | Maximum Memory Supported (IA-64 ... |
|---|
Get Microsoft® SQL Server™ 2005 Administrator's Companion now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
