I have a question about best utilizing disks on a server.
Lets say I have a server (a VM on Azure/AWS/Google Compute) with three disks: OS (80GB), data_A (40GB), & data_B (40GB). I have a total of 12 databases on this server, and each is 3GB. They are backed up once a day at 3am to the OS drive. Only one backup is kept on server which is itself sent to storage after the backup occurs each night when FMS runs a batch file.
Assume each database has moderate to low usage. How best to distribute these database across the three disks? 6 on data_A, 6 on data_B? Split them equally- 4 on each drive? 5 on data_A, 5 on data_B, 2 on OS?
I realize more detail would be required to give a definitive answer, but I'd like to begin testing with the most promising set-up. I will of course change things up if a different arrangment yields better results.