SQLMonitor consider the SQL Server cluster name as an instance
SQLMonitor consider the SQL Server cluster name as an instance
This can be set within Display settings ('Failover Cluster Name Display') for a SQL Monitor configuration.
-
Matthew Flatt commented
Hi Daniel,
As you mentioned, SQL Monitor should be now displaying the SQL network name for any FCIs being monitored. Are you able to point me in the direction of the places where it is still showing the windows cluster name?
As a side note, you can use the alias feature to give a friendly name to any instance in SQL Monitor (FCI or standalone), if an alias has been specified, this will always take priority when displaying this instance in the UI.
Thanks,
Matt -
Daniel Alexander commented
Recent versions of SQL Monitor have started to implement this using aliases, as Redgate have named them.
On my main monitoring overview screen, where I was previously seeing "NTCLUS01" as the name of the monitored SQL instance, I am now seeing SQLCLUS01 on the card instead. Much better for us.
This is inconsistent throughout the product though, as some places now use the alias where others do not.
-
Daniel Alexander commented
I didn't post this suggestion, but came here to post it myself. What anonymous probably means is, SQL Monitor should display the SQL cluster name as the instance name, rather than the Windows Server Failover Cluster name.
For example, say I have a Windows Cluster called NTCLUS01, with 2 nodes which host a SQL instance called SQLCLUS01.
Rather than displaying SQLCLUS01 in SQL monitor, most notably and obviously on the "Overview" page, it displays NTCLUS01\SQLCLUS01. That's not so bad, I guess, but when the instance is not a named instance, but rather the default of MSSQLSERVER, SQL monitor just displays the Windows Cluster name, so only NTCLUS01 appears. Both scenarios are very confusing for support staff who are not familiar with the Windows side of things, who have always referred to the SQL instance as SQLCLUS01.
It's slightly confusing for me too, because I've always referred to the SQL instance name, the Windows Cluster is just a means to an end, I really only care about SQL.
-
Thanks for the suggestion. We'd be interested to understand a bit more about why this would be useful for you, what you're trying to achieve, so we can consider the context.
Thanks,
Adam