Note: This is an old article, and while Pit Bulls, in general, have remained largely the same in the meantime (although Gerald in particular has a very distinguished grey face now), SQL Server licensing for virtualized platforms has changed dramatically. For more information on the current licensing requirements see the SQL 2012 Licensing Guide, or consult your Microsoft Rep.
These days, I think a lot about both SQL Server Virtualization and Pit Bulls. They’re partly on my mind because they‘re two of my favorite things, and partly because both get a lot of unjustified bad press. I'll admit that in both cases, I can be a little biased. I may have already tipped my hand by playing the "favorite" card. You can probably hear the pit bull snoring on my feet from wherever you are, and my constant posts on Virtualization probably don‘t help hide my feelings about virtualizing SQL – so it’s pretty obvious which side of the debate I’m on. In my environment, we've gone so far down the virtualization road, and gotten so much out of it, that it's sometimes hard to understand why opportunities for virtualization would be passed up. However, a couple of months ago at SQLPASS, I had a bunch of conversations with people who had thought a whole lot about virtualizing SQL and had decided for very good reasons, that it wasn't an appropriate solution. This got me thinking about…
Things everyone should put thought into before Virtualizing SQL Server’s underlying OS, or adopting a Pit Bull -- a Several Part Series (now with 100% more comics – thanks Lisa!).
1. Find out if you're even allowed to do it, and if you are, license properly:
Pit Bull: Some home insurance carriers won't insure your home if you adopt a pit bull. Some cities have Breed Specific Legislation outlawing pit bull ownership. If you rent, some landlords don't allow it. Some states and/or Insurance companies require additional liability insurance if you own a pit bull type dog. You need to know if any of these apply to you.
Virtualized SQL Server: Before Virtualing SQL, it's very important to find out what licensing you'll need, whether consolidating onto a virtual platform will be cost effective, and whether your management will be amenable to the idea. To be allowed unlimited virtual machines on a fully socket licensed box you need to be licensed first for Windows (Datacenter), and second for SQL Server. For SQL 2005 through 2008 R0, unlimited virtualization requires SQL Server Enterprise socket licensing. For SQL 2008 R2 and up, Datacenter is required (in some cases, Enterprise is grandfathered under an ELA, but your Microsoft Rep will have to explicitly tell you if you’re grandfathered). If your virtualization platform is not Hyper-V, you also need to be fully socket licensed for your virtualization platform. Note: As of the release of 2012, SQL Server licensing for virtualized platforms has changed dramatically. For more information on the current licensing requirements see the SQL 2012 Licensing Guide, or consult your Microsoft Rep.
While Microsoft fully supports SQL on any virtualization platform that is validated through SVVP, not all application vendors support their application back end being on virtualized SQL -- this is becoming less and less common. As a side note, Oracle does support virtualizing the operating system on Oracle Enterprise Linux, but no other virtualization platforms are supported. This post doesn’t address Oracle, but if you’re looking at virtualizing Oracle, read their support statements carefully.
2. Realize that adoption will take longer
Pit Bull: I'll call our example pit bull Gerald the Gentleman. It took Gerald six months to get adopted. Some great folks at a shelter saw what a special fella he was, and worked with him to find a home. Everyone who met him agreed he was a great dog, but that didn’t get him adopted. Gerald started to get discouraged, and he started to look sad (see fig. 1). The folks at the shelter knew he was too good for the right home to pass up, and that once the right home came along it would be Gerald‘s time to shine. Now he's a rockstar, he can't help but win over everyone he meets (he had surgery recently and it was touch and go whether the Vet’s office would give him back, given that he is such a charmer). It took time to find him a home, and he had to win over the people who would take him home, but these days, Gerald's a big goofy social butterfly, and has a dorky dance to show you just how happy he is. A few years later now, and he's not allowed to do the Gerald dance anymore, he's an old man and threw his back out getting over-enthusiastic to Brit-Pop (why Brit-Pop? I guess we'll never know).