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 .Reducing capital and operating expenditure is one of the biggest factors driving companies to consolidate.
Consolidation plays an important role here in reducing the data center footprint.
Fewer computers and fewer idle machines result in lower power consumption and a reduced need for cooling.
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.
If you move applications onto newer hardware, those applications can take advantage of improved performance and reliability from the new machines, which can be better configured for high availability scenarios, reducing downtime and allowing for rolling upgrades.
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.
One of the important components in the IT environment is the database.
Databases tend to be very widespread across the enterprise, because they are very efficient for handling relational storage of data and are designed to be platforms for a wide variety of applications.
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.