July 30, 2008 at 11:10 am
HI,
I have a SQL Server 05 running on a VM. I have a disk drive that has been logically (virtually) partitioned i.e. physically there is only one disk partition. So my questions are
1- Keeping data, Index & log files on different logical disk partitions will give any performance benefits?
2- Seperating the Data & Index file groups will give any performance benefits?
3- Creating multiple files in a File Group will give any performance benefit?
Thanks,
Usman
July 30, 2008 at 12:17 pm
Basically, the answer is No, No, and No.
Putting files and partitions on different drives is to get additional read and write heads from the physical disks that do not interfere with each other. So, if it is the same physical disk, you will not see any benefit.
In fact, VM does not necessarily put individual virtual drives near each other on the physical disk. So, by putting your partitions on different virtual drives you actually increase the chance that the drive heads will have to move farther between operations and essentially lose all control over being able to manage this happening.
Also, be careful. SQL Server support on VMWare is sketchy at best. You should look carefully at the licensing for SQL Server in ragards to virtual hardware environments.
July 30, 2008 at 1:05 pm
As Michael said: More likely to reduce performance than increase it in your case.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 2, 2008 at 12:57 pm
as stated in your case no.
if you were SAN based for instance for your VM storage then you could use different LUNs.
With regards to licensing if you licence your host for SQL enterprise on each cpu you are covered for unlimted VM's. Check the MS website for this info
http://www.microsoft.com/sql/howtobuy/faq.mspx
otherwise VM's are licensed per virtual cpu (makes sense to go for enterprise)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply