Best Practice 15.2 – Modify database parameters to align with hardware selection

SAP provides specific guidance to optimize performance of an SAP system by modifying certain parameters of the underlying database. These parameters are specific to database type and can vary based on whether it’s supporting an analytical or a transactional type application.

Suggestion 15.2.1 – Review SAP HANA-specific tuning parameters, if applicable

Operating System and SAP HANA Database parameters can significantly impact performance. Follow SAP on AWS recommendations for Operating system and storage configuration.

Refer to SAP notes and documentation for guidance on SAP HANA parameters including memory allocation.

Suggestion 15.2.2 – Review database tuning guidance for non-SAP HANA databases

Regardless of the underlying database for your SAP system, performance of the system is in part dependent on how the database is tuned. Each database has specific recommendations for tuning based on available compute, memory, and disk storage. Certain database parameters are dependent on your choice of underlying EC2 instance size; for example, the physical memory available will limit the db_cache_size for an Oracle database.

For information relevant to your database, refer to the following: