We are running Umbraco CMS which is hosted on Azure. When we publish lot of contents together, we see application become unresponsive. We don't see any blocks but we see a lot of sessions are sleeping status with opentransactioncount.

In other words we see lot of sessions are sleeping but have transactions opened.

select * from sys.dm_exec_sessions where open_transaction_count > 0 and status='sleeping'

What should we do in this case as this is CMS, so SQL are from CMS not from us? Also, as I said there is no blocking at all.

I am reposting a question form DBA stackexchange https://dba.stackexchange.com/questions/318464/open-transactions-with-sleeping-status