The Azure VM are serve for SQL Server AAG . And planning to build storage pool .
Trying to create two pool , one for data and another for log.
and I have the following questions and need advice ..
for the VM disk added to the VM for DATA, need to still enable "Read-only" cache option ? And none for log ?
what's the maximum size of the disk , so that the VM disk still can use "Read-only" cache option?
After creating the storage pool , and create a physical disk , there is a option from the physical disk "write-back cache" and "Readcache size". by default its 1GB and 0B , when creating the physical disk by GUI . Any advice for these parameter to achieve best performance??? especially for the storage pool of LOG and DATA .........
if there are 3 vm disks in the storage pool of data , (suppose its P40 Premium SSD , Provisioned IOPS 7500) . I create a phyiscal disk , what's the IOPS of the phyiscal disk ? 7500 x 3 ?