VMware 4 Manual

A SERVICE OF

next previous

17

VMWARE WHITE PAPER

Swingbench conguration:

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conguration: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 les 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