On daily basis, my ASE server is getting below commands blocked, during night 2:00 AM - 3:00 AM IST. As we do not support during night, its bit difficult to identify exactly which processes/programs are causing issue on this server.
Is there any way that i get the detailed info of process/program that is causing above issue using sybase utilities or any other method. Please confirm.
You have no idea what exactly scheduled jobs run, at 02:00 ?
The shell script would work. Execute sp_who, sp_lock and sp_transactions every minute, that way you can "see" the lead up to the problem, not just the problem after it happens. It is pretty much standard practice.
If a DUMP TRAN is being blocked, it is probably colliding with a DUMP DATABASE or (even worse) another DUMP TRAN. Either of these are stupid errors resulting from the dump script or threshold stored proc being very poorly written. Easily corrected.