DX Infrastructure Manager

Expand all | Collapse all

Monitor the blocking of SQL sessions on servers

  • 1.  Monitor the blocking of SQL sessions on servers

    Posted 01-02-2019 05:18 AM


    Hi Folks,

     

    We have a requirement of monitoring the SQL servers for blocking of sessions. We need to configure an alert whenever the session on any SQL server is blocked. Can we implement this with any of the available metrics of sql_server probe 5.10. If no, please suggest us a way to achieve the monitoring of session blocking on sql servers.

     

    Thanks in advance,

    Padmaja.



  • 2.  Re: Monitor the blocking of SQL sessions on servers

    Posted 01-02-2019 04:08 PM

    The sqlserver probe does have the ability to alarm on Blocked Users "Monitors the number of user blocked". Perhaps that can fulfill the need.