Database Reference
In-Depth Information
PVSCSI controllers and split up the data files, Temp DB, and transaction logs similarly
to that described in the section on SQL VM storage layout. With the four PVSCSI
adapters available, we recommend that you start with two VMDKs per controller and
expand the number of virtual disks per controller as evenly as necessary.
The simplified storage layout potentially provides a number of benefits to each type of
SQL Database.
Table 6.20
outlines some of the benefits you may be able to expect.
Table 6.20
Nutanix Benefits for OLTP and OLAP SQL Databases
To demonstrate the capability of the Nutanix platform for SQL Server, a number of
SQLIO benchmarks were performed as part of the “SQL on Nutanix Best Practices”
white paper (
http://go.nutanix.com/TechGuide-Nutanix-SQLBestPractices_Asset.html
),
reproduced here with permission.
Figures 6.49
through
6.52
resulted from the
benchmarks.
Figure 6.49
SQL Server SQLIO single VM random IOPS by block size.