1 Reply Latest reply on May 11, 2019 10:23 AM by Great_White_Tec

    SQL Performance on vSAN with VM Storage Policies

    KingMatthew Lurker

      Morning Everyone,

       

      I have a SQL VM Storage Policy defined like this:

       

      1 Failure - Raid-1 Mirroring

      Number of disk stripes per object = 1

      IOPs limit for object = 0

      Thick provisioning

       

       

       

      Is this optimal for SQL Tier 1 performance (maximizing IOPS)?  

       

       

      Will increasing the number of stripes per object increase performance?

       

       

      Thank you, I award points!