Post reply

Huge Tempdb size, how can I reduce this.

  • January 23, 2009 at 1:43 am

    #205724

    Hi,

    I am having a problem with the tempdb log file which gets really huge due to ETL operations on the database, I am looking to slightly alter this as I gather its order operations which makes the tempdb run out of space, IF I am attempting to alter the ETL application, what kind of DML statements should I be looking out for, as the tempdb is literally running out of space every few minutes, a size of around 100GB all the time.

    Thanks in advance

  • January 23, 2009 at 4:52 am

    #931716

    Hi,

    you must stop the server than temp.db will shrink.

    Ralf

  • January 23, 2009 at 4:58 am

    #931718

    Dont go for Restart if u are in production environment.Try shrinking the tempdb. Kill those connection from that application and investigate on the query which is causing this problem.

  • January 23, 2009 at 9:12 am

    #931860

    If the above suggestions dont work for you there are other methods listed by Microsoft. Each of these methods do require DT.

    http://support.microsoft.com/default.aspx/kb/307487

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

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