SQL server blocking and long running sessions alert on SAM

Is there a way to enable/configure alerts for  blocking and long running sessions alert on SAM for SQL server.

Parents
  • Yes,deadlocks and such should be included in the out-of-the-box alert "Alert me when a component goes into warning or critical state". You can however create a more specific targeted alert for such conditions as shown below.

    Locks.png

    Similarly, you can do the same for long running queries. The below example is fairly broad, but can be made more narrowly focused to alert only on specific queries, individual hosts, etc.

    Average Execution Time.png

Reply
  • Yes,deadlocks and such should be included in the out-of-the-box alert "Alert me when a component goes into warning or critical state". You can however create a more specific targeted alert for such conditions as shown below.

    Locks.png

    Similarly, you can do the same for long running queries. The below example is fairly broad, but can be made more narrowly focused to alert only on specific queries, individual hosts, etc.

    Average Execution Time.png

Children