12
VM WARE WHITE PAPE R
3.7. Microsoft SQL Server 2005
In this experiment, the DVD Store benchmark was used to drive the Microsoft SQL Server® 2005 database. This benchmark
simulates online transaction processing of a DVD store. Sixteen simultaneous user sessions were used to drive the workload. As with
the previous benchmark, this workload has a mixture of CPU, memory, disk, and networking resource requirements. Microsoft SQL
Server however issues many RDTSC instructions, which read the processor time stamp counter. This information has to be recorded at
the primary and replayed by the secondary virtual machine. As a result, the network trac of this workload includes the time stamp
counter information in addition to the disk reads and network packets.
Figure 11. Microsoft SQL Server 2005 Performance (throughput)
0
500
1000
1500
2000
FT Disabled
FT Enabled
Microsoft SQL Server 2005 - Throughput
Operations/min
FT trac:
18 Mbits/sec
Figure 12. Microsoft SQL Server 2005 Performance (response time)
0
20
40
100
60
80
120
FT Disabled
FT Enabled
Microsoft SQL Server 2005 - Response Time
(lower is better)
Milliseconds
Avgerage Response Time
To Next Page
Loading...
Need help?
General
