Tempdb growing out of control

  • CirquedeSQLeil (3/15/2010)


    Molly Cary (3/15/2010)


    Great! thanks. I am seeing that it's happening around 2-3 am.

    Do you by chance have an index rebuild job scheduled at that time?

    Yes, Index rebuild will grow TempDB, Technically TempDB should take\grow nearly 2 times the size of the biggest table in the database. However sometimes it will grow more than that.

    EnjoY!

Viewing post 16 (of 15 total)

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