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 |
|
SamC
White Water Yakist
3467 Posts |
 Posted - 2005-05-03 : 11:07:59
|
| I'd like to know... - Who places SQL mdf and ldf on separate drives and who does not? - Why? |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-05-03 : 11:13:08
|
| Performance.At 4-6GB, I've left mine on a drive separate from the O/SAlso I would imagine if it was being hit very heavily, then I'd separate them...but then there are hardware converns to fully take advatages of thatBut it couldn't hurt to separate them to different drives...Brett8-) |
 |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2005-05-03 : 11:23:18
|
| We seperate them as well. If you have the luxury of being able to do it, I reccomend it. Brett gives good reasons to. I'd also add that if you have them on seperate drives then the size of your log file is less likely to become an issue. Your db and log file could grow to a point where they start competing for space before you can truncate the log file. The last thing you want mid day is for the server to start throwing errors that the log file is out of room. That's a great way to get your manager and all your end users to call you simultaneously.Mike"oh, that monkey is going to pay" |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2005-05-03 : 12:27:11
|
| I do as well. I'm actually thinking of separating TXLogs, Data, and Indexes on to separate drives as well.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2005-05-03 : 13:14:53
|
quote:
Originally posted by MichaelP
I do as well. I'm actually thinking of separating TXLogs, Data, and Indexes on to separate drives as well.
You must have a lot of empty drive bays.I didn't know index files could be separated from the mdb. |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-05-03 : 13:30:08
|
| Sure...ON [Primary]ON [Secondary]ON [Prancer]ON [Dancer]ectBrett8-) |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2005-05-03 : 14:43:25
|
| ^^ What he said.Yeah, you need lots of drives and deep pockets, but from what I understand it's HELLA fast if done right. Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
|
|
|
Polling for answers