• Steve-3_5_7_9 (7/19/2013)


    TempDB should be sized just like any other database. One should know their workload, or at least monitor the TempDB over several weeks to see what is a healthy size for it. Once this is determined, you then can set the size of the TempDB, so that when the server is restarted, it will be at the correct size, thereby having to use "auto grow".

    +1