question

sakuraime avatar image
0 Votes"
sakuraime asked RamyaHarinarthini-MSFT answered

Azure VM storage pool for SQL Server

The Azure VM are serve for SQL Server AAG . And planning to build storage pool .

  1. Trying to create two pool , one for data and another for log.

and I have the following questions and need advice ..

  1. for the VM disk added to the VM for DATA, need to still enable "Read-only" cache option ? And none for log ?

  2. what's the maximum size of the disk , so that the VM disk still can use "Read-only" cache option?

  3. 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 .........

  4. 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 ?


thanks

azure-virtual-machines
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

RamyaHarinarthini-MSFT avatar image
0 Votes"
RamyaHarinarthini-MSFT answered

@sakuraime Welcome to Microsoft Q&A, Thank you for posting your here!!

For existing SQL Server VMs, you can modify some storage settings in the Azure portal by following the steps here

  1. As per SQL Server VM performance best practices . Choose premium storage sets the caching to Read Only for the data drive, and None for the log drive

  2. Maximum data disk size is up to P80 disk type with 32TB. To know more about size/cache recommendation please refer the document here

  3. For better performance please create the disk stripe by following this document

  4. Yes, you are correct if you create 3 disks in a storage pool the performance(IOPS/Throughput) would be combined.

Hope this helps!

Kindly let us know if the above helps or you need further assistance on this issue




Please do not forget to "Accept the answer” and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

RamyaHarinarthini-MSFT avatar image
0 Votes"
RamyaHarinarthini-MSFT answered

Just checking in to see if the above answer helped. If this answers your query, do click “Mark as Answer” and Up-Vote for the same, which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.