locked
SQL DB (PaaS) with premium storage option. Is this a SSD storage? RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    SQL DB (PaaS) with premium storage option. 

    Is this "premium storage" considered SSD storage?

    dsk

    Wednesday, December 6, 2017 8:15 AM

Answers

  • Question
    Sign in to vote
    2
    Sign in to vote

    Both Standard tiers and Premium tiers use a technology called Azure Premium storage, which is eventually backed by SSD. On Standard tiers, the storage is remote from the SQL Server instance processing user requests. On Premium tiers, the SSD storage is local. There are mainly two benefits. First, latency is sub-ms for local reads compared to muli-ms for reads from XIO. Second, SSD supports higher IO throughput. Best regards.

    Wednesday, December 6, 2017 9:08 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello,

    As mentioned on the following blog post, Premium tiers have local SSD storage and reside on a special hardware also.

    https://blogs.msdn.microsoft.com/sqlcat/2017/10/23/top-questions-from-new-users-of-azure-sql-database/



    Hope this helps.



    Regards,

    Alberto Morillo
    SQLCoffee.com

    Wednesday, December 6, 2017 1:34 PM
  • Question
    Sign in to vote
    2
    Sign in to vote

    Both Standard tiers and Premium tiers use a technology called Azure Premium storage, which is eventually backed by SSD. On Standard tiers, the storage is remote from the SQL Server instance processing user requests. On Premium tiers, the SSD storage is local. There are mainly two benefits. First, latency is sub-ms for local reads compared to muli-ms for reads from XIO. Second, SSD supports higher IO throughput. Best regards.

    Wednesday, December 6, 2017 9:08 PM