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 |
|
cornall
Posting Yak Master
148 Posts |
 Posted - 2009-11-27 : 05:19:55
|
| Hi,Just wanted some advice on best practice for database locations based on my server config.c:\ System raid 1 d:\ logs raid 1e:\ data raid 5Now I know the raid config isn't idea I can't change this.The server has 4 physical cores and 8 if you count hyperthreading.So I was planning to split the temp DB data files up fo the numebr of cores. Should this be split into 4 or 8?I was planning to move the system DBs off the c:\ where they were installed by default and placing them on the same drives as the user DBsShould I split the Temp DB data files accross drive arrays?In an ideal world I would have a nice raid 10 config on it's own channel for each and every db but I am stuck wiht the server as it is.So how should I distibute my DBs for best perfromance.Cheers D |
|
|
cornall
Posting Yak Master
148 Posts |
Posted - 2009-11-27 : 05:27:47
|
| The transacion logs are in simple mode. Could we change the log drive to raid 0? |
 |
|
|
support.sql
Starting Member
15 Posts |
|
|
cornall
Posting Yak Master
148 Posts |
Posted - 2009-12-07 : 05:36:47
|
| Cheers very helpful doc :-)Dave |
|
|
|
|
|
|
SQL Server Database location best practice