July 13, 2011 at 12:56 pm
Can SQL Server be certified if it is virtual? I'm assuming you get full support with SQL Server virtualized, right?
I've read about some performance limitations, but I assume that in some cases it's being used in enterprise production environments, correct?
Sorry, I've never used a virtualized SQL Server and I'm getting asked for quick response.
July 13, 2011 at 1:23 pm
At a previous job, we moved a SQL Server from a physical box to a virtual server. I was pleasantly surprised that performance didn't suffer. I had always heard that you didn't virutalize databases; but as VMs get better, it appears that no longer always holds true.
July 13, 2011 at 1:28 pm
rgtft (7/13/2011)
At a previous job, we moved a SQL Server from a physical box to a virtual server. I was pleasantly surprised that performance didn't suffer. I had always heard that you didn't virutalize databases; but as VMs get better, it appears that no longer always holds true.
I just read Brent Ozar's article on when you shouldn't virtualize and it sounds like it's basically in an intense, high octane environment. However, that article was 2009. Where I can find more recent practical limitations or does that still apply?
July 13, 2011 at 1:37 pm
In addition, I think the real underlying questions is whether Microsoft "certifies" certain configurations of VM and/or hardware configurations? In other words, can you make a VM environment that is not supported by MS? Where are the details on that?
July 13, 2011 at 1:43 pm
For any one int'd, here are the details of "certification":
July 13, 2011 at 1:54 pm
I think Brent's article is probably just as true today as it was in '09. While the hypervisors and other VM technologies get better the one constant which cannot really be controlled is that when you virtualize there are other machines trying to access the same resources and this will lead to eventual resource contention which is less of an issue when SQL is running on bare metal.
Don't get me wrong, I have no issue with SQL virtualization, provided you understand the implications. One of the nice things is that if the machine is under powered at the start you can usually add memory or processors fairly easily..
CEWII
July 13, 2011 at 5:12 pm
Pretty certain they will not certify if you are using VMware, but will if you are using virtual pc.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply