sqlserver probe status of database not displayed correctly
search cancel

sqlserver probe status of database not displayed correctly


Article ID: 137855


Updated On:


DX Unified Infrastructure Management (Nimsoft / UIM)


On sqlserver probe status of database is not correctly displayed when database service is down and the probe detects as green which is normal status instead of alarm status


Release : 8.51

Component : UIM - SQLSERVER


sqlserver :5.42

Hotfix sqlserver-5.42HF3 

Additional Information

In connection section retry was = 3 and timeout  = 180 sec, so when instance will be down in that case probe will try to connect three times and each time it will wait for 180 sec i.e 3 min after that check_dbalive will generate an alert.



      user = ####

      password = ####

      auto_domain = no

      description = abcd

      conn_string = abcd

      retry = 3

      retry_delay = 5 sec

      winauth = 1

      encryption = yes

      enable_CrossDomain_conn = no

      timeout = 180 sec

      monitor_AlwaysOn = yes

      is_AlwaysOn = 0

      tls_enable = no


After reducing the retry and timeout for the connection, it worked as expected.