October 17, 2014 at 11:27 am
Hi everyone, I've got some questions. Have searched around but still am not clear on how best to place my data. I know that it all depends on this and that but in general, what do you suggest?
I've been building my physical servers this way:
Local disk (300GB)
C: 100GB <OS>
D: 200GB <SQL Server program files>
SAN
E: <SQL Data> 64k allocation
L: <SQL Logs> 64k allocation
T: <Tempdb> 64k allocation
Couple of questions please.
Should system databases go on E with the user databases or T with the tempdb files? Does it matter?
Should the tempdb log file go on T with the tempdb data file or on L with the user db log files?
Thanks for reading. Looking forward to seeing some of you at PASS Summit 2014.
October 17, 2014 at 1:02 pm
PHXHoward (10/17/2014)
Hi everyone, I've got some questions. Have searched around but still am not clear on how best to place my data. I know that it all depends on this and that but in general, what do you suggest?I've been building my physical servers this way:
Local disk (300GB)
C: 100GB <OS>
D: 200GB <SQL Server program files>
SAN
E: <SQL Data> 64k allocation
L: <SQL Logs> 64k allocation
T: <Tempdb> 64k allocation
Couple of questions please.
Should system databases go on E with the user databases or T with the tempdb files? Does it matter?
Should the tempdb log file go on T with the tempdb data file or on L with the user db log files?
Thanks for reading. Looking forward to seeing some of you at PASS Summit 2014.
The default in the sql server installer is to put tempdb data and log file on the same drive, if you have separate volumes for the data and the log then all well and good.
Keep both TempDB files away from the user database files.
Where are you putting your SQQL Server database backup files?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 17, 2014 at 2:22 pm
Thanks for the info.
We back up to NAS.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply