I'm setting up an Azure D11 SQL Server to be used for a data warehouse. I can only attach 4 data disks and have done so, now I need to determine how to configure them and split the DB files. I'm trying to adapt MS guidance to my specific situation.
Traditional Design:
OS Disk/Azure Temp Disk
1 data disk - TempDB
1 data disk - Log
2 data disk - Data
I'm expecting their guidelines are for general/potentially OLTP servers. I have a data warehouse in simple recovery mode with a single nightly ETL process. I'm not particularly fluent in log file management, but my inclination is the log and TempDB can go on a single data disk, leaving three disks available to stripe and maximize IO for the nightly ETL and, more importantly, day time reporting.
Is it reasonable to put the log and tempdb on a single disk and stripe three for the data or does the log file really need to be on a separate disk?