Modify Alias names for Clustered instances in SQL Monitor
Luke L
Posts: 43 Bronze 3
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.
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_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 runningmofcomp C:\Windows\system32\wbem\ClusWMI.moffrom 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:
