Automatically killing and/or reporting blocking processes

[Rob Osattin]

We've started seeing blocking processes in one of our 12.5.0.3 servers. The application and database design are all 3rd party so we have to live with what we have.
Does anyone know of freeware or commercial software to detect and report on blocks? The option to kill the blocking process would also be nice.
I know that scripts could be written to parse sp_who output and generate the kills and we'll probably end up writing something.
But before starting that project (it's a project because we'd end up writing some sort of tool to display or generate an alert that processes are blocked for more than a configurable amount of time. It's either automatically kill the blocking processes or allow the users to kill them without issuing the kill themselves), I thought I'd find out what's available from the Sybase community.
Thanks,
Rob Osattin
Atlanta Journal-Constitution / Cox Media Group
Atlanta, GA

[Antony]

Blocked processes are a common problem - but generally the answer is not just to kill a predetermined process. Even with a 3rd party developed app you can usually look at ways other to "manage" the situation.

I don't know of any publicly available tools to do what you ask - I have always written them myself. Many tools will report on blocking, some will allow a kill - none that I know of will let you do that automatically (and rightly so, in my opinion).