March 18, 2010 at 1:51 am
Our institution is new to running virtual servers and SAN devices.
I know that an optimal installation of SQL will have the OS, the db and its log files, all on separate drives.
My question is this, does this make a difference in a virtual environment when the drives are virtual partitions spread across multiple physical drives that also host the the OS partition and the db partition on the same SAN device?
Should SQL 2005/8 be run on server hardware only and VM''s avoided? Why?
March 18, 2010 at 1:58 am
Should SQL 2005/8 be run on server hardware only and VM''s avoided?
I wouldnt say YES, or NO...but....
Depends on youre host (let's say ESX) you will be sharing resources with other VM's from a pool..
We recently moved to VM and found that our prod server runs much better on a physical than a VM.
You will need decent hardware assigned for each VM to avoid contention.
The disks should not be an issue...
This isnt a black and white situation...there's loads of grey...
testing....analysis.....planning....
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 18, 2010 at 10:48 am
Any suggestions on what to test and how? Scripts etc...
Our environment is:
Dell R710 running ESX Vshpere 4 with a 11TB storage capacity on a Equalogic 6000 SAN.
The LUN's are set by our staff with the device auto magically re-configuring the disks.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply