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

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.
Luke L
0

Comments

1 comment

Sort by
  • Tianjiao_Li
    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:

    Tianjiao_Li
    0

Add comment

Please sign in to leave a comment.