Q
Get started Bring yourself up to speed with our introductory content.

Virtualizing SQL Server 2000 and 2005

If you're thinking about virtualizing your SQL 2000 or 2005 servers, take a moment to read this expert response from Anil Desai.

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 migrating physical machines running SQL Server to virtual machines. What migration tools should I use? What are the pros and cons of using Microsoft Virtual Server rather than VMware for this project?

From a technical standpoint, it's certainly possible to run database server products (such as Microsoft SQL Server)...

within a VM (virtual machine). The first question I would ask, however, is whether you can consolidate your database servers without using virtualization.

Since a single SQL Server installation can support dozens of different databases, it might be more efficient to copy the databases rather than create new VMs. If you have good reasons to create VMs, the primary issues you're likely to run into are related to performance of CPU, memory and disk subsystems. Active database servers tend to tax these resources, and the overhead of virtualization can be noticeable in many cases.

It's a good idea to perform some load testing on those systems before moving forward. There are numerous physical-to-virtual (P2V) conversion tools available from Microsoft, VMware, PlateSpin and other vendors.

Regarding the virtualization platform (VMware vs. Microsoft), both should work fine. As it's difficult to recommend a product without complete technical details and testing, I suggest you evaluate your workload and management requirements by running SQL Server in each of them.

This was last published in August 2007

Dig Deeper on Server consolidation with virtualization

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchVMware

SearchWindowsServer

SearchCloudComputing

SearchVirtualDesktop

SearchDataCenter

Close