Let's say you're running a huge infrastructure of 10 pretty big SQL VMs and just shifted your infrastructure to Nutanix. You must be bewildered and confused regarding the best practices of SQL in Nutanix and how can you improve the performance.
For most SQL server databases, there is nothing that needs to be done in order to successfully run on Nutanix.
SQL servers with small DBs are normal and okay but what about larger workloads?
Do we have some best practices guide that can help us improve our performance?
Yes, we have some general recommendation for running SQL workloads.
Try giving the following Knowledgebase articles a read to understand the configuration and recommended settings to improve performance of SQL workloads.
KB-3532
KB-1833
Want to know the best practices for different SQL workloads.
Try giving the following solution documentations a coffee read.
You can try giving the following blog a read which states the top 5 best practises or tips for successful SQL Server virtualisation projects
http://longwhiteclouds.com/2017/02/01/best-practices-for-running-sql-server-virtualized/