Blocking detector


Job details

Name: Blocking detector
Platform: Sybase
Category: Performance
Description: This check helps identify processes that are blocking other processes. The ‘time_blocked’ column in system table master..sysprocesses is checked for processes with status ‘lock sleep’.
Long description:
Version: 1.1
Default schedule: 1,6,11,16,21,26,31,36,41,46,51,56 * * *
Requires engine install: Yes
Compatibility tag: .[type=‘instance’ & databasetype=‘sybase’]/instance[maj_version > ‘11′ & hasengine=‘YES’]

Parameters

Name Default value Description
warning threshold 3 The maximum number of minutes a session can be blocked before a warning is triggered.

Job Summary

select spid, status, suser_name(suid) as login, hostname, program_name, cmd, blocked, dbid, uid, tran_name, time_blocked, priority, loggedindatetime, ipaddr from master..sysprocesses where suid>0 and status='lock sleep' order by time_blocked desc

Details of Implementation

Monitoring Scope

Frequency of Execution

Dependency and Cleanup

Parameters and Threshold

Result Presentation and Reporting

Database Object Database Name Page Type SPID Class
object name database name page type spid class

Additional Output

On-Failure Handling

Comprehensive Impact