I have a question that I hope you can answer for me. We're thinking of building a vSphere host that will support a demanding MS SQL Server. Cost is an issue so they want to use direct access storage in the server chassis. So here's the question...
Is it possible to use different Datastores (where each Datastore is made up of different physical drive arrays in the Host Server) as individual logical drives (C:\, D:\, E:\, F:\, G:\, etc) in this Guest MS SQL Server? I understand it's possible using iSCSI or FC SAN as RDM but I'm not sure if RDM is necessary or not.
e.g Here is the idea.
· vSphere to run from SD card on server. All disk is internal to the server.
For all other vSphere Guest Servers
RAID 6 Datastore 1 - Qty 6 10k 300G drives
For MAS 500 Guest Server
RAID 1 Datastore 2 - Qty 2 15k 300G drives
For Windows Server 2008R2 64-bit OS – System
C:\OS
For MS SQL Server 2008 R2 64-bit Application
For MS SQL Server (Temp, Model, Master, MSDB) Data & Log Files
RAID 10 (1+0) Datastore 3 - Qty 4 15k 300G drives
For MS SQL Server User (MAS 500 Databases) –
D:\MS SQL Server System
RAID 1 Datastore 4 - Qty 2 15k 300G drives
For MS SQL Server (MAS 500 Database Log Files = 120G) –
F:\MS SQL Server User
RAID 1 Datastore 5 - Qty 2 15k 300G drives
For MS SQL Server (TempDB Files) Data & Log files –
G:\MS SQL Server TempDB Files
Any thoughts?