Capturing, Measuring, and Replaying a Workload Using SQL Profiler - Professional SQL Server 2005 Performance Tuning - page 339

Since DS2 supports multiple operating systems, the installation and configuration of DS2 requires
recompiling source codes on your Windows platform. It also requires modifying the connection string of
the DS2 database in the source code.

In the following scenarios, we used the DS2 benchmark tool and simulated 40 concurrent users for 20
minutes. Each user logged into a DVD online store, browsed one to five individual items, and then made
one subsequent purchase.

Here are the source server and workload characteristics:

❑ Hardware Profile: Intel Pentium III 662 Mhz; two processors; 1 GB of RAM;

❑ SQL Server Edition: SQL Server 2000 SP4

Customer Order: An average customer order consists of one login, three production searches,
and one purchase.

❑

Percentage of New Customers: 20%

❑

Measurement Interval: 20 minutes

❑

Warm-Up Time: 1minute

❑

Number of concurrent threads: 40

❑

Think-Time (This delay simulates a customer's think-time from product search to final pur-
chase.): 3 seconds

❑

After DS2 completed the simulation, it provided the following statistical measurements
(see Figure 10-16):

Customer Orders per minute: 732

❑

Total number of logins during run: 12,180

❑

❑ Total number of browses during run: 45,329

❑ Total number of purchases during run: 15,151

❑ Average login time in milliseconds: 11

❑ Average new customer registration time in milliseconds: 27

Average browse time in milliseconds: 28

❑

Total data collection run time: 1,241 seconds (20.68 minutes)

❑

Figure 10-16