n0derunner

    SQL*Server on Nutanix. Force backups to HDD.

    Published: (Updated: ) in Nutanix, by gary.

    As an experiment, I wanted to (a) Create a HDD only container, and (b) measure the bandwidth I could achieve when backing up the SQL DB.  This was performed on a standard hybrid platform with only 4 HDD’s in the node. First create a container, but add the special options “sequential-io-priority-order=DAS-SATA random-io-priority-order=DAS-SATA” which means that […]

    SuperScalin’: How I learned to stop worrying and love SQL Server on Nutanix.

    Published: (Updated: ) in SQL Server, , , , by gary. 3 Comments on SuperScalin’: How I learned to stop worrying and love SQL Server on Nutanix..

    TL;DR  It’s pretty easy to get 1M SQL TPM running a TPC-C like workload on a single Nutanix node.  Use 1 vDisk for Log files, and 6 vDisks for data files.  SQL Server  needs enough CPU and RAM to drive it.  I used 16 vCPU’s  and 64G of RAM. Running database servers on Nutanix is an […]