• Admingod - Monday, March 27, 2017 1:36 PM

    Thanks for everyone for the replies. The log growth is happened during index maintenance plan. However, trying to find what particular index is causing the log growth. I load the results in the table. I have list of indexes which were rebuild. But not able to find what particular index is culprit for the growth any idea how to find that? Yes, its full recovery model and t log backups happens every 15 mins. Thanks in advance.

    I have to ask, what will you do with the information once you find it?  Stop rebuilding it?  Probably not. 😉

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