Etienne Lopes wants to see what the hold-up is:
Blocked processes (and deadlocks) are often one of the main factors responsible for performance issues in the databases, as such, it’s really important to monitor them effectively and if they exist then understand where, what, why, how often, duration, etc. Having that information will greatly help in the following fine tuning process.
In this post I’ll show one way to easily monitor blocked processes in an Azure SQL database.
Click through to learn how.