locked
Slow Disk I/O Solutions RRS feed

  • Question

  • We have a VM (classic) running a SQL Server database and are encountered really bad disk I/O speeds, so I have two questions -

    1. Is there any way to configure it to increase the speed?
    2. Is there any way to change it into one of the D-series non-classic VMs that utilize the SSDs?
    • Moved by BrianEhMVP Monday, January 4, 2016 5:38 PM
    Friday, December 18, 2015 3:30 PM

Answers

  • Hi,

    1. No. The I/O calculation should be done according to below and you should select the disk configuration during the setup for classic VMs.

    https://azure.microsoft.com/en-gb/documentation/articles/virtual-machines-sql-server-performance-best-practices/

    For ARM based VMs you can actually provide the I/O numbers required and it will automatically provision the disk array when you create the VM.

    https://azure.microsoft.com/en-us/blog/new-configuration-experience-sql-server-virtual-machines/

    2. Please refer below.

    https://azure.microsoft.com/en-gb/documentation/articles/storage-migration-to-premium-storage/#migrating-existing-azure-vms-to-azure-premium-storage

    Hope this helps.


    Janaka Rangama MVP MCT MIEEE MBCS (Please take a moment to Vote as Helpful and/or Mark as Answer, where applicable.)

    Tuesday, January 12, 2016 11:21 AM