We are using Azure SQL VM and we have multiple data files of multiple databases stored on same drive (let's say Drive E: of size 3 TB) which is created from 4 * 512 GB disks + 4 * 256 GB disks.
I was thinking to remove those smaller disks and add a bigger disk like 1 TB or 2 TB.
What would you recommend based on the following for getting best performance from disks:
- single disk of 3TB.
- 3 Disks of 1 TB each.
- 1 Disk of 1 TB and 1 Disk of 2 TB.
It's Azure premium SSD.
I checked the documentation and on my understanding using P30 and P40 disks i.e. 1TB and 2TB disks respectively seems to be better. However, if my single database size is around 1.7 TB in size, I'm confused if that would be better to use single 2TB for it or combine two 1TB disks.