Throughput striping Premium disk issue RRS feed

  • Question

  • Hello,

    I deployed SQL server on VM (size DS14-8_v2) in Azure and to improve performance enabled disk striping to storage using premium SSD (P30 * 4 pieces). But I don't see any changes in performance. The throughput is incredible low.

    For my estimation throughput should be 200 MiB/s * 4 = 800 MiB/s. Why our throughput is so low?
    I'm using next guideline to setup IT environment for SQL server: https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-sql-performance

    Storage Pool:

    Thank you!

    Monday, November 18, 2019 1:06 PM

All replies

  • @Kos.Alfa Just for confirmation:  I see you have created Microsoft Support case 119111824003390  If am Correct I would request you to continue to work with the support for a focused assistance on this issue. This issue required deeper analysis. Also, you could share the resolution here with the community once the issue has been fixed for benefiting the other  users
    Tuesday, November 19, 2019 12:08 PM