Tuesday, January 26, 2010

SQL Server, a great workload for Hyper-V?

People ask me what are good candidates for Virtualization, and can Hpyer-V really run those heavy workloads. I tell them, that with Windows Server 2008 R2 Hyper-V, almost all workloads are candidates, and when you couple Hyper-V with the great management you get with System Center, you have a great infrastructure platform for virtualization.

Yesterday, Vipul Shah, a Senior Product Manager with the Virtualization Team, showed some proof to my statements when he guest posted on Virtualization Planet about how Windows Server 2008 R2 Hyper-V and System Center is a great platform for running SQL Server consolidated workloads. He pointed to a newly released video by Ted Kummert, Senior Vice President, Microsoft Business Platform Division that outlines how virtualization enables consolidation.

This is exciting as we ran some performance tests against a complex stock trading application using a machine with Second Level Address Translation (SLAT) and saw good performance throughout the tests. We recently discussed in the Best Practices for SQL Server Virtualization webcast (click here) and in the SQL Server Consolidation Guidance (click here) the results of those tests, and guidance on running SQL as a virtual machine.

Other Business Critical Applications like Microsoft Exchange and Microsoft SharePoint are also fantastic workloads to be consolidated.

It is good to see this information getting out there. Thoughts?

Kenon

1 comment:

Christian Dam said...

Intesting indeed!

Can you elaborate on why you think SharePoint is not only a good canditate to virtualize but in fact a fantastic candidate?

In many situations, the normal advice is to be very careful virtualizing SharePoint - especially the Index server role as well as the database role, although I am happy to see that might be changing with SQL Server 2008 R2. Why is SQL Server 2008 R2 changing that?