Windows & SQL -- LUN / Partitioning best practices ?
Posted on 2008-11-12
Environment: Windows 2003 Ent, SQL 2005 standard, EMC CX320 FC.
I have a 2 node active/active SQL 2005 cluster. Our DBA has presented a table of the drive setups he wants as setup cluster resources.
This list contains 8 separate drives.
My question is related to best practice for lun presentation/carving.
The luns will be created across 2 RAID 1/0 RAID Groups, setup on the same spindles.
Is it better to create 8 luns and present a unique lun to the OS for single drive partitioning (per lun) or to present larger luns and create multiple partitions on them ?
Any advice is will be welcomed.