O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required