September 17, 2010 at 10:27 am
Hello all,
I have a 16 processor machine, 16 temdb file, 1 log file, all on the same drive, I have several blocking process on tempdb, i believed that since i have so many tempdb files I will have less blocking sessions...
Thigs could be better If I add another log file? I was looking for the best practices on tempdb but i didn't find anything about that...
Thanks in advance
September 17, 2010 at 10:32 am
Adding a second log file won't help you. SQL Server fills the log file sequentially.
Try to identifty the cause for the blocking and try to reduce or eliminate it.
Thank You,
Best Regards,
SQLBuddy
September 17, 2010 at 10:38 am
ricardo_chicas (9/17/2010)
I have several blocking process on tempdb,
Blocking on what? What's the wait_resource? What's wait type?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 17, 2010 at 10:39 am
Thank you,
I found the cause but is something that I can avoid...
that means that adding more log file do not help in any way?
Thanks
September 17, 2010 at 10:45 am
GilaMonster (9/17/2010)
ricardo_chicas (9/17/2010)
I have several blocking process on tempdb,Blocking on what? What's the wait_resource? What's wait type?
Thank you, actually the blocking issue wasn't really that important, what i really want to know was the effect of having more log files
September 17, 2010 at 10:58 am
ricardo_chicas (9/17/2010)
that means that adding more log file do not help in any way?
No. Only use for multiple tran logs is when there's insufficient space on a single drive for the log. Multiple log files won't help performance.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply