SAP HANA

 HANA File Systems: Below are the major file systems used in HANA

1. /hana/data
2. /hana/log
3. /hana/shared
4. /usr/sap/
5. /hana/backup

Filesystem	Purpose	Recommended FS Type
/hana/data/<SID>	Stores HANA database tables & persistent data	XFS
/hana/log/<SID>	Stores redo logs for transaction recovery	XFS (SSD recommended)
/hana/shared/<SID>	Holds shared files, configurations & binaries	XFS/NFS (multi-host)
/usr/sap/<SID>	Contains instance-specific binaries & logs	XFS
/hana/backup	Stores database backups	NFS

E.g:

All these file systems are to be saved in /etc/fstab so that they can be mounted in the server. using command : mount -a.

SAP recommends having the primary HANA filesystem type as NFS:

Command to check the filesystem: df -T /hana/data

Recommendations:

✔️ Use XFS for /hana/data, /hana/log, /hana/shared for better performance
✔️ Use NFS for /hana/backup (if using shared storage)
✔️ Monitor disk usage regularly to avoid performance issues

Advantages of XFS:
✔️ High performance for large databases
✔️ Supports snapshots and journaling
✔️ Ensures data consistency and integrity