Placement of OS and SQL files on a RAID Arrays.
Posted on 2014-10-22
We are in process of setting up our SQL server which is clustered across 2 HP DL380p servers using a HP P2000 for the shared storage with 2 raid 10 (8 disks) arrays and raid 1 mirror (2 disks). We have created 3 LUNS (LUN10, 20, 30) and have created 4 separate VHDx files. 1. OS/SQL (LUN10) 2. MDF (LUN10) 3. LDF (LUN 20) 4. TempDB (LUN30)
LUN 10 is a RAID 10 array with 8 disks
LUN 20 is a RAID 10 array with 8 disks
LUN 30 is a RAID 10 array with 2 disks
My only concern is putting the OS and SQL install and Database files on the same LUN? Is this something that is not recommended or does it really not make a difference? They are separate VHDx files [OS / SQL Install VHD] and [MDF files VHD] but still reside on the same LUN with the same spindles. Do you recommend moving the OS to its own completely independent set of disks? I am guessing there will hardly be any activity on the (OS and SQL binary install VHDx) to justify its need for its own set of spindles? Can they share the same spindles as the MDF files?