How to keep track of Locks in MS SQL Server?

Question

SQL Server

I know that you can see the blocking by right clicking on the database --> Reports --> Standard Reports --> All Blocking Transactions.
But if there are a lot of databases, and it is necessary to detect locks as quickly as possible, what can be done? Is there a way to set up email notifications?

Answer 1

Maybe you can set it up somehow?

You can not somehow, but very hard to force developers to write correctly.