Can any one suggest
Is better to have multiple arrays or multiple partitions within the arrays?
while laying the SQL DB in SAN
following two case will help understand the issue in a better way
Lets assume - the database looks like -- DB1 , DB2, DB3 , DBlog
Case 1
Single Raid 5 array - with 4 LUN as separate drive letter for all each DB and log
Case 2
One Raid 1 & 3 Raid 5 array as 4 individual drive for each DB & Log file
Which option will give better result - consider all other param like FC / SAS / Disk RPM / Size etc same for both the case
Thanks
Arindam