Orphaned Distributed Transaction Found

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

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

Any suggestion from Aireforge should be thoroughly tested before being implemented into production.

Further Reading

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