Database Reference
In-Depth Information
Table 6.5
Virtual Storage Adapter Performance (32 OIOs)
Table 6.6
displays the IOMeter performance results of increasing the outstanding IOs
from 32 to 64 to issue more IOs in parallel using otherwise similar test parameters. As
was the case with the previous test, PVSCSI shows significantly improved performance
compared to the other adapter types.
Table 6.6
Virtual Storage Adapter Performance (64 OIOs)
This test also shows that a single virtual machine on a vSphere 5.5 host with a single
virtual disk can provide good performance and throughput, provided the underlying
storage system can support it. Using PVSCSI with vSphere 5.1 and above, a single
virtual machine can support up to one million IOPS at 4KB IO size (see
Caution
The IOMeter performance results included in this section were created only to
show the relative difference in performance capability between the different
virtual storage adapter types. Your results will be different. These tests did not
use real-world workload patterns and should not be relied upon for sizing or
capacity planning of your SQL Server databases. You should conduct your own
tests to validate your environment. See
Chapters 10
and
11
for details of how to
validate and baseline your environment.
Choosing the Right Virtual Disk Device
You have a small number of options when choosing a virtual disk type for SQL Server,
and the choice you make may have an impact on performance. However, modern storage
systems and advancements in hypervisor technology have equalized the performance
aspects of different virtual disk types in a lot of cases. Today, the type of storage you're
