I was asked by our development team... "How do we check for runaway stored procedures?".

the only thing I can think of is run the following query.

- select * from syslogs hold

Is there any other way in Sybase to check if there are procedures that are "runaway" stored procedures?

Is the best way to see if a stored procedure has frozen / hung is by using sysprocesses?

For example,

select spid, status, suid, cmd, cpu, physical_io, dbid, loggedindatetime from sysprocesses


What do you think? Thank you.

First, find all the rows in sysprocesses where the status is not "sleeping" or "recv sleep" - this will find all the spids that are currently active (i.e. not waiting for user requests). You can then refine the search from there, for example using the cpu and physical_io columns, as well as the blocked column to find "interesting" processes.

Michael

Thank you for your feedback and advice. I will use the method you recommended.