SQL Server 2008 data directiories in SSD
- by Kuroro
I am going to install a new SQL server 2008 instance on my development/testing machine.
My machine have one 7200rpm 500GB SATA Disk (C:OS) and one Intel X25-G2 80GB SSD(D:).
Details machine config is as follow:
CPU:i7 860
RAM:8GB
Microsoft said I have an option to place following directories in different disk. So I plan to place User database & Temp DB on SSD and rest of it on traditional disk. Is it a good choice for gaining a performance boost in fast SSD?
Data root directory :C:\Program Files\Microsoft SQL Server
User database directory D:\Data
User log directory C:\Logs
Temp DB directory D:\TempDB
Temp Log directory C:\TempDB
Backup directory C:\Backups