I have an SQL Cluster that is UP and running. But the Insight monitor is indicating DOWN.

I have an SQL Cluster that is Up and running. But the Insight monitor is indicating Down.

If the SQL Cluster Insight monitor is indicating DOWN even after giving credentials, check the following cases:

  • Please check if you have given credentials in both the active and passive nodes. If the credentials have been updated only in the passive node, then the insight monitor will indicate Down.

  • If the credentials are updated in only one node that was once active, the Insight monitor will indicate Down when that node becomes passive. If you only give the credentials to all the nodes in the SQL cluster setup, the failover can be detected and reflected in the insight monitor.

  • Irrespective of the number of nodes in your cluster, only one SQL Insight Monitor will be added for monitoring. When the failover occurs, the active node will start sending the insight metric data.

 

Refer to the SQL insight monitor troubleshooting article for more information.

 

If you still face issues, please zip the entire <agent installation dir>\monitoring folder from the active node of your SQL cluster and send it to support@site24x7.com.

 

    • Related Articles

    • Unable to add SQL insight monitor

      If the SQL Insight monitor is not getting added even after entering your credentials, try these troubleshooting steps: Ensure that the Auto-discover applications feature is enabled. If not, you will need to trigger discovery using the Discover ...

    • I can only see a limited amount of MySQL database monitors added. How to add new databases for monitoring?

      By default, MySQL instances will be auto-discovered and added as free monitors. MySQL data collection and monitoring will start once the agent is provided with the proper credentials. Check this article on how to add or update credentials. New ...

    • APM Insight provides information on the parameters it sends to the SQL queries

      The parameters in slow SQL queries can be tracked and displayed under the traces tab. We have the option to obfuscate the values of SQL query parameters using a configuration "Obfuscate SQL Parameters". It will be enabled by default. The screenshot ...

    • FAQs related to SQL cluster monitoring

      Please find below some common FAQ's related to the migration from stand alone SQL servers to SQL failover cluster:  Will my SQL clusters be monitored automatically now that you have released the feature? Yes, with an upgrade to the agent's latest ...

    • Security for SQL Server Monitoring

      Do I have to provide my SQL Server credentials for Site24x7 to monitor them? No, Site24x7 does not ask for your SQL Server credentials for monitoring. Does Site24x7 connect to the SQL Servers directly? No, Site24x7 does not connect to the SQL ...