Optimizing Disk I/O for SAP HANA on Proxmox

[gottliebmike]

Hello Proxmox Community,

I’m excited to share that I’m setting up an SAP HANA environment on Proxmox and looking forward to leveraging its in-memory database capabilities. To ensure I get the best performance, I’m fine-tuning the disk I/O settings for the storage backend. SAP HANA’s architecture is impressive, but I want to make sure the storage layer is optimized to complement its high-speed operations.

Here’s my current setup:

• Proxmox version: 8.0
• Storage backend: ZFS on a RAID 10 setup
• Disk type: Enterprise-grade NVMe SSDs
• Workload: Primarily OLAP queries with moderate OLTP

Current configurations:

• Cache mode: Write-back
• I/O threads: Enabled (4 threads per VM)
• Block size: 64K

While SAP HANA is performing well, I’d like to explore additional disk I/O optimizations to ensure it runs even more efficiently on Proxmox. Are there any advanced ZFS tuning options or Proxmox settings that have worked well for similar setups?

I’d like to hear your suggestions or success stories with SAP HANA on Proxmox!