Home Forums SQL Server 2017 SQL Server 2017 - Development Tempdb growth RE: Tempdb growth

  • December 26, 2017 at 6:04 am

    #1973406

    haichells - Monday, December 25, 2017 10:14 PM

    Hi,

    I have a huge insert/update operation performing in set of tables. The process tooks almost 1-2 hours to complete. Meanwhile tempdb is growing fast and most of my applications using the sql server gets hung during that time.

    To overcome this Replacing the stored procedure with SSIS will help in my scenario???

    Please share your valuable inputs. Thanks in advance!

    Chelladurai

    No.  It won't help if you do similar as to what you did in the stored procedure.  What needs to happen is you need to step back and look at the code.  Code that blows out TempDB is a very strong indication that you have some accidental many-to-many joins and you need to fix that problem no matter what you use.

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