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