Your Browser is Out of Date

ShareDemos uses technology that works best in other browsers.
For a full experience use one of the browsers below
Reference Architecture Guide—Ready Solutions for Microsoft SQL: Design for Dell EMC XtremIO
Appendix A: Best practice guidance
Introduction Physical server layer Storage layer Virtualization layer Operating system layer Database layer

Appendix A: Best practice guidance

Virtualization layer

  • For VMware ESXi 6.7:

    • On the QLogic card, increase the LUN queue depth according to your workload requirements. During our benchmarking, we used the queue value of 256.
    • For the ESXi host, change the power management policy to high performance. 
    • Configure multipathing properly to have better performance and high availability for the paths between server and storage. We used VMware NMP technology for storage multipathing.
      • Select the native round-robin path policy.
      • Change the NMP round-robin path switching frequency for the XtremIO X2 array from the default of 1,000 to 1.
    • Use PVSCSI controllers when creating virtual disks on the datastore and assigning it to the VM.
    • Create distributed vSwitches to help with load balancing and high availability.
    • Assign vCPUs and memory within single physical NUMA nodes for the VM to achieve better utilization and performance of the VM.
    • Use VM vCPU and vMemory reservations for better performance predictability and reliability.
    • For high-performance workloads, avoid overprovisioning of memory and vCPUs. Keep ESXi overhead in mind while planning for VM deployment.

next

Operating system layer