Comparing Oracle Exadata Database Performance with Amazon RDS for Oracle
In this post, Case Study Explaining how Tata Consultancy Services (TCS) supported a UK-based utility provider’s digitalization journey by comparing performance of their on-premises Oracle Exadata database with Amazon RDS for Oracle.
Use Case of a Utility Customer
A UK-based utility provider that was running its business on an old version of Oracle Utilities needed upgrading to meet future aspiration of growth and performance. The upgrade entailed moving to Oracle Utilities Customer to Meter (C2M), and the solution runs on the Oracle-native Exadata database.
While AWS was the preferred cloud platform for the customer, moving away from Oracle Exadata to Amazon RDS for Oracle was proving to be difficult due to concerns of degrading performance. In such scenarios, TCS proposes a time-bound Proof of Concept (PoC) to expedite decision-making.
The objective of the PoC was to prove the current workload can be supported on Amazon RDS for Oracle and give the customer confidence that the same level of database performance can be achieved by moving away from Oracle Exadata to Amazon RDS for Oracle.
Key principles for the PoC were:
- Production workload should be carefully analyzed to identify simulation criteria.
- Proper sizing analysis should be done to baseline the target environment.
- Workload simulation needs to meet a high degree of precision.
- Success criteria needs to be well-defined and measurable.
- Results should be comparable in like-for-like setting.
In this scenario, only the database performance was compared between Oracle Exadata database and target Amazon RDS for Oracle and not the application layer.
Success Criteria
For this PoC, the following performance parameters were used to compare performance between Amazon RDS for Oracle with on-premises Oracle Exadata.
# | Parameters | Target Measure | Tools Used |
1 | System performance of Amazon RDS for Oracle | Avg. CPU < 75%, avg. mem <75%, IOPS – Less than max assigned for the storage | Amazon CloudWatch |
2 | Replay reliability/divergence | <5%, Number of rows returned by each call are compared and divergences percentage reported | RAT replay report |
3 | Replay run time | 7 hrs. 16 min | RAT replay report |
4 | SQL efficiency – % DB change | Same as on premises or improved | RAT replay report and AWR report |
5 | SQL efficiency – common/long running | Same as on premises or improved | RAT replay report and AWR report |
6 | DB instance efficiency | Same as on premises or improved | Performance insights |
Click on AWS Link below -
Oracle Exadata Database Performance with Amazon RDS
No comments:
Post a Comment