SQL Server Performance Forum – Threads Archive
SQL Service Installation Disk ChoiceSimple question, Does it matter what disk the actual installation (meaning the MSSQL and Agent service, and maybe system DBs) is installed on as long as the data and log files are located on properly configured high performance disk systems? Or should it be installed on say the same array the datafiles reside on? Thanks.
It shouldn’t matter much, except for the location of the tempdb database. If you use that a lot, you could put tempdb on a seperate RAID set. I only put the log files and data files from user databases on their own RAID sets (where possible). Early morning, when I wake up,
I look like Kiss but without the makeup –Robbie Williams, Strong
Id put all system DB’s on a raid config of some kind rather than C:, if possible.
Not necessarily for performance, just for fault tolerance
I see, thanks for the input.