VMware Cloud Community
KingMatthew
Contributor
Contributor
‎05-11-2019 07:45 AM

SQL Performance on vSAN with VM Storage Policies

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!

0 Kudos
1 Reply
GreatWhiteTec
VMware Employee
VMware Employee
‎05-11-2019 10:23 AM

Hi,

What is the workload profile for your environment?

If by thick provisioning you mean OSR=100 this may help with the out of space scenario, but performance gains may not be noticeable 

Stripe width may help with hybrid clusters but all-flash clusters may not have any performance gains. This will depend on the workload profile.

I recently published a blog post on this topic Considerations for Running Microsoft SQL Server Workloads on vSAN