2 added "sybase-ase" tag
| link

What are the things to looks for or capture when there are blockages in Sybase.

1
source | link

What are the things to looks for or capture when there are blockages in Sybase.

Currently i look for SPID which are blocking other spid's,enable traceon(3604) to capture SQLTEXT, Showplan.

If blockages keep re-occuring over time especially when certain query is executed, what are the next steps forward?

Thanks