http://msmvps.com/search/SearchResults.aspx?q=app:weblogs&tag=Alerts,indexes&orTags=0&o=DateDescendingSearch results for 'app:weblogs' matching tags 'Alerts' and 'indexes'en-USCommunityServer 2008.5 SP2 (Build: 40407.4157)/http://sqlserver-qa.net/blogs/tools/archive/2007/07/12/is-it-possible-to-estimate-the-space-requirement-for-tempdb-or-factors-that-are-affecting-space.aspxThu, 12 Jul 2007 05:00:00 GMTd67277c4-116b-43f1-b688-e9ef184ea916:1016994AnonymousNo straight answer to say yes you need so and so value to set on TEMPDB for such space requriement. By default i t is difficult to estimate the tempdb space requirement for an application. In general and one of the best practice is to allow 20% more space on tempdb as compared to the user database or number of user databases. There are various factors such as processes &amp; connections from your application that you need to consider for the space requirement in TEMPDB data files, the following are...(<a href="http://sqlserver-qa.net/blogs/tools/archive/2007/07/12/is-it-possible-to-estimate-the-space-requirement-for-tempdb-or-factors-that-are-affecting-space.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=1013" width="1" height="1" alt="" />