I am in the process of building a new server to run our SQL Server databases (we have many TB's of data). I am looking for some help on what I should request for hard drives. My thought was to have 5 logical drives:
Drive 1: System drive Drive 2: Database drive for DB's with a lot of read/writes Drive 3: Database drive for other DB's and TempDB Drive 4: Log files Drive 5: Backups and other storage
Would this be a good setup? What type of disk (SSD or other) and RAID should I use for each drive? Keep in mind I'm trying to get the most bang for the buck. I don't have an unlimited budget, and I want to spend a lot on RAM.