Unanswered: Database storage considerations having 10 hdds ?
I must replace poor performing disks for my db2 sap database. Storage admin asigned 10 hdds from our corporate SAN (I mean I must decide in what RAID level disks will be configured(using SAN) ).
32 Gb RAM
I really must make the best out of these disks. So my thoughts are:
8 hdd's in RAID 5 for data
2 hdd's in RAID 1 for database logs.
10 hdd's in RAID 10 for data+logs
How does variant1 compares to variant2 ? Could I do better out of these 10 hdds ? Any suggestions ?
You should go for separate disks for the Logs if possible. That way it should be Var#1.
RAID-5 with SAN storage works great (DUAL-CORE). You should see significant performance Jump at your end. Do remember to Turn-on some key-performance variables in your database to get the best out of it. You can refer the "Best Practice guideline for Initial Cfg" from IBMDeveloperworks for that.