This is not about virtualisation of database servers. This is about the steps you should take before you consider if and how best to virtualise servers. When you are done with consolidation you have trimmed down your SQL Server farm to the optimum configuration and have the best possible starting point for virtualisation. If you have already virtualised your environment you can then consolidate your SQL Server instances.
The SQL Server Explosion
The number of databases using MS SQL Server has exploded since its launch of version 2005 . Its increased capability and reliability have made it the platform of choice for more critical enterprise applications, especially given the high fees and complex licensing of its Oracle competitor. Vendors typically recommend a dedicated SQL Server for their applications – often accompanied by excessive recommendations for size, functionality and performance, along with unique versioning and patching requirements. The unchecked growth resulting from these separate requirements, along with the associated need for additional test, development, and training servers results in a large, fragmented, and often unmanageable database environment.
This wasteful situation obviously leads to unnecessary hardware, licensing, and administrative costs. Without enough in-house database expertise you are stuck following application vendor recommendations. With the help of an experienced and competent SQL Server database administrator (DBA), however, you can take back control of your server environment through a series of specific tasks.
The first step, and probably the most crucial, is to establish all of the routines and processes necessary for collecting the relevant information and statistics about your systems. This information will serve as a basis for simulation, followed by the complete restructuring of the database environment. Restructuring consists of both consolidating necessary systems as well as phasing out redundant or unused servers. This step will have the largest impact on the final structure and function of your server environment, so it is critical that all relevant information be collected as precisely and accurately as possible.
In the next briefs I will discuss:
Implementing monitoring procedures.
Important factors when consolidating databases
Extracting relevant information for consolidation from activity- statistics
I have 150 SQL Servers, how many do I really need? How to simulate a new, optimal database environment