sqlserver probe status of database not displayed correctly

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

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

Environment

Release : 8.51

Component : UIM - SQLSERVER

Resolution

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.

 

<ABC>

      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

   </ABC>

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