Post reply

tempdb initial size

  • July 19, 2007 at 7:21 am

    #69853

    What would cause the initial size of my tempdb to be 32gb on boot?

  • July 19, 2007 at 7:23 am

    #720745

    What is the size of model database? Also check if there are any procedures running with hash table being called.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • July 19, 2007 at 7:33 am

    #720758

    Two instances 16gb and 6gb

  • July 19, 2007 at 9:34 am

    #720823

    By default, initial size of tempdb after restarting is 8 MB. However, if its size is set to different value, the initial size of tempdb after restarting will be the set value.

    The value in the model database is the initial size while creating a new user database. It has no effect on the initial size of the tempdb, if someone changes it, after restarting.

     

  • July 19, 2007 at 9:43 am

    #720827

    I concur with SQL_Oracle above. That's been the way I've always seen it work.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply