How to have see display of active cluster node on SQL Server home page?
Is there an option to be able to see which cluster node a clustered instance is running on through Spotlight? When adding a clustered instance to Spotlight and pick "cluster (monitor active node)" for the linked OS connection, there is no way to see which node the instance is using through Spotlight. It would be useful to have the information on the SQL Server home page or in a drill down. Reason being, if getting an alert about a monitored Windows server, one would not know if it is hosting SQL services without logging in to confirm.
Enhancement request has been submitted for this feature to be included in a future release.