SYB_LOG_HOLD_TIME

Transaction with log held for time > value (seconds) rule

Alert Message

Database (@dbname@) transaction (spid=@spid@, txn name=@name@) has been running for @secs_held@ seconds (starttime = @starttime@).

Default Rule Properties

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

Source Collection

LOGSHOLD