Provisioning SQL Server 2019 I'm provisioning a SQL Server 2019 build and have been allocated a virtual server running Windows Server 2016. It has 4 virtual processors and I have 410Gb of drive space to work with.
My build has to run two versions of the same 35Gb database.
My intention is to split the 410Gb drive on the new box up as follows:
L:\ to hold log files. Based on a rule of 25% of the size of the database = 9Gb per DB = 18Gb).
T:\ to hold tempdb files. 4 data files (one per logical processor) at 1.5Gb each with a log file of 3Gb and a further 2Gb per DB for auto growth = 11Gb.
D:\ drive of 190Gb for data and an E:\ drive of 190Gb for all backups.
Does that sound like a sensible split?
If you only have one drive, you won't gain performance by splitting it logically but you said you want to split the drive into logical drives for logs and data so if one runs out of room it will not cripple the others' content. However, if either your data drive or your log drive or your tempdb drive is out of space then you are down. I would instead keep on the same drive in order to maximize the space you do have. It really sounds like you have plenty of room for two 35 GB databases. Monitor your mdfs and ldfs for auto growths and your drive for free space. Move your system databases to the same drive. Compress your databases. If the databases are not in simple recovery model, be sure to take frequent log backups. Compress your backups. Make sure you are copying your backups to another location so you have a copy in case your drive crashes. Make sure you have jobs to prune msdb history and old backups.
I wouldn't size my log files or my tembdb based on a rule of 25% or anything else. Size them pretty small to start and watch them autogrow and then resize them to that.