Home Forums SQL Server 2008 SQL Server 2008 - General File group is running out of space frequently. RE: File group is running out of space frequently.

  • September 3, 2015 at 5:06 pm

    #1824510

    EasyBoy (9/3/2015)

    I had a talk with senior person today. And he said they configured Limited file-growth to Unlimited. But at that time they were getting Drive space full alerts. And now they changed to limited growth and getting File group is running out of space alerts. I think as Gail suggested best thing is to setup trace file to check what is running against temp during that time.

    Thanks all for your input.

    I'd bet credits to Navy beans that it will be some query that using a DISTINCT in it to overcome duplicate results in the return. The duplicates are usually caused because of a misunderstanding about the data and people end up doing accidental many-to-many joins (which are formed in TempDB usually as hash tables), which are also known as "accidental Cross-Joins.

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