-
Title
How to configure AG listener connection and associate the primary replica Windows? -
Description
How to configure AG listener connection and associate the primary replica Windows? Currently, the 'Cluster Active Node' option of the SQL Server connection properties window is only applicable to AG instances on cluster. User would like Spotlight the same option and implementation for AG instances using listener, therefore, Spotlight can detect the primary replica node and display the CPU metrics of the primary node in the SQL Server home page.
Currently for non-cluster AG instances, users must create a separate SQL Server and Windows connection for each node and identify which node is the primary node.
-
Resolution
WORKAROUND:
None
STATUS
Enhancement request SEMB-821 has been submitted to Development for consideration in a future release Spotlight on SQL Server Enterprise.
-
Defect ID
SEMB-821