Database Reference
In-Depth Information
configure only one partition per virtual disk for your database.
Tip
We recommend the use of basic disks in Windows and the GPT (GUID Partition
Table) partition format for all SQL Server partitions. If you want to boot from a
GPT partition that's larger than 2TB, you can use the UEFI boot features of
vSphere 5.x.
SQL Server Virtual Machine Storage Design
We have now covered how to optimize storage performance for SQL Server and
Windows at the operating system level. Now we will look at how to optimize storage
performance with your virtual machine template and discuss the different configuration
options available to you. In this section, we cover different virtual machine hardware
versions, virtual IO controllers, types of virtual disk, and how to size and deploy your
virtual disks onto your storage devices. In this section, we start to look further at IO
device queues and how they impact virtual machine storage performance.
Virtual Machine Hardware Version
The virtual machine hardware version you choose will impact the type of virtual storage
IO controllers available to your virtual machine. The type of virtual storage IO
controller you choose will have an impact on your storage performance, as we will
cover in the next section.
Table 6.3
shows the different storage IO controller options
based on the different virtual hardware versions.
