SYB_MDA_BLOCKTREE_WAITER

Waiter exceeds time thresholds waiting on process rule

Alert Message

spid #@SPID@ has been waiting @TIMEBLOCKED@ seconds on spid #@BLOCKERSPID@ for table @TABLEDBNAME@..@TABLENAME@ (@LOCKTYPE@, @LOCKLEVEL@, page=@PAGENUMBER@, row=@ROWNUMBER@). \

Detail View

Blocked Processes

Default Rule Properties

Severity 20
Event Type SET / RESET
Refresh 60 seconds
Occurrence Window 1 / 1
Enabled Yes
Attributes MDA;!CEINST

Source Collection

MDA_BLOCKTREE