data-konzept

'Blocked processes are often a big problem to DBA’s. They are difficult to monitor. We receive desperate calls saying “Everything is slow!” and before we can do anything a second call “Oh, don’t worry, it’s everything ok again”.

Most of times it happens because ill-behaved process that blocks other tasks for short periods. How can we find this kind of problem?'...

https://www.simple-talk.com/blogs/2016/05/02/how-to-find-blocked-process/