Post reply

Tempdb Full

  • July 22, 2009 at 2:43 am

    #212652

    Hello all,

    We have a situation here. On one of the instances, our tempdb got full yesterday. We tried to shrink it using shrinkdatabase/shrinkfile but of no help. Later we restarted the server with -c -f paramter and then we were able to control the files sizes. Again it's grown to 160 GB and is still growing.

    How do you suggest to move forward in finding the culprit? profiler? any other way forward?


    Pradeep Singh

  • July 22, 2009 at 2:46 am

    #1028145

    Hi Ps,

    Is it sql server 2000 or 2005. In 2005 we have better ways of monitoring the tempdb usage.

  • July 22, 2009 at 2:52 am

    #1028149

    Vee (7/22/2009)

    Hi Ps,

    Is it sql server 2000 or 2005. In 2005 we have better ways of monitoring the tempdb usage.

    Its 2005 enterprise edition. I need to find out what's causing massive growth. It's regularly growing filling the disk to capacity. No index rebuilding activity happening.


    Pradeep Singh

  • July 22, 2009 at 3:03 am

    #1028153

    http://technet.microsoft.com/en-us/library/cc966545.aspx

    http://blogs.msdn.com/sqlblog/archive/2006/09/25/whitepaper-working-with-tempdb-in-sql-2005.aspx

  • July 22, 2009 at 7:04 am

    #1028276

    thanks for the link. very useful.

    we found that tempdb growth is due to a ssis job which is using tempdb heavily. We're waiting from the developement team for further updates.

    In the meantime we're trying to investigate which exact queries are causing this.


    Pradeep Singh

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

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