Microsoft sql server 2005, Microsoft sql server 2005 - throughput, Microsoft sql server 2005 - response time – VMware vSphere Fault Tolerance 4 User Manual

Page 12

Advertising
background image

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

Advertising