MSSQL_STMT_LONGRUNNING

Statement running for time > value (seconds) rule

Alert Message

Statement (sid=@session_id@, user=@login_name@, app=@program_name@) has been running over @VALUE@ seconds (start=@start_time@).

Detail View

Current Executing Stmts

Default Rule Properties

Severity 20
Event Type SET / RESET
Refresh 30 seconds
Occurrence Window 1 / 1
Enabled Yes
Attributes DMV

Source Collection

DMV_CURRENTSTMT