sp_xact_loginfo provides the span of oldest active transaction in terms of percentage of total log space.


sp_xact_loginfo dbid [, vcharparam1] [, vcharparam2] 
[, intparam1] [, intparam2][' span_pct] [, startpage] 
[, xact_spid] [, starttime] [, firstlog_page] [, stp_page]
[, stp_pages] [, stp_blocking] [, canfree_without_abort_pct] 
[, dump_in_progress] [, activexact] [, errorcode]


Note: For a Mixed Log Data (MLD) database, this procedure returns values equivalent to 0 in output parameters. This procedure is not supported or meant to be used for MLD databases.