September 8, 2014 at 9:27 pm
Hello my Fella DBA's
I need your opinion. I just start a new job and most the Sql Server environments only have 3 San drives.
Being that I only have 3 drives what's your opinion on how I should place the Sql Server mdf/tempdb mdf/ tempd ldf/user database logs/backup files.
I plan to go with the option below. What's your opinion?
D:\data files
E:\user logs and tempdb logs
F:\backup files and 8 tempdb data files
Let me know what you think...
September 8, 2014 at 10:04 pm
robert rogers-466427 (9/8/2014)
Hello my Fella DBA'sI need your opinion. I just start a new job and most the Sql Server environments only have 3 San drives.
Being that I only have 3 drives what's your opinion on how I should place the Sql Server mdf/tempdb mdf/ tempd ldf/user database logs/backup files.
I plan to go with the option below. What's your opinion?
D:\data files
E:\user logs and tempdb logs
F:\backup files and 8 tempdb data files
Let me know what you think...
Why are you limited to 3 drives?
Also if there's a limitation due to multiple instances on host, you could consider using Mount Points as an option?
Something like this would be nice:
data drive
log drive
temp data drive
temp log drive
I mention splitting log/temp log because the writes that drive would not be sequential with 2 log files for 2 separate databases. It would jump between them, but since you're restricted to 3 drives you can only do the best you can with what you have.
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
September 8, 2014 at 10:50 pm
Trust me I wish I could add another drive but it's not going happen so I must do what I can with the 3 san drives.
September 9, 2014 at 3:10 am
if you're unable to split tempdb log from tempdb data files they should go on the same drive, this is also the default offered in the sql server installer
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply