It’s well known that one of the common performance issues that can affect tempdb is allocation bitmap contention. I discuss this, and ways to alleviate it, in these posts: The Accidental DBA (Day 27 of 30): Troubleshooting: Tempdb Contention Misconceptions around TF 1118 Tempdb configuration survey results and advice The current best advice around adding … Continue reading Correctly adding data files to tempdb