Abstract
The xSeries 460 is the number one x86 scalable server in the industry. The combination of the x460 and Microsoft SQL Server 2005 creates a perfect match for addressing needs for more database performance. The x460 is an effective four-way server, but provides optimal scalability for those customers who need room to grow.
One of the key markets for the x460 is database applications such as SQL Server 2005 (“Yukon”) SQL Server can effectively take advantage of the 32 processors and 512 GB of RAM available with a large x460 solution, providing customers with the performance and scalability needed to address their complex database workload needs.
The x460 is an example of scale-up technology. With the x460, when customers want to increase the capacity of their server infrastructure, they can simply add nodes to the x460 to increase the number of CPUs and the amount of installed memory. The advantage of scaling up is simpler management and control.
This Redpaper describes how the "scale-up" features of the xSeries 460 and SQL Server 2005 are an ideal fit. The paper discusses the key features of each, including how the multi-node scalability is designed to ensure a near-linear scalability from a single-node four-way server all the way to an eight-node, 32-way complex. It also offers performance tuning advice directly from the IBM performance labs.
Table of Contents
Chapter 1. The x460 enterprise server
Chapter 2. SQL Server 2005
Chapter 3. Scalability and affinity
Chapter 4. Configuration
Related product families
Product families related to this document are the following: