We help IT Professionals succeed at work.
Get Started

SQL Server running under VMWare

Last Modified: 2012-05-09

We are currently developing a very large data warehouse for local government to store information regarding Schools and Pupils. This database will, in addition to being a warehouse, contain an element of front end day to day use along side the slowly changing incremental warehouse data.

Currently the 3rd reich IT department here has decreed that we MUST have a virtualised server as that is the policy for all servers (eventhough we have paid for a full fat server out of or budget). There is currently no DBA in our IT department so they only think from the point of view of the machine and not data recovery, resilience, etc, etc...

I'm not asking if SQL server works on VMWare because I know it does, what I would really like to hear though is if there are any pitfalls and things I should look out for from a DBA point of view. I have already had some advise from other DBA's to say they would have real reservations implementing this as virtualised in a production environment, but what I am missing is some concrete reasons why. Personally, I would NOT like to see this virtualised, but the onus has been put on to us to proove that virtualising it is not a good idea.

Can anyone help me here or point me towards some research done by DBAs on virtualisation.
Watch Question
Top Expert 2010
This problem has been solved!
Unlock 3 Answers and 7 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE