0

I am little confused about the ephemeral disk on LS series Azure VM.I want to suggest L32s_v2 series vm for a customer due to high iops and throughput that the nvme disks provide but there is a catch. if vm is stopped from portal all the data on nvme disk will be erased. this is a serious risk because i cant use it for sql server database files

deepak
  • 117
  • 3
  • 7
  • I think it can survive stops but it is not guaranteed. It can also be lost on resize or restarts caused by moves/outages. (Basically Same for all the series) – eckes Feb 20 '19 at 23:27
  • please respond to my edited question – deepak Feb 21 '19 at 00:08
  • 1
    Well yes, you can’t use it for persistent databases. It can be used for tempdb and maybe for a replica instance – eckes Feb 21 '19 at 00:11
  • Note that Azure SQL Database Business Critical tier uses local flash in combination with multiple replicas to get low-latency IO and reliability. Other than that, Premium SSD Disks is your best bet. https://learn.microsoft.com/en-us/azure/sql-database/sql-database-service-tier-business-critical – David Browne - Microsoft Mar 01 '19 at 22:10

1 Answers1

0

eckes is correct, you can't use the NVMe disks for persistent databases.

For the time being Premium SSD will be your best option for IOPs/throughput on data disks. Ultra SSDs are in Preview now in East US2. 


+----------------+---------------------------------+------------------------------------------------+----------------------------------------------------------------+-----------------------------------------+
|                |       Ultra SSD (preview)       |                  Premium SSD                   |                          Standard SSD                          |              Standard HDD               |
+----------------+---------------------------------+------------------------------------------------+----------------------------------------------------------------+-----------------------------------------+
| Disk type      | SSD                             | SSD                                            | SSD                                                            | HDD                                     |
| Scenario       | IO-intensive workloads          | Production and performance sensitive workloads | Web servers, lightly used enterprise applications and dev/test | Backup, non-critical, infrequent access |
| Disk size      | 65,536 gibibyte (GiB) (Preview) | 4,095 GiB (GA), 32,767 GiB (Preview)           | 4,095 (GA) GiB, 32,767 GiB (Preview)                           | 4,095 GiB (GA), 32,767 GiB (Preview)    |
| Max throughput | 2,000 MiB/s (Preview)           | 250 (GA) MiB/s, 750 MiB/s (Preview)            | 60 MiB/s (GA), 500 MiB/s (Preview)                             | 60 Mib/s (GA), 500 MiB/s (Preview)      |
| Max IOPS       | 160,000 (Preview)               | 7500 (GA), 20,000 (Preview)                    | 500 (GA), 2,000 (Preview)                                      | 500 (GA), 2,000 (Preview)               |
+----------------+---------------------------------+------------------------------------------------+----------------------------------------------------------------+-----------------------------------------+
nsb53
  • 176
  • 1
  • 4