Microsoft® SQL Server™ 2005 Administrator's Companion

Scaling Up

Scaling up means maximizing the performance capabilities of your existing SQL Server 2005 instance’s hardware resources by adding more processors, memory, and storage capacity, or by replacing your existing hardware resources with faster versions.

Let’s examine these hardware subsystems and the options for scaling up their hardware resources. Be sure to purchase the appropriate hardware, operating system, and SQL Server 2005 edition to allow for future growth as your database solution’s requirements grow.

Processor Subsystem

Although most SQL Server instances are I/O-bound rather than compute-bound, scaling up your processor susbsystem generally results in better performance and allows for more capacity. There are a number of considerations ...