Microsoft sql server 2005, Microsoft sql server 2005 - throughput, Microsoft sql server 2005 - response time – VMware vSphere Fault Tolerance 4 User Manual
Page 12
12
VMware white paper
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 traffic 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
O
per
ations/min
FT traffic:
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)
M
illisec
onds
Avgerage Response Time