Consider the following tuning recommendations for the SQL Server 2022:
- The general best practices for SQL Server high-performance and high-availability from on-premises are applicable to deployments in AWS.
- See the general best practices and recommendations for SQL Server clustering on Amazon EC2.
- It is recommended to use four or more data files for high-performance SQL Server databases and store them on separate volumes.
- It is recommended to store database transaction logs on a separate volume than the data files for ease of performance monitoring and improved performance.
- It is recommended to place tempdb files in a separate volume or local NVMe persistent storage (if available) to avoid page contention.