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:
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.
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 am unable to see any data for failed jobs in my database
If you are unable to see data for failed jobs or if there is a mismatch between the failed jobs data in the SQL performance monitor and the SQL insight monitor, check if you have granted the necessary permission. Data in the SQL performance monitor: ...
Is it possible to monitor an Oracle Database running on a Windows Server using Site24x7?
For this, you need to do the following steps: Log in to Site24x7 and install the Site24x7 Linux monitoring agent. Ensure the Oracle Database on your Windows Server is accessible from the Linux machine. Execute the following command in your terminal ...
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 ...
Why am I getting an Authentication Failed error while trying to view the child database monitors?
When you try to view child database monitors, including Oracle PDBs, Oracle tablespaces, Microsoft SQL Server individual databases, MySQL databases, and PostgreSQL databases, you may encounter an Authentication Failed or You are not authorized to ...