TheSQLGuru (4/6/2013)
Again I will say that the odds that tempdb contention is the PRIMARY cause of your slowness is VERY LOW compared to the myriad other causes.
Especially since this is SQL express, can only use a single core and hence is exceedingly unlikely to be capable of having allocation contention at all.
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