Skip to Content
0
Dec 06, 2008 at 12:48 PM

SAP - on Windos with SQL DB

19 Views

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