...
Performance may be better when the "Enable Separate Storage Per Workflow" option is disabled.
SAP Hana
From our performance tests for SAP Hana SQL storage specifically, the use of column-based tables compared to row-based tables showed strong advantages in performance and disk space footprint.
There were unexpected issues during our tests when the memory capacity of the machine where SAP Hana was installed was too small. We experienced minimal issues when installing SAP Hana database with a 64GB memory capacity.
...