Home Forums SQL Server 2014 Administration - SQL Server 2014 Tempdb data file fills up very often RE: Tempdb data file fills up very often

  • August 17, 2013 at 3:12 pm

    #1642438

    p.swathi4 (8/17/2013)

    Tempdb has 30GB drive and it ran out of space.

    So i had to shrink the tempdb database.

    TempDB grows to fit the need. For example, it's used for certain types of joins, index and tables spools, and a whole lot of other stuff.

    That being said, the "need" might be the problem. If you have queries with accidental many-to-many joins, the "need" will be great to store that data temporarily in TempDB. You need to find such queries and fix them or shrinking TempDB will be to no avail.

    --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)