locked
How to chnage Wait Time in Blocking Sessions Monitor for SQL? RRS feed

  • Question

  • Hi

    I use SCOM 2012 and System Center Monitoring pack for SQL Server

    I need use:

    Blocking Sessions Monitor

    This monitor checks blocking sessions every 300 seconds (Interval). If there is a blocking session that is blocked more than 1 minute (wait time) and the amount of such blocking sessions is more or equal to 1 (Number of blocked session), then the monitor changes state to Critical.

    The following parameters are overridable.

    Parameter

    Default value

    Alert On State

    Critical

    Alert Priority

    High

    Alert Severity

    Critical

    Auto-Resolve Alert

    True

    Generates Alert

    True

    Enabled

    False

    Interval (sec)

    300

    Number of blocked sessions

    1

    Wait Time (min)

    1

    Synchronization Time

    Timeout (sec)

    300

    How to change Wait Time (min) to Wait Time (sec)?

    I can not change the value Wait Time (min) from 1 to 0.1, because the value type Integer ((

    Tuesday, December 4, 2012 5:02 AM

Answers

  • You need to disable this monitor and create your own.

    http://OpsMgr.ru/

    • Marked as answer by Vaylandt Artem Wednesday, December 5, 2012 2:43 AM
    Tuesday, December 4, 2012 8:13 AM

All replies

  • You need to disable this monitor and create your own.

    http://OpsMgr.ru/

    • Marked as answer by Vaylandt Artem Wednesday, December 5, 2012 2:43 AM
    Tuesday, December 4, 2012 8:13 AM
  • SQL MP is a sealed management pack and also the unit of wait time setting is in minutes. This means that you cannot modify the wait time from 1 minutes to 1 seconds. The only available option is to disable this monitor and create your own one.

    Roger

    Tuesday, December 4, 2012 8:34 AM