Consolidating Large Microsoft SQL Server Databases on the IBM System x3850 X5 with Microsoft Hyper-V

An IBM Redguide publication



Abstract

An increasing number of customers are adopting server consolidation these days to curb the growing cost of managing and maintaining their IT infrastructure growth. IT administrators are increasingly faced with physical servers that run at low utilization levels. With significant and recent developments in server virtualization technology, customers are looking to implement a server consolidation strategy. This strategy can help many IT administrators solve multiple challenges associated with rapid and uncontrolled data processing growth:


  • Maximize investment in server hardware
  • Respond rapidly to changing IT needs
  • Improve business continuity
  • Simplify administration
  • Save space and power

This IBM® Redguide™ publication is the second in a series of papers demonstrating Microsoft® SQL server consolidation using IBM System x® scale-up enterprise servers and IBM System Storage®. The first Redguide, Consolidation of Microsoft SQL Server Instances on the IBM System x3850 X5 with Microsoft Hyper-V, REDP-4661, highlighted consolidating large number of small SQL databases.

The proof of concept depicted in this paper demonstrates Microsoft SQL Server running in 16 virtual machines on a pair of clustered x3850 X5 servers with 256 GB memory on each physical server. Each virtual machine is configured with four virtual processors and 15 GB of memory. The ability of the x3850 X5 servers to be configured with up to 1 TB memory and 64 logical processors provides the flexibility to consolidate a larger number of high performance database virtual machines with up to four virtual processors, and 64 GB or memory in an HA environment.

Table of contents

Executive overview
Introduction
Advantages of Microsoft SQL Server Virtualization
Consolidation Components
Proof of Concept
Results
Recommendations
Summary



Profile

Publish Date
09 August 2010


Rating: Not yet rated


Author(s)

IBM Form Number
REDP-4690-00

Number of pages
16