I'm researching playing around with a Sql Server VM on Azure.
Our DB is around 30-40GB.
So i was thinking about making a 300GB data disk to put the 1 Database on it (or a few more, later).
I believe i have a few options here.
- A single Data Disk which is 300GB in size.
- Multiple Data Disks with striping that total 300GB (Eg. 2x150 or 3x100 GB)
- Is it worth striping?
- Does either option consume more page blobs than the other?
I'm under the impression that:
Going the striping option offers us more IOPS at the cost of higher risk or HD failure which means higher risk of data loss (for the sake of this discussion, lets leave backups out of this).
The multiple data disks will consume more page blobs but that number is tiny and not really worth worrying about. (but I have ZERO proof of this nor do i know how to figure out this metric answer).