June 26, 2006 at 7:57 am
I have 'tempdb' and 'templog' togther on their own drive. Is there still more gain from seperating them out?
We currently have this set up (seperate volumes):
C: SQL Binaries, Master, MSDB etc
D: Lookup Tables
F: TempDB and TempLog
G: LDFs for lookup tables and data tables
H: Main Data Table
I: Ancillary Data Tables
June 28, 2006 at 3:47 am
Presumably, since you have tempdb (data and log) on its own drive, your application makes heavy use of tempdb. Now you need to find out how much of that activity is writes compared to reads. Use perfmon or Profiler to get an idea of this. If it's mainly reads, the log isn't going to be doing much and therefore shouldn't need its own drive.
Alternatively, ask your application vendors whether they think it's worth separating the data and log files out.
John
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply