I'm speccing a new database server for a Microsoft SQL Server environment. In the past, I would create four separate RAID arrays for OS, data, transaction logs, and tempdb. Now, I am looking at the possiblity of adding a few SSDs to boost performance more. I only have the budget for two SSDs, and I want to mirror them in case one fails. So, I can only use the SSDs to replace one of my four standard arrays.
Which option would give the biggest performance improvement?
- Use SSDs for OS
- Use SSDs for Data
- Use SSDs for Transaction Logs
- Use SSDs for Tempdb