Dell PowerEdge R820 Comment utiliser télécharger pdf (Page 10)

Consolidating Oracle Databases on the Dell PowerEdge R820 Server Using Oracle VM

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

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

1 2 ... 5 6 7 8 9 10 11 12 13 14 15 ... 20 21

Commentaires sur ces manuels

Pas de commentaire

Dell PowerEdge R820 Comment utiliser Page 10

Commentaires sur ces manuels

Produits connexes et manuels pour Serveurs Dell PowerEdge R820