Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nic
Posting Yak Master
209 Posts |
 Posted - 2009-07-07 : 14:35:55
|
| Hi,We have a new SQL Server with 3 physical RAID 1 disks.Disk 1: OS and tempdb (made up of 2 logical disks, but technically one physical disk) Disk 2: dataDisk 3: logLong term, we'll buy another disk and move tempdb to a seperate physical location but given $ contstraints this is the best I could do. The original plan was to have tempdb on disks 2 & 3 (along with all the other databases) but I later read it is better to seperate tempdb from the other databases.So, my question is what about the other default databases? Would it be better to move them to disks 2 and 3 or keep them in the default location (where SQL is installed).Or does it not make much of a difference?Thanks,Nic |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2009-07-07 : 18:56:32
|
| We tend to leave the other system databases on the C: drive along with the OS. They don't use a lot of resource.Another idea to mull over is to have another disk to hold data and then place some of the indexes on that drive. In this way, the data and indexes can be written in parallel.=======================================Men build too many walls and not enough bridges. -Isaac Newton, philosopher and mathematician (1642-1727) |
 |
|
|
|
|
|
best location for master, model, msdb etc