I would like advice on what would be the best setup for our SQL Server 2005 TempDB.
At the moment our Temp DB consists of a single
MDF file of 3 GB and a single log file of 120 MB on the D: drive of a 3 spindle RAID-5 array which is partitioned in to C: and D: drives. The D: drive also holds our application core programs and our reports database.
I would like to move the temp DB to its own drive which is a 2 spindle RAID-1 array with a single partition, drive F:.
I would like to create 4 x 1 GB temp db
MDF files when I move it to this drive. I do not have another spare dedicated drive to split up the TempDB MDF and LDF files, so both would have to go on the same drive.
Should I leave the LDF file behind on the current drive or should I move all the files to the new one?