SQL Server on Nutanix - Best pratices
The following taken from : Microsoft SQL Server 2016 Nutanix Best Practices Drive configuration: For optimal performance several virtual disks should be used. Nutanix suggest eight disks per SQL Server virtual machine spread across 4 SCSI controllers as laid out below: Drive Controller Type Controller # OS LSI SAS 0 SQL Sever installation LSI SAS 0 Backup LSI SAS 0 SQL Datafiles 1 PVSCSI 1 SQL Datafiles 2 PVSCSI 1 TempDB Datafiles 1 PVSCSI 2 TempDB Datafiles 2 PVSCSI 2 TempDB Log Files PVSCSI 3 Database Log Files PVSCSI 3 Cluster size formatting of all drives as below: SQL Data and log files - 64KB NTFS OS and SQL Server installation - 4KB NTFS - Server Team ?? ...
Comments