Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning Need Help! ETL Stored Procedure Used to Work but Now Very Slow RE: Need Help! ETL Stored Procedure Used to Work but Now Very Slow

  • July 24, 2016 at 1:51 pm

    #1891733

    1. What are the log file settings for initial size and growth?

    2. What are you deleting and why?

    3. Are you doing proper backups that include log file backups? If so, what's the schedule? If not, when are you going to make one?

    4. Are you doing statistics maintenance? If so, what is it?

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