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.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center