No 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...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by
on
Thu, Jul 12 2007
Filed under:
Filed under: sql server, fillfactor, indexes, trace, alerts, trigger, usage, tempdb, allocation, requirement