For Best Application performance - HPE had published a list of applications and the RAID level / Read-ahead Cache Size / Cache Write Optimization for the MSA 2050/2052 Storage Arrays. For those not aware, the following list is a great guideline to configure the MSA Array depending on the application workloads.
Application RAID level Read-ahead cache size Cache write optimization
---------------------------------------------------------------------------------------------------------------------------------
Default 5 or 6 Adaptive Standard
High-Performance Computing 5 or 6 Adaptive Standard
Mail spooling 1 Adaptive Standard
NFS_Mirror 1 Adaptive Standard
Oracle_DSS 5 or 6 Adaptive Standard
Oracle_OLTP 5 or 6 Adaptive Standard
Oracle_OLTP_HA 10 Adaptive Standard
Random 1 1 Stripe Standard
Random 5 5 or 6 Stripe Standard
Sequential 5 or 6 Adaptive Standard
Sybase_DSS 5 or 6 Adaptive Standard
Sybase_OLTP 5 or 6 Adaptive Standard
Sybase_OLTP_HA 10 Adaptive Standard
Video streaming 1, 5, or 6 Adaptive Standard
Exchange database 5 for data; 10 for logs Adaptive Standard
SAP® 10 Adaptive Standard
SQL 5 for data; 10 for logs Adaptive Standard
----------------------------------------------------------------------------------------------------------------------------------------
* Adaptive read-ahead caching : This option enables adaptive read ahead, which allows the MSA controller to dynamically calculate the optimum read-ahead size for the current workload
* Stripe read-ahead caching : This option sets the read-ahead size to one stripe. The MSA controllers treat non-RAID and RAID 1 disk groups internally as if they have a stripe size of 512 KB, even though they are not striped.
I work for HPE
