VMware vSphere 4

17
VM WARE WHITE PAPE R
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