I found great article written by Jimmy Harper which in short states that:
- There is a rule which is targeted at DB Engine which checks for Application event ID 1205
- These Events are not triggered out of the box, so we must “do some stuff on SQL “
If you want to get details on how to do it, you can visit this post.
All the credits go to Jimmy