Return
-
Title
How is the time for the Sybase Alarm for Blocked_User calculated? -
Description
How is the Blocked_User time calculated or measured by the Sybase agent? -
Resolution
The Blocked_User time is being retrieved from Sybase time_blocked field from master.dbo.sysprocesses table via an agent query on the instance. It is recorded and reported in seconds.
Example:
SELECT * FROM master.dbo.sysprocesses
WHERE time_blocked > 10 -
Additional Information
http://infocenter.sybase.com/archive/index.jsp?topic=/com.sybase.help.ase_15.0.tables/html/tables/tables50.htm time_blocked | int null | Time blocked in seconds.