chandan_jha18 (11/14/2012)

---

Hi Folks,

I am facing an issue which I thought I understood but looks like reading and implementing a strategy are very different.

I have a SQL 2008 running on a VM with Windows 2003 and having 8 logical processors and 64 GB of RAM.

When I login to the server I see that there are 4 logical drives : C,D,E and F

We are keeping data and log files spread across D,E and F.

Now, there are a number of times when perfmon or DMV information shows high contention on I\O.

So I owned up a task to plan to move data and log files separately.

now as per best practices we know that due to different nature of the writes on both the two files, they should be placed on separate drives and now this is the biggest hurdle I am facing.

Even though these drives look different to me when I login to the server but if they are logical drives and physically on the same storage, I do not think it will make much of a difference. So here are my questions:

1) A log of places it is written that both the files should be on separate logical drives so is it true that if both are logical but actually point to same location physically it will help in dealing with contention

2) If the scenario I described above is true and you agree that putting files on logical drive does not make much sense, what should be my next step then?

3) What should be my approach while communicating with Admin guys? Shall I ask them to provide me different physical disks or is there a way I can write them more effectively

Finally the lat question comes about RAIDS, how do I mention this while trying to justify need for a better storage architecture.

Thanks in advance. Your valuable suggestions are welcome.

Regards

Chandan Jha