• On a general note. In the article that you suggested, there is line where its says

    undistributed transaction is causing the Log Growth. how can i check if which undistributed LSN ((43831:51:1) in my case) provided in DBCC OPENTRAN output is pointing to DDL operations of type ALTER TABLE.

    how can i relate and compare the LSN in OPENTRAN with DDL Operation

    Sorry for multiple threaded question. I was trying my luck on that thread but could not get my answer there.