Day 5–Trace Flag 1118–Allocate Uniform extent to tempdb objects

Have you ever faced allocation contention problems with tempdb database in SQL Server 2000? If yes then you might be ended up with the recommendation to enable trace flag 1118** as per http://support.microsoft.com/kb/328551 or http://support.microsoft.com/kb/936185. By default when you create a temporary object it will allocate a single page to that object searching SGAM however… Continue reading Day 5–Trace Flag 1118–Allocate Uniform extent to tempdb objects