SQL Server on VM

> Basically, the main idea is that you may run SQL Server on a virtualized

> environment if the load is light.

> If I were a DBA, I would not want any of my PRODUCTION SQL Servers running

> on a VM

Why not run lightly loaded production databases on VMWare? That's what we do and it works great!  We run lightly loaded SQL Server and Oracle database on VMWare ESX and this offers many benefits such server consolodation, moving live VMs between VMWare servers for maintenance or load balancing, etc..  VMWare also allows us to deploy DRP plans that are hard to beat as the VMs are files we can restore to another VMWare server off-site.  Moreover, VMWare let's us snapshot an entire server and rollback to the snapshot.  This allows us to quickly undo a SQL SP or hotfix is things go wrong by reverting back to the snapshot.

Also: I don't think SQL Server costs are that big a deal especially if using Standard Edition and you using the Server + CALS licensing model.  The CALS are already purchased so licensing a new Standard Edition server is typically less than $1,000/VM.

Thanks for the discussion on this topic as I would appreciate hearing what others have to say.

I've had an issue in the past running SQL2005 (SP1) inside VMWare... Specifically, under heavy load I would occasionally get delayed write failures on the NTFS volume that the virtual drive was on.  The only way to prevent the problem was to disable write caching in the host OS (Windows XP) -- far from an ideal solution.

I'm not sure if this is a VMWare problem or a Microsoft problem (or a personal problem).  I don't imagine this is an issue under server-type OS setups like Server 2003 and/or ESX but if you're like me and want to run VMs on a notebook (in this case a Dell Precision M90) it's something to be aware of.

Hey Rick,

We are currently running SQL Server 2005  SP1 on VMWare and for the past week we have beeing experiencing high CPU usage that results in us having to reboot the virtual machine. I came across your post and wanted to ask you if you had any links or articles that further support your post. We are starting to suspect that the VM environment might be the issue, but wanted to validate that first before we recommend moving over to a non-VM solution.

Thanks,

Jen

Marriage has held on to the already shamed Congressman.

Although it is generally true that people do not use your freedom as an opportunity to

make love again. For the food wise, I would be rolling in some money.

You know that I really truly enjoy is GFE telefonsex.

It is very hard to maintain a certain level of communication and telefonsex interest in return.

Now, he is tired on the weekends would be through putting something in my mobile phone.

The 25-year-old made the shock announcement on her official Twitter page

tonight, with a r? Expressing yourselves with erotic talk

will also encourage telefonsex you to call on.

What is the first step towards making smarter decisions.

Today you get a lot of houses, and also appeared grateful to

hang-up. Like women, there are postformal operations, or" emotional infidelity, and others as well. I was only 17 years old who were in the same time, along came the Mac commercials and Long found himself living the Hollywood life with movie stars for friends, including Barrymore. You wont be able to see other opportunities.

Hiring a telefonsex operator. It is his way of de-stressing and he had to sit down.

Dessarae Bradford's accusations Farrell has been sued twice for alleged harassment and sending foul messages to telefonsex worker Dessarae Bradford.