Oracle 10g Database Performance on Windows Server 2008 Hyper-v

Performance Tuning Corporation recently published a new whitepaper about Performance of Oracle 10gR2 Database on Hyper-v. You can review it at https://www.perftuning.com/pdf/Oracle%2010g%20on%20Hyper-V%202008%20Paper.pdf

The paper compares the performance using the public doman Swnigbench kit. Both OLTP and OLAP scenarios are covered. Impressive results show near physical performance on pass thorough disks. Read the full paper today.

Application:

SwingBench Order Entry - Full OLTP Transaction Mix (4 CPUs)

Benchmark Scenario

TotalConcurrentUsers

Avg.CPUUtilization

StorageUtilization

MemoryUtilization(4GB SGA)

SwapUtilization

AverageTPMsAchieved

MaxTPMsAchieved

AverageTPSsAchieved

MaxTPSsAchieved

HyperV01

50

95%

64% / 74%

46%

0%

16,916

18,634

294

407

Physical01

50

92%

66% / 75%

44%

0%

17,071

19,637

299

445

  

Application:

SwingBench Order Entry – “Browse-Only” Transaction Mix (4 CPUs)

Benchmark Scenario

TotalConcurrentUsers

Avg.CPUUtilization

StorageUtilization

MemoryUtilization(4GB SGA)

SwapUtilization

AverageTPMsAchieved

MaxTPMsAchieved

AverageTPSsAchieved

MaxTPSsAchieved

HyperV01

50

15%

64% / 74%

43%

0%

48,463

51,196

844

876

Physical01

50

10%

66% / 78%

42%

0%

47,148

52,290

819

891