Virtualized SQL Setup

• dopydb

  SSCertifiable

  Points: 6687

  More actions

  April 8, 2010 at 2:52 am

  #139340

  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!

• dopydb

  SSCertifiable

  Points: 6687

  More actions

  April 8, 2010 at 6:08 am

  #1148171

  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!