beautypg.com

Oracle 11g — swingbench – VMware vSphere Fault Tolerance 4 User Manual

Page 17

background image

17

VMware white paper

Swingbench configuration:

Swingbench version: 2.2, Calling Circle Database

No of orders: 23550492

No of Customers: 864967

Runtime: 30 mins

ODBC driver: ojdbc6.jar

Driver Type: Thin

No of Users: 80

Pooled: 1

LogonDelay: 0

Transaction MinDelay: 50

Transaction MaxDelay: 250

QueryTimeout: 60

Workload Weightage: NewCustomerProcess – 20, BrowseProducts – 50, ProcessOrders – 10, BrowseAndUpdateOrders – 50

Note: Database was restored from backup before every run

MSSQL 2005 — DVD Store Benchmark

Virtual machine configuration: 1 vCPU, 4GB RAM, Enhanced VMXNET virtual NIC, LSI Logic virtual SCSI adapter

OS version: Windows Server 2003 R2 Datacenter Edition, 64 bit

MSSQL version: 9.0.1399

Database Size: 20,2971MB (~200GB), split into two vmdk files of 150GB size each

Database row count: 200,000,000 customers, 10,000,000 orders per month, 1,000,000 products

Dell DVD Store benchmark version: 2007/12/03

Benchmark parameters

n_threads: 16

ramp_rate: 2

run_time: 30 mins

warmup_time: 4 mins

think_time: 0.40 secs

pct_newcsutomers: 40

n_searches: 5

search_batch_size: 8

n_line_items: 10

db_size_str: L

Note: Database was restored from backup after every run