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 |
|
dingrao
Starting Member
3 Posts |
 Posted - 2009-03-11 : 11:53:48
|
Hello all.This is my first time setting up a SQL server, and I was wondering if I could get any suggestions if I could be doing something better.Here is the server:Dell 295032G RAMWindows 2003 64bit 2003 Server EESQL 2005 EETwo 300 GIG drivesFour 450 GIG drivesWe are planning of having the 300's set in a RAID 0 config, with Windows, SQL and swap file on them.The 450's are going to be in a RAID 10 config for data only. Is this set-up the most effecient for data xfer speed?also, would you all suggest that I make a second partion on the 300's to use for the SQL log file?Any suggestions would be helpful.  Thanks all!Dean |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-03-11 : 22:27:55
|
| Use RAID 10 for Log files and TempDB files. |
 |
|
|
dingrao
Starting Member
3 Posts |
Posted - 2009-03-12 : 10:40:21
|
| Thanks for the suggestion. The lead engineer on this project was the best transfer rate to go along with data protection, that is why he was thinking we should go with a RAID 10.I'll pass along your suggestion of storing the log and TempDB files on the RAID 10. |
|
|
|
|
|
|
Set-up suggestions