• coolchaitu - Friday, November 17, 2017 12:07 AM

     Is there a way to find out the spid/transaction that is eating up the drive

    It won't be a single session. The log grows if it can't be marked reusable by a log backup. First thing to do is see which DB's log file is large, and check why it can't be marked reusable. See John's post for details.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass