How can we help you today? How can we help you today?

SQL Monitor 2.3 on Cluster

Oddness when SQL Monitor 2.3 is installed on our clusters.

In Add monitored server, I put in just the instance name.
The monitor correctly brings back the cluster and both nodes along with the correct instance names on each node (Active/Active set up)

On another cluster I do the same thing, but this cluster is active/passive.
Monitor correctly brings back the 2 nodes in the cluster as before, but the instance name is (local) and all the databases are shown as OFFLINE


I've tried removing it, entering the FQN of the server, editing credentials... nothing works.

Any ideas?



[/img]
Bgfreeman
0

Comments

9 comments

Sort by
  • priyasinha
    Hello,

    (local) is not an issue because it depends on whether the SQL Server instance is named or default. If it is default then it will be displayed as (local).

    Regarding databases being offline, is there any kind of clock skew between base monitor and any nodes of these clusters? Are there any connection errors?

    Thanks,
    Priya
    priyasinha
    0
  • Bgfreeman
    There are no alerts being fired on that server (at least none in the last 24 hours)

    Drilling down into the server reports, I can see it collected stats for things like batches per sec etc, but the databases are still all showing as offline.
    Bgfreeman
    0
  • priyasinha
    Hi,

    Do you see any connection errors on Configuration > Monitored servers page? Any clock skew?

    Thanks,
    Priya
    priyasinha
    0
  • Bgfreeman
    No connection issues.

    I can do screenshots if you want.
    Bgfreeman
    0
  • Bgfreeman
    SQL_Monitor_TSL.png
    Bgfreeman
    0
  • priyasinha
    Hi,

    Could you try restarting the base monitor services via Service console (services.msc from Run menu)? It is called 'SQL Monitor 2 Base Monitor'. In the meanwhile, please email me at priya.sinha@red-gate.com log files also from base monitor machine. It should be at C:\ProgramData\Red Gate\Logs\SQL Monitor 2 or equivalent location.

    Thanks,
    Priya
    priyasinha
    0
  • Bgfreeman
    Service restarted.. no Change. logs zipped and sent
    Bgfreeman
    0
  • Bgfreeman
    Further Info.

    came in this morning, and althoug the (Local) instance is still shown in Manage Monitored Servers, it no longer shows up in the Global overview page for the cluster.

    I need to sort this asap.
    Bgfreeman
    0
  • mipe10
    Hi,
    specify tsicipr02.tslweb.local\<sqlinstancename> in the add sql sertver to monitor. Since sql server is installed on a cluster you must use a named instance!
    mipe10
    0

Add comment

Please sign in to leave a comment.