Virtualize SQL Server to Improve Availability

By ServerWatch Staff (Send Email)
Posted November 10, 2011

While some may not think it possible, the vast majority of SQL Server instances can be virtualized just like Microsoft Exchange Server and many other enterprise workloads. As reported in this Windows IT Pro article, the main advantage that virtualization offers is improved availability.


"There are several reasons to virtualize SQL Server. Certainly, in today’s tough economic climate, cost savings is a primary factor. Virtualization lets you run more server workloads on less hardware. Another reason behind the move to virtualize is power savings and improved hardware ROI. Consolidating workloads from multiple servers onto a single server drives up the hardware utilization rate, which for most single purpose servers account for only about 15 percent of utilization. This also reduces the number of physical servers and the overall power consumption. Having fewer servers also makes IT administration easier.

"All of these are certainly valid reasons to virtualize, but the main advantage that virtualization offers is improved availability. That might seem odd at first because when you virtualize servers, you’re running more servers on a single hardware platform, and therefore potentially have a single point of failure. Downtime on the virtual server can affect all of the virtual machines (VMs) that run on that server. However, in reality that’s actually a much smaller risk than a user or software error, which can bring down the SQL Server instance in the VM itself. User error and software failure are more common than hardware failure."

Read the Full "Reasons to Virtualize SQL Server" Story at Windows IT Pro

Page 1 of 1

Comment and Contribute

Your name/nickname

Your email

(Maximum characters: 1200). You have characters left.