More about FIX: Concurrency enhancements for the tempdb database
Many people are wondering if they should apply this tempdb fix: http://support.microsoft.com/default.aspx/kb/328551
I recommend that you first decide if tempdb is your major concern.
use DBCC SQLPERF(waitstats). Here is an article but you need to be a subscriber to read it. it seems you can still download the code:
http://www.windowsitpro.com/SQLServer/Article/ArticleID/40925/SQLServer_40925.html
This is another place that talks about this command:
http://support.microsoft.com/default.aspx?scid=kb;en-us;271509
If you observe a lot of wait on "PAGELATCH_UP", then you can apply the fix. This is because Q328551 only reduces this type of contention.
There is another way of determining if you have a lot of wait in tempdb: do the following in a loop, once every second or so:
select lastwaittype, waitresource from sysprocesses where blocked !=0
Based on this sampling method, if you see a high percentage of page "2:1:1" or "2:1:3" in your output, then you have a problem. Apply the fix.
