added 85 characters in body

edited Oct 26, 2009 at 16:55

115
5

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

Post Migrated Here from stackoverflow.com (revisions)

occurred Oct 25, 2009 at 16:34

Source Link

asked Oct 25, 2009 at 16:06

Kuroro

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:).