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),
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.
How to Kill a Blocking Negative SPID in SQL Server | MSSQLTips.com