In this article, we have divided into 5 steps:
1. Blocking Definition
2. Query to check blocking in Sybase
3. Get the showplan(query plan) in Sybase
4. Get the SQLText of Sybase process ID.
5. How to kill the Sybase process id which is causing blocking.
1. Blocking Definition:
“Blocking” means that one connection is holding a lock on a resource when another connection wants to read or write to it.
Continue reading How to check blocking Sybase