Our server names are the same between the environments (Dev, Test, Prod, etc.) because each environment is a separate domain.
Since we have more than one environment monitored by SQL Sentry, we're unable to use the AlwaysOn tab. Opening the AlwaysOn tab results in an error. This is because the tables in the database only store the server name and not the FQDN. The join of AG's with a primary replica matching two entries in the cluster node table results in the same AG being matched incorrectly on two different clusters.
We set up a job to update the records in the database by appending the domain name every 30 seconds or so, but it doesn't work well. Even when we do manage to get the AlwaysOn tab to open successfully, an error will be thrown within a minute and the tab will become unusable.
Please make a change so that the server names are stored in the database with an FQDN format.
