Dell PowerEdge R820 - Manual (Page 10)

Consolidating Oracle Databases on the Dell PowerEdge R820 Server Using Oracle VM
10
Table 1 describes the complete software and hardware configuration that was used throughout testing
on both the simulated legacy production environment and the 12G test environment.
Hardware and Software configuration details Table 1.
Performance metrics
During the testing process we collected the following metrics for further study and analysis:
 TPS (transaction per second)
 AQRT (average query response time)
 CPU utilization
 Memory utilization
 Power consumption
For an OLTP environment the most commonly used metrics are transaction per second (TPS) and
average query response time (AQRT). Average query response time of an OLTP database environment
may be described as the average time it takes for an OLTP transaction to complete and deliver the
results of the transaction to the end user initiating that transaction. The average query response time
is the most important factor when it comes to fulfilling end-user requirements, and it establishes the
performance criteria for an OLTP database. A 2-second response time metric was chosen as the basis
for our Service Level Agreement (SLA), and this metric which was maintained throughout the testing
period.
Component Legacy Production Environment 12G R820 Test Environment
Systems Two PowerEdge 2950 III,2U servers One PowerEdge R820 2U 4 socket
server
Processors Two Intel Xeon X5460, 3.16 GHz quad
core per node
Cache: L2=2x4M per CPU Four Intel Xeon 2.70 GHz eight core
Cache: L2=2MB L3=20MB
Memory 32 GB DDR2 per node (64 GB total) 428 GB DDR3
Internal disks Two 73 GB 2.5” SAS per node Two 73 GB 3.5” SAS
Network Two Broadcom® NetXtreme II BCM5708
Gigabit Ethernet Four Intel® 10 Gigabit X540-AT2
External storage Dell PowerVault M3620f with 300GB
SAS disks Dell Compellent SC8000 with 300GB
SAS disks
HBA One QLE2462 per node Two QLE2562
OS Enterprise Linux® 4.6 Enterprise Linux 6.2
Hypervisor Not Applicable Oracle VM 3.1.1
Oracle software • Oracle 10g R2 10.2.0.4
• File System: ASM
• Disk groups: DATABASE, DATA
• sga_target = 4000M
• pga_target = 2000M • Oracle 11g R2 11.2.0.3.0
• File System: ASM
• Disk groups: DATABASE, DATA
• sga_target = 8000M (per instance)
• pga_target = 4000M (per instance)
Workload • Quest Benchmark Factory TPCC
workload
• Scale factor: 3000
• User connections: 200-5000 • Quest Benchmark Factory TPCC
workload
• Scale factor: 3000
• User connections: 200-5000