April 6, 2013 at 1:11 am
how to know(analyse performance) how many tempdb files creation are efficient?
April 6, 2013 at 1:33 am
April 6, 2013 at 1:59 am
actually i needed the way to check performance after creating 2 tempdb files or 4 temp db files to know which is efficient..please suggest me way to check it..
April 6, 2013 at 3:14 am
Use the link given above, specifically the page titled "Identifying Contention on Allocation Structures Using Wait States". As stated in the other thread, allocation contention is the main reason to split TempDB. If you don't have allocation contention, there's little reason to split the files at all.
Read the entire presentation, there's a lot of useful info in there.
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 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply