MicrosoftMicrosoftHi Jose,
I encountered a problem when I upgraded an application against the backend Azure SQL Database. The upgrade process complained there were active connections in the database so that the upgrade could not continue. But there weren't any running sessions after checking. I only could see a couple of sleeping sessions in the "user" database and a running session in "master" database. I don't think the running session in "master" database can block the upgrade in the "user" database. Maybe, as you said, a sleeping session can hold open transactions for extended periods. That is why the upgrade process was blocked.
Thank you for your sharing,
Ray
