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 version 18.0.0, your SQL cluster will automatically be marked up for monitoring.
I now have an active node and three passive nodes being monitored, as four separate monitors. How will they be monitored after an upgrade?
Once upgraded to agent version 18.0.0, all the four monitors will be treated as a single monitor. The remaining three monitors will be suspended and you can only view historical data for these monitors.
My SQL server is clustered, but it is added in the Site24x7 web client as a standalone monitor. How do I correct this?
Log in to Site24x7 and go to Server > Server Monitor > Servers > click on the associated server monitor. Beside the display name, hover on the hamburger icon and click on Discover Applications. This will automatically convert the standalone SQL monitor to SQL cluster monitor.
Note - If there is a cluster monitor already being monitored by Site24x7, then this monitor will be added to the already added cluster, and not as a new cluster monitor.
In case I do not have any add ons left, what will be the current state of my monitors?
By default, if you have a free "Advanced Monitor" in your account, the migration will automatically consume that license. You will need to take no extra action. To check how many Advanced Monitors you have left in your account, go to Admin > Subscriptions.
For those who do not have any add-ons left, we are offering time till September 30th, 2017 to upgrade your account. Post that, your monitors will be suspended when you make changes to it.
Now that you have introduced SQL cluster monitoring, what will happen to my stand alone SQL monitors?
They will be monitored like before. There will be no loss of data, but only a licensing change. Microsoft SQL server monitor will be treated as an Advanced Monitor.
Related Help Documentation:
Related Articles
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, ...
Response time in Website monitoring
In website monitoring, response time is calculated as the total time taken to resolve the DNS, complete the TCP hand-shake, negotiate an SSL handshake (for HTTPS) and download the full HTML output from the server. However, it does not include getting ...
Roles supporting tunnel management and path data in VMware VeloCloud SD-WAN
Introduction In VMware VeloCloud SD-WAN, the ability to create or modify tunnels and view path (tunnel) data depends on the user role. This ensures that configuration changes and diagnostic insights are restricted to authorized users. The table below ...
Exclude the selective SSH algorithms in On-Premise Poller during SFTP Transfer monitoring
By excluding SSH algorithms, you can restrict Site24x7 SSH Client from using the excluded algorithm while connecting to the SSH server during SFTP Transfer monitoring. Follow the steps mentioned below for SSH algorithm exclusion in On-Premise Poller ...
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 ...