Wednesday, June 7, 2023

How to check the stripes on the AWS HANA Database Server?

Striping the volumes helps to come over the limitations of the IOPS and throughput requirements on an EBS volume. It is always recommended to take advantage of performance improvement with the use of striped.


Pre-Read:-
Disk reads/sec + disk writes/sec = IOPS
Disk read bytes/sec + disk write bytes/sec = throughput

For example, if a single volume(/hana/data or /hana/log) has 250 MiB/s throughput capacity, having a stripe set across four volumes can deliver 250MiB*4 = 1000 MiB/s throughput. This will increase the read and write capacity which siginifcantly increases the performance of the HANA database. 
These four vloumes should be of same size and performance characterstics.

In SAP HANA benchmark testing, the best performance has been achieved using a 256 KB stripe size for data volumes and a 64 KB stripe size for log volumes.

Striping can be checked using the command -> lvs -o+lv_layout,stripes,stripe_size





No comments:

Post a Comment