Đang chuẩn bị liên kết để tải về tài liệu:
Sybex - Mastering SQL Server 2008 (2009)02

Sybex - Mastering SQL Server 2008 (2009)02 | INSTALLING SQL SERVER 2008 13 situation where SQL Server could be starving other services. Of course this brings up the question of whether the SQL Servers are dedicated machines or share responsibilities for other services. This in turn will depend on projected server activity levels and the level of resource consumption. As you make these decisions remember that processor licensing is per socket not per core. The Real Cost of Affinity Remember that the processor affinity settings in SQL Server are very tightly integrated with the licensing system. Make sure that you don t use processor affinity settings that might violate your license agreements. When deciding on processor architecture you must also consider your memory requirements. Chapter 2 Understanding SQL Server Architecture will cover the specifics of memory configuration and how memory is used but for now remember that the primary difference between 32-bit and 64-bit processors is the amount of memory that is addressable by the processor. The 32-bit world limits the server to 4GB addressable memory only 2GB of which are available for SQL Server unless you use some special switches and creative manipulation. 64-bit processors significantly increase that limit. How much of an increase depends on the processor but theoretically it could extend to 16 exabytes. This is a theoretical limit only and all current 64-bit architectures implement limits that are a tiny fraction of this level averaging around 32GB of addressable memory. The real story then is not that 64-bit processors are faster. In fact dealing with a 64-bit address can actually cause a 64-bit processor to run slower than a comparable 32-bit processor. The real issues are the amount of memory that can be addressed and the convenience with which that memory can be addressed without special configuration on the part of the administrator. Memory Resources In order for data to be of any use in your applications in most cases it needs to be brought from