Post reply

Tempdb

  • October 29, 2008 at 2:05 am

    #383256

    hi,

    My tempdb size is 2282 MB and space avaialble is 2169 mb. Still I am getting an error "Temp db full" . can any one guide me why? and what steps will i do to avoid this?

  • October 29, 2008 at 6:22 am

    #891147

    1) Check the data and log file size.

    2) Check whether the AutoGrowth is ON for database and log files?

    3) Check the free disk space.

    4) Check whether there is any open transaction.

    5) Add addtional files if needed.

  • October 29, 2008 at 6:24 am

    #891149

    [font="Verdana"]Restart SQL Server, because TempDB is recreated whenever SQL server restarts

    Mahesh

    [/font]

    MH-09-AM-8694

  • October 29, 2008 at 4:43 pm

    #891536

    Is autoshrink option turned on for tempdb database? What is the edition of sql server you are running on? Is there any transaction running at that time which is making heavy use of temp tables, sorting or temporary objects creation?

    MJ

  • October 29, 2008 at 6:54 pm

    #891558

    Don't ever turn autoshrink on for TempDB... talk about fragmentation!

    Check the log file (LDF) for TempDB... is that what's actually full?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

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

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