Orphaned Distributed Transaction

An orphaned distributed transaction has been found, which can lead to performance and stability issues. Try to locate the cause and use the generated KILL query to remove it. If that fail, try to remove the transaction using Component Services (see Further Reading),

Suggested Action

💡 Aireforge Advisor can automatically generate a script for this.

Track down the orphaned DTC session and close it, or kill the connection.

How to Kill an Orphaned Distributed Transaction Connection

KILL 'D5499C66-E398-45CA-BF7E-DC9C194B48CF';

Further Reading

​How to Kill a Blocking Negative SPID in SQL Server | MSSQLTips.com

KILL (Transact-SQL) | Microsoft Docs