August 19, 2009 at 12:47 am
I understand that its best to have separate disk array for TempDB.
But If I have only two drives, which is the best option?
Drive 1: All data files (including tempdb.mdf)
Drive 2: All log files (including tempdb.ldf)
or
Drive 1: All data files
Drive 2: All log files + tempdb(Mdf and ldf)
August 19, 2009 at 2:00 am
you can go for option 2. 🙂
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
August 19, 2009 at 5:33 am
Is that two drives in addition to the operating system and server files location? If not, I'd put the OS on drive 1 and everything else on drive 2. Obviously not optimal, but you don't want to try to share data, logs or tempdb with the OS.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 19, 2009 at 5:43 am
Grant Fritchey (8/19/2009)
Is that two drives in addition to the operating system and server files location? If not, I'd put the OS on drive 1 and everything else on drive 2. Obviously not optimal, but you don't want to try to share data, logs or tempdb with the OS.
Grant, It is two drives in addition to OS. In that case what will be the best option?
August 19, 2009 at 6:27 am
I wouldn't say there was a "right" solution to this question, but, I'd lean towards option 2 above, or, possibly, depending on your system, a third option:
Data & Logs for everything on Drive 1
Data & Logs for tempdb on Drive 2
But that might be overkill for the situation. It really depends on what your code looks like, how much stuff like table variables, temp tables, cursors, your code is using, whether or not you're using snapshot isolation... In other words, just how smacked around is your tempdb?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 19, 2009 at 7:06 am
Thanks Grant. I got the point. I was asked how to place files for a new project and I actually did suggest that the safest bet was three different drives for log, data and tempdb separately.
I am a junior member in a large organization, so may not be much hope for my opinion, meanwhile I just wanted to learn, so I posted the question.
August 20, 2009 at 11:15 am
joeroshan (8/19/2009)
Thanks Grant. I got the point. I was asked how to place files for a new project and I actually did suggest that the safest bet was three different drives for log, data and tempdb separately.I am a junior member in a large organization, so may not be much hope for my opinion, meanwhile I just wanted to learn, so I posted the question.
I think your "large organization" needs to learn how to buy just a bit more server! 🙂
If the data were important would try to get a simple raid card and mirror the two drives (assuming they are identical) and put everything on them. Then at least you aren't at risk if a single drive fails.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply