• Don't kill any dormant processes (only as a last resort). There is a reason SQL doesn't clean them up itself...

    It looks to me that one your queries could be missing a COMMIT statement...this often causes a large transaction log (if the cause isn't otherwise obvious).