Tag: sql-server

SQL*Server on Nutanix. Force backups to HDD.

By: gary Date: March 10, 2016 Categories: Nutanix Tags: sql-server

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.

By: gary Date: November 23, 2014 Categories: SQL Server Tags: benchmark, hammerDB, sql-server, tpc-c

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…