Optimizing SQL Server on Amazon EC2 for Oracle JD Edwards EnterpriseOne

Jeremy Shearer, Amazon Web Services (AWS)

December 2022 (document history)

JD Edwards EnterpriseOne can be used with multiple database platforms, including Oracle Database, SQL Server, and IBM Db2. Many users find that SQL Server is a good database choice because of its balance of cost and features combined with their existing skills for managing a SQL Server database.

Each database platform supports multiple deployment options for EnterpriseOne on AWS, including Amazon Elastic Compute Cloud (Amazon EC2) and Amazon Relational Database Service (Amazon RDS), as the following table shows.

EnterpriseOne platform	Deployment options on AWS
	Amazon EC2	Amazon RDS	Other
Oracle Database	Yes	Yes	IBM Power Systems (i/AIX) and AWS Hybrid Architecture
SQL Server	Yes	Yes
IBM Db2	Yes	No	IBM Power Systems (i/AIX) and AWS Hybrid Architecture

This guide focuses on deploying an EnterpriseOne database with SQL Server on Amazon EC2. For a detailed discussion of other SQL Server deployment options, see Choosing between Amazon EC2 and Amazon RDS.

When you use Oracle JD Edwards EnterpriseOne with a SQL Server database on Amazon EC2, you can take advantage of specific optimization techniques to achieve a highly performant and cost-optimized system. This guide focuses on performance optimization of a SQL Server instance and doesn’t cover high availability, disaster recovery, backups, or other complementary configurations covered in other documents, including Migrating Microsoft SQL Server databases to the AWS Cloud.

This guide builds upon the guide Best practices for deploying SQL Server on Amazon EC2 and is intended for architects and DBAs who have a good understanding of SQL Server and JD Edwards EnterpriseOne.