Running Microsoft SQL Server 2008 on the IBM System x3950 M2

An IBM Redpaper publication



Abstract

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



Profile

Publish Date
25 March 2009


Rating: Not yet rated


Author(s)

IBM Form Number
REDP-4476-00

Number of pages
108