Running Microsoft SQL Server 2008 on the IBM System x3950 M2

An IBM Redpaper publication

This document is being moved!
In September 2015, this document will be moved to and will no longer be available on the IBM Redbooks site. Please bookmark the URL to access this specific document both today and after the migration in September.

Learn more


The IBM System x3950 M2 server provides extraordinary levels of scalability and processing power needed to run the most demanding enterprise database workloads. The x3950 M2 system is based on the fourth generation of IBM X-Architecture and is built on eX4 technology. As a scale-up platform, it offers unprecedented flexibility for supporting multi-node configurations using up to 96 processor cores.

The System x3950 M2 is the ultimate in scale-up design. Scale-up refers to the idea of increasing processing capacity by adding additional processors (and memory and I/O bandwidth) to a single server, making it more powerful. This is precisely what the x3950 M2 is designed to do: to scale up by adding chassis to a hardware partition to form two-node, four-node, and eight-node configurations. SQL Server 2008 is also designed for scale-up.

Thus, when your database application needs to scale-up to handle increased demands, the x3950 M2 and SQL Server 2008 together can grow from a one-node server to an enterprise-class four-node server with up to 96 processor cores and 1 TB of physical memory, which the 64-bit SQL Server 2008 x64 can take full advantage of.

This IBM Redbooks publication presents technical considerations and configuration examples for scaling up Microsoft SQL Server 2008 to support very high workloads.

Table of contents

Chapter 1. The IBM System x3950 M2 enterprise database server
Chapter 2. SQL Server 2008
Chapter 3. Platform synergy
Chapter 4. Configuration
Appendix A. Unattended Install


Publish Date
25 March 2009

Rating: Not yet rated


IBM Form Number

Number of pages