Discovery and SQL Clusters

klautrup
Kilo Expert

Hi,
We notice that Discovery when discovering an MSFT SQL Instance CI on a SQL cluster names the instance including the hostname of the cluster node the instance is running on at the time of discovery.

For instance if:
Instance name: I01
Cluster name: sqlcluster1
Node A: sqlserver1
Node B: sqlserver2

And I01 is currently running on sqlserver1 then Discovery will name the instance I01@sqlserver1 and create RUNS ON relations to sqlserver1 as well as sqlcluster1.

What happens if I01 fails over to sqlserver2 on the next Discovery scan. Will Discovery then rename the instance to I01@sqlserver2 and create a new RUNS ON relation to that server, or will Discovery keep the original name I01@sqlserver1?

How can we instead configure Discovery to name the instance I01@sqlcluster1 thus matching the name of the cluster?

Best Regards,
Kristian

 

 

5 REPLIES 5

As at April 2023 on Tokyo Patch4 running the 1.0.90 Patterns we still get the same result as described above.