Virtualized SQL Setup

  • 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!

  • 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!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply