SQL Best Practice

  • 2 December 2019
  • 1 reply
  • 6346 views

Userlevel 4
Badge +5

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.
 

Microsoft SQL Server 
 

MySQL on Nutanix

 

PostgreSQL


HammerDB on SQL


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/


This topic has been closed for comments

1 reply

Userlevel 3
Badge +10

Great write up!