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!

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 http://virtualg.uk | @VirtualG_UK
0 Kudos
IRIX201110141
Virtuoso
Virtuoso

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

Regards

Joerg

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.

A+, DCSE, MCP, MCSA, MCSE, MCTS, MCITP, MCDBA, NCDA, NCIE-SAN, NCIE-BR, VCP4, VCP5, VCP5-DT, VCAP5-DCA _____________________ If you find this or any other answer useful please consider awarding points by marking the answer correct or helpful.
0 Kudos