I'm planning to set up a SQL database that will require around 100 TiB of data storage for the first few years. Since Azure disks have a limit of 32/64 TiB, I'm considering using RAID0 to combine multiple disks for this purpose. Since we use Locally Redundant Storage (LRS) disks which are already replicated, I'm not too worried about durability issues with RAID0. For high availability, we'll also replicate the data to another zone with its own LRS disks. Have you had any experience with this kind of setup or do you have any recommendations?
5 Answers
Just a thought: why not use Azure SQL database? It can support up to 128 TiB data size, which might fit your needs.
Have you thought about splitting your SQL database into multiple file groups? That might help manage the large data volume better.
I haven't personally set this up, but I hear that Elastic SAN could be a better choice for handling that kind of capacity. It might simplify things for you.
If you can, splitting your data across several databases might be a good approach.
You can actually use RAID0 with storage spaces in Azure. The 3 replicas in Azure provide data protection, and the Elastic SAN option is definitely worth considering for easier configuration and possibly better performance.
I think the max volume size for Elastic SAN is also capped at 64 TiB, similar to Premium SSD v2.