VMware Cloud Community
KingMatthew
Contributor
Contributor

How to configure 2 disk groups per ESXi host?

Morning everyone,

Working on improving SQL on vSAN and here is one of the recommendations:

  • While a single disk group per host is fully supported, it is recommended to have at least two disk groups per host, or more. Multiple disk groups can improve throughput in many cases and it provides better resilience to certain drive failure scenarios.

How do you configure this, and or how do you check if this is active?

Thank you, and I award points!

Reply
0 Kudos
3 Replies
virtualg_uk
Leadership
Leadership

Multiple disk groups is definitely a good idea for a variety of reasons.

To add another disk group, it's simple enough, see the official guide here: Create a Disk Group on a vSAN Host

Selecting the cluster > Configure > Disk Management will show you current disk groups setup in vSAN


Graham | User Moderator | https://virtualg.uk
Reply
0 Kudos
IRIX201110141
Champion
Champion

Add another buffer(AF)/cache(hybrid) device together with 1 or more capacity devices and create nother diskgroup.

Regards

Joerg

Reply
0 Kudos
GreatWhiteTec
VMware Employee
VMware Employee

Apart from having 2 DGs or more, you may also want to consider having several VMDKs per SQL server to spread out your DBs. Adding additional DGs can linearly increase performance, but you should take into account whether you will be utilizing dedupe and compression in the cluster. Since we currently do Dedupe and Compression at the DG level, having bigger DGs will yield better dedupe ratio, while having more DGs may yield better performance. It's a design decision you will need to make based on your requirements.

Reply
0 Kudos