The possibilities for consolidating SQL Server are many and varied, and one of the key drivers for all of these is the cost of energy which curiously doesn’t seem to have fallen in line with the price of oil & gas.
Anyway I found this detailed whitepaper on how Microsoft applies the principles of sustainable IT as applied to SQL Server to its data centres. The numbers in this document are staggering - 5,000 instances of SQL Server providing over 100,000 databases, but what is more interesting is the drive to virtualise a lot of this while recognising that there will be some workloads more suitable than others.
There’s also a lot of tips that could well apply to other enterprises:
Most of this has come form the SQL CAT paper on best practices for running SQL Server on Hyper-V, so Microsoft does actually follow its own advice!
PingBack from http://energy.linkablez.info/2009/03/25/how-green-is-your-sql-server/