Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 SQL virtualisation

Author  Topic 

malraff
Starting Member

10 Posts

Posted - 2010-04-08 : 04:53:47
hi all

we will soon be virtualizing our SQL server and moving it to a SAN.

what i am worried about is configuring the virtualisation wrong so that the SAN disc subsystem is not utilised properly.

what i will be doing is breaking the 12 physical discs into 4 logical drives

c: 2 discs -raid 1 - os
D: 6 discs - raid 5 - databases
E 2 discs - raid 1 - logs
F 2 discs - raid 1 - Tempdb

regarding disc's D,E and F, do i simply map these to drive C. as i assume if these discs are setup as virtual drives the virtual machines disks are simply files stored on the file system and i will lose the benefit of the Raid setup?

can someone advise? all advice appreciated!

malraff
Starting Member

10 Posts

Posted - 2010-04-08 : 08:09:37
ok, from my research i think i will go with the following

1. From the SAN present several LUNS, one is VMFS for the OS and the rest as RDMs

LUN1 - RAID1 (VMFS Formatted)
LUN2 - RAID1 (RDM to SQL VM)
LUN3 - RAID1 (RDM to SQL VM)
LUN4 - RAID5 (RDM to SQL VM)

Then configure the VM as follows:

C:\ VMDK on LUN1
D:\ RDM to LUN4
E:\ RDM to LUN2
F:\ RDM to LUN3


any input appreciated!
Go to Top of Page
   

- Advertisement -