This week, Microsoft revamped pricing for SQL Server 2005 whereby “Enterprise Edition” customers can run unlimited instances of SQL Server within virtual machines of any denomination — VMware, Microsoft Virtual Server, etc… Compare this with SQL Server Standard Edition, which is licensed per physical or virtual processor.
At first blush, this seems like a pretty good deal, kind of like the unlimited virtualization with Windows Server 2003 Datacenter Edition. But the more I think about it, the more I wonder — just how many folks is this really pricing really going to affect? First of all, how many SQL Server instances would one need to run per host in order for this deal to make economic sense? More to the point, how many shops are really running databases in virtual machines? And even if they are, don’t virtualization best practices state that we need to mix up our workloads?
Anyway, these are just some preliminary thoughts. If you’re running databases within VMs — particularly big honking I/O intensive ones — leave a comment; I’m curious to hear about how it’s working out.