Skip to main content
1 of 2
user avatar
user avatar

SQL Server 2008 data directiories in SSD

I am going to install a new SQL server 2008 instance on my machine. My machine have one 7200rpm 500GB SATA Disk (C:OS) and one Intel X25-G2 80GB SSD(D:).

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

Kuroro
  • 115
  • 5