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.I was working with a client the other day where it turned out they had a HUGE SQL Server tempdb. I shared with them some pretty substantial and informative MS resources. In case this may ever happen to my readers, I wanted to pass them along:
- 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.