Traditional ERP and CRM business applications must be continuously updated and integrated, blurring the boundary between business functions. With business decisions progressively being driven by analytics, businesses are under pressure to make improvements or add new functionality quickly.
Dell EMC has designed a series of performance tests using OLTP and OLAP databases. OLTP database usage is characterized by small requests for information, such as looking up an inventory item or checking a customer account, and supporting mission-critical back-office applications. ERP and CRM systems can support thousands of users who generate millions of database transactions and require very fast response times. In this case, response time is the total amount of time required for the database to respond to a request. For our OLTP tests, we used an aggressive response-time goal of .75 milliseconds or less to measure success.
OLAP database usage, on the other hand, is characterized by large requests for data that involve activities such as running a report and performing data mining. Businesses depend on the ability to create sales reports, budgets, and forecasting reports quickly because decisions depend on expedient analysis. In this case, throughput is important because large datasets must be analyzed. Throughput is the rate at which the database can process data. The higher the throughput, the more data the database can read and the better the OLAP performance. In the small configuration, we targeted a throughput of at least 1.00 GB/s to measure success.
The PowerEdge R740 servers were chosen for their capability to balance performance in a mixed-database workload ecosystem with an entry-level price point. When you invest in a validated platform like Ready Bundle for Oracle, you should ensure the platform includes room for growth. As part of our testing, we captured CPU utilization with a goal of supporting realistic workloads while showing that there is room to support even more workload on PowerEdge servers.
Briefly, the small configuration of Ready Bundle for Oracle includes two PowerEdge R740 servers with one VMAX 250F array using one V-Brick block with 16 by 960 GB flash drives. Chapter 3, Architecture Overview, provides a complete description of the small configuration for Oracle.