Issues with virtualizing SQL Server 2000 and 2005

Issues with virtualizing SQL Server 2000 and 2005

I'm thinking of consolidating several physical machines running SQL Server 2000 and 2005 to virtual machines. I would like to know to what issues I should look out for when passing P2V machines running SQL Server.

    Requires Free Membership to View

    When you register, my team of editors will also send you the latest expert resources covering all areas of server virtualization, such as platforms, architectures and strategies, server hardware, managing virtual environments, application issues and more.

    Margie Semilof, Editorial Director

    By submitting your registration information to SearchServerVirtualization.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchServerVirtualization.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

There's several issues that come to mind. The first and most important is parallelizing the storage: Whenever possible, it helps to place each virtualized disk on its own physical spindle to reduce contention. Also, depending on the amount of network traffic to and from these SQL boxes, you may want to try and dedicate a single physical network interface to each VM whenever possible. If you think you can get away with putting everything on a single gigabit Ethernet connection, try it -- just be mindful of what you're doing.

Note that if these are machines that don't get a lot of traffic or utilization and you're merging them mostly for the sake of legacy support (i.e., they're going to be phased out or discontinued at some point), you can often get away with more resource sharing (e.g., multiple virtual discs on one physical disc), but again, the mileage will vary heavily depending on the actual usage.

This was first published in August 2007