Home Forums SQL Server 2008 SQL Server Newbies Log file R drive- What is consuming it RE: Log file R drive- What is consuming it

  • November 22, 2017 at 6:14 am

    #1969154

    coolchaitu - Tuesday, November 21, 2017 10:45 PM

    Jeff Moden - Monday, November 20, 2017 4:00 PM

    @coolchaitu ,

    I see you've flagged two posts as the answer, so I'm curious...  What did you actually come up with?  What was it that was causing your R: drive to fill up?

    It was a huge ETL load that was causing

    Thanks for the feedback.  That still begs to question how big the R drive is because even a "huge" ETL load should not be causing extreme log file usage.  Unless your R drive is only a couple of gig in size, that ETL process may have some serious problems.

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