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 ...

    • How do I monitor an Oracle database hosted in a Docker container in the same machine?

      To monitor your Oracle Database hosted in a Docker container, follow these steps: Log in to Site24x7 and install the Site24x7 Linux monitoring agent. Execute the following command in your terminal and enter your Oracle Database instance's username ...

    • Troubleshooting false positive alerts in monitoring

      Problem False positive alerts are being generated. Possible cause The monitoring system is down in some locations. The Website monitor might be configured for one location, such as Seattle, but may appear down when accessed from another location, ...

    • How to identify and resolve conflicts between other APM products and the APM Insight .NET agent

      Problem statement: You are experiencing either of the below issues and suspect that another APM product is interfering with the Site24x7 .NET agent. 1. The .NET monitor is not created under APM > APM Insight > Applications, even after the .NET agent ...

    • Amendments to Site24x7 Monitor Names

      We've recently renamed a few of our Monitors to help keep in sync with the current IT and DevOps trends. The new monitor names are designed to correctly resonate with the IT & DevOps crowd. We've made necessary changes in the Web client, Help ...