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.
For more content like this from Charlie Arehart:
Need more help with problems?
- 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
- 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