Post reply

log for tempdb is full

  • April 5, 2016 at 9:28 am

    #1869851

    coolchaitu (4/5/2016)

    Dear Gail Madam,

    How to know which query caused tempdb to become full 1 hour back?

    GilaMonster (4/5/2016)

    coolchaitu (4/4/2016)

    Dear Experts,

    Also, is there a way to find what caused tempdb to become full last night?

    What kind of monitoring do you have on this server?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • April 7, 2016 at 5:45 am

    #1870407

    What is the current size of the TEMPDB ldf file, what is the growth size? Is it set to autogrow?

    To figure out what is causing it to grow you need to know what is running that causes this. You will need to use SQL Profiler to capture activity of what is going on to help narrow down the process. Activity monitor can also help if you have some suspicions of which database and know about what time of day it happens.

Viewing 2 posts - 16 through 16 (of 16 total)

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