Got problems with SQL Server tempdb? Here are some resources

Note: This blog post is from 2008. Some content may be outdated--though not necessarily. Same with links and subsequent comments from myself or others. Corrections are welcome, in the comments. And I may revise the content as necessary.

• Working with tempdb in SQL Server 2005 - a 21-page Microsoft TechNet article, with lots of info on understanding, configuring, maintaining, and troubleshooting problems with tempdb. While written for SQL Server 2005, it could be useful for those on 2000 or 2008 as well. (Should that link ever fail, here's another.)
• Troubleshooting Insufficient Disk Space in tempdb
• For more on how its usage has increased for SQL Server 2005, see Capacity Planning for tempdb
• Finally, for more on managing its growth, see Optimizing tempdb Performanc

You may want to check out several other equally useful TechNet articles on SQL Server (like the first one above, but available on a wide range of issues).

Hope that's helpful to someone.

For more content like this from Charlie Arehart:

• Signup to get his blog posts by email:
• Follow his blog RSS feed
• View the rest of his blog posts
• View his blog posts on the Adobe CF portal

Need more help with problems?

• If you may prefer direct help, rather than digging around here/elsewhere or via comments, he can help via his online consulting services
• See that page for more on how he can help a) over the web, safely and securely, b) usually very quickly, c) teaching you along the way, and d) with satisfaction guaranteed