There is overhead associated with creating objects in tempdb.  Sometimes this overhead surfaces as pagelatch contention – most commonly in PFS, GAM, or SGAM pages.  Tuning to alleviate PFS, GAM, or SGAM contention isn’t so much the topic I’ll be writing about; however, this will help alleviate the pressure on tempdb. What is tempdb caching? […]