Reduce the Contention on tempdb with Trace Flag 1118: Take 2

(Linchi Shea) My earlier attempt to see what’s going on with trace flag 1118 on SQL Server 2005 SP2 (9.00.3042) didn’t take me too far because the results were not conclusive. I was motivated by seemingly conflicting suggestions from KB article Q936185 and whitepaper Working with tempdb in SQL Serve

Read More - Register for Free Membership