Writers: Sung Hsueh, Antony Zhong, Madhan Arumugam Technical Reviewers: Claude Lorenson, Clifford Dibble, Lindsey Allen, Sambit Samal, Sethu Kalavakur, Prem Mehra, Sameer Tejani, Il-Sung Lee, Jack Richins, Brian Dewey, Mathew John, Jamie Reding, Jonathan Morrison, Omri Bahat, S Muralidhar, Haydn Richardson Editor: Beth Inghram Summary: The goal of this white paper is to provide a framework for choosing among virtualization, multi-database, and multi-instance consolidation strategies for SQL Server Database Engine OLTP applications by highlighting some of the key decision points based on technical analysis.Some foundational topics and terminology will be included to provide the basis for the discussion, because some terms or strategies might be worded differently in other papers.Reducing capital and operating expenditure is one of the biggest factors driving companies to consolidate.
Consolidation here either targets under-utilized machines or focuses on enabling consolidation by upgrading to newer machines to take advantage of higher performance and scalable growth.
Through application consolidation, hardware will run closer to capacity, reducing inefficiencies and allowing for fewer machines.
A study by Microsoft’s IT department found that consolidating onto new servers resulted in reducing power requirements by 3 million volt amps (with an added bonus of also providing a savings of $11 million a year in operating costs).
For more information, see the article Green IT in Practice ( This paper will focus on consolidation strategies for online transaction processing (OLTP) applications storing data in the SQL Server Database Engine.
it can be defined simply as reduce the number of physical SQL servers, by migrating/moving different SQL databases running on different servers into one high performance server machine.
Early in the process of a consolidation project, you will create a profile to help identify which applications are good candidates for consolidation.Because databases form the foundation of so many business systems, IT departments can easily lose control of the number of databases that need to be maintained, because each group may simply create their own database to solve a specific problem they may be experiencing.This leads to a proliferation of databases and machines running database instances also known as .Each of these strategies has different advantages and disadvantages related to security and compliance requirements, high availability and disaster recovery requirements, resource management benefits, level of consolidation density, and manageability tradeoffs.This paper will try to answer the following questions: Consolidation projects are typically started to achieve specific goals such as creating room for new servers or reducing operating expenditure.One additional consideration for consolidation is investing in building a long-term dynamic and power-aware IT infrastructure that allows for better control and flexibility of computing resources in terms of their placement, sizing, and overall utilization.