Azure VM storage pool for SQL Server

sakuraime 2,316 Reputation points
2021-04-13T08:21:09.02+00:00

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
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
6,978 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Ramya Harinarthini_MSFT 5,296 Reputation points Microsoft Employee
    2021-04-14T13:55:51.383+00:00

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

    0 comments No comments

  2. Ramya Harinarthini_MSFT 5,296 Reputation points Microsoft Employee
    2021-04-16T06:40:56.047+00:00

    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.

    0 comments No comments