How do you use cloud databases? Take the survey.

Modify Alias names for Clustered instances in SQL Monitor

I upgraded to 8.0.19.16748.  While I like the change to see Clustered instances by the network name, I'm curious where this information is coming from.  We renamed the a SQL instance network name from myserver_new to myserver due to a side by side upgrade.  The instance is accessible via myserver, and I don't see the old name anywhere on the network, in AD, dns etc.

Sql Monitor is showing the alias as myserver_new.  

That brings to mind 2 questions:
1) Where does SQL monitor query this data?  We want to ensure it is updated correctly.
2) Can we change the aliases in SQL monitor both for FCI's and stand alone sql instances?

Thanks,
-Luke.
Tagged:

Best Answer

  • Tianjiao_LiTianjiao_Li Posts: 684 Rose Gold 5
    Hi @Luke L

    SQL Monitor queries WMI namespace for clustered instance. It looks like you need to rebuild the cluster namespace by recompiling the ClusWMI.mof file by running mofcomp C:\Windows\system32\wbem\ClusWMI.mof from an elevated command prompt, then restart the winmgmt service and try again.

    You can change the aliases in SQL Monitor. Please click the instance card on Overviews:

    Kind regards

    Tianjiao Li | Redgate Software
    Have you visited our Help Center?
Sign In or Register to comment.