Post reply

tempdb full

  • March 31, 2009 at 7:15 am

    #94749

    Hi experts,

    Please help me.Its urgent."tempdb" of one of our production server is seen growing.Just before sometimes it consumes full disk space.And as because of that we were forced to restart the server.after restarting it becomes fine.But it was seen that after sometime again the tempdb is increasing.Now also we restarted.Since a live application is running we cant restart the server like this anymore.So please help us.

    Why this tempdb is increasing.What we want to decrease the growth.Please advice. 🙂

    Thanks in advance

    [font="Comic Sans MS"]+++BLADE+++[/font]:cool:

  • March 31, 2009 at 7:33 am

    #969096

    Sounds like you need to profile the server to find out what's writing to the tempdb log.

    Facts are stubborn things, but statistics are more pliable - Mark Twain
    Carolyn
    SQLServerSpecialists[/url]

  • March 31, 2009 at 7:41 am

    #969102

    Carolyn,

    But it might took a long time to trace and correct errors.As it is a live server and tempdb is always increasing we cant wait.We are trying to shrink tempdb.But it doesnt work now.

    [font="Comic Sans MS"]+++BLADE+++[/font]:cool:

  • March 31, 2009 at 7:44 am

    #969109

    You need to trace this and find out which activity is growing tempdb. There is no other way, live server or not. Activity, and possibly large transactions using temp tables/variables, are causing tempdb to grow.

    Or you have it sized incorrectly for the level of activity and need to add more disk space.

    No magic here, no switch you can throw. It grows to the level needed to handle the peak activity.

    Follow me on Twitter: http://www.twitter.com/way0utwest
    Forum Etiquette: How to post data/code on a forum to get the best help
    My Blog: www.voiceofthedba.com

  • March 31, 2009 at 7:48 am

    #969118

    Thanks Steve 🙂

    we are working on this 🙂

    [font="Comic Sans MS"]+++BLADE+++[/font]:cool:

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

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