Post reply

Tempdb 99% full

  • May 11, 2016 at 9:49 pm

    #310623

    Dear Experts,

    Tempdb is 99% full. I have read in Brent Ozar's website that we shouldnt be shrinking tempdb. Please let me know how to fix this.

  • May 11, 2016 at 10:03 pm

    #1878430

    coolchaitu (5/11/2016)

    Dear Experts,

    Tempdb is 99% full. I have read in Brent Ozar's website that we shouldnt be shrinking tempdb. Please let me know how to fix this.

    Suggest you add first add a file to the tempdb so it does not run out of space. Then you should run Adam Mechanic's sp_WhoIsActive to find out what is bogging your tempdb and ones you know then you can take action. Shrinking tempdb is pointless in this situation.

    😎

  • May 11, 2016 at 11:43 pm

    #1878438

    I found a similar thread here, take a look: http://www.sqlservercentral.com/Forums/Topic1182382-1550-1.aspx

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

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