In light of some problems we’ve been having, I was hoping someone could give me some information on SAP running on servers with disk redundancy in place.
We have a HP ProLiant DL380 Gen9 server, which has 64GB or RAM and dual processors. It runs on Windows Server 2012 R2 and SQL Server 2012. The hard disks are all set up to use RAID-5 redundancy, and it has SAP Business One (SQL version) installed.
We’ve noticed that the performance has been extremely slow from day one, sometimes taking around 40 seconds plus to open a document (e.g. sales quotation). With this in mind we decided to dig a little deeper into the problem, and after searching on the web, the consensus of opinion seemed to advise on not using RAID-5 for running SAP installations, but using RAID-1 or RAID-10 instead.
Does anyone have any guidance on this, whether SAP should or shouldn’t be installed on servers with RAID-5 in place, or, if there is a problem with it, are there any recommended settings which should be observed on RAID controllers in general (cache size, etc.)?
Any help on this gratefully received.