Got problems with SQL Server tempdb? Here are some resources
- 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.



There are no comments for this entry.
[Add Comment]