'sp_who2 blkby -5 Azure SQL what is it? how to treat this?

There are somedays that I'd faced any SPIDS of mine blockeds by a SPID -5. I already try to search any documents but nothing.

This is my sp_who2 from SQL Azure

I've tried to list this GUID using sys.dm_tran_locks but, there is no GUID to SPID -5.

Sometimes, my queries used to stay SUSPENDED for 20~30minutes... and for no reason, the -5 goes off and my queries continue to the end.

anyone can help to understand what am I can do?

azureorphaned-objectssp-who2


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions