SQL cluster monitoring

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

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

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

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

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

    • 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 ...
    • FAQs related to Windows Service monitoring

      After installing APM Insight Windows service monitoring agent , if you don't see data in the Site24x7 console, or if you are unable to add monitors, kindly follow the below given steps to troubleshoot. If few monitors are not getting added: Check for ...
    • FAQs related to Docker application and Docker agent

      What is the necessity to have an exclusive docker agent? When changing from monolithic application deployments to cloud native microservices using AWS ECS, Kubernetes etc., an exclusive monitoring agent would prove to be more secure and flexible to ...
    • Comparison between Site24x7 VMware Monitoring and VM monitoring using Site24x7 server agent

      Site24x7 VMware Monitoring capabilities Site24x7 VMware monitoring is agentless. An On-Premise Poller acts as a probe to collect data and sends it to Site24x7. With Site24x7 VMware Monitoring, you will be able to: Monitor vCenter Monitor VMware ...
    • MySQL monitoring FAQs

      Please find below some common FAQ's related to MySQL monitoring from Site24x7: Does Site24x7 need write permission to access databases? No. Site24x7 needs SELECT permission for performance_schema, information_schema, and EXECUTE permission for sys ...