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 |
|
nguyenl
Posting Yak Master
128 Posts |
 Posted - 2009-08-26 : 11:34:03
|
| Hi,Please help, I am trying to configure a SQL server. Currently I have:C:(raid1) = OSD:(raid1) =Ldfs, transaction logs, tempdb and logs.e:(SAN Raid 10) = Database mdfs.I would like to have another drive to just contain the tempdb but I don't have that choice. This database is read\write intensive.Please help.Thanks |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2009-08-26 : 13:32:40
|
| http://tinyurl.com/nqqzhthttp://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspxHow to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxFor ultra basic questions, follow these links.http://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-08-26 : 13:49:43
|
| since you don't have that choice, i'd put templog on the log drive and tempdev on the data drive |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-08-26 : 13:52:38
|
quote:
Originally posted by DonAtWork
http://tinyurl.com/nqqzht
why do people do that? if you don't feel like helping the guy out, why reply at all? or if you're going to give a link, just give a link to where the question was already answered. |
|
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2009-09-03 : 11:00:11
|
| Why do we do that? Because it answered his question, and gave him a ton of links to choose from, rather than give him something off the top of my head. I was pretty sure that the links from google would help.http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspxHow to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxFor ultra basic questions, follow these links.http://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
|
|
|
|
|
|
Server Best Practice