AG and Legacy Clustering Preferred Node Check

[aachaemenes]

I think this is a big deal for lots of folks out there to know if their AG or Legacy Clustering is on the preferred node. Thanks.

[DavidWiseman]

Thanks for the suggestion. I'm not sure if this information is available in the DMVs - if you have a query that captures this, let me know. As a workaround a custom report/collection could be used.

[aachaemenes]

Here is this link https://www.linkedin.com/pulse/cluster-role-preferred-owner-iain-barnetson And this link https://dba.stackexchange.com/questions/316643/how-can-the-sql-server-cluster-preferred-owner-be-queried

…

On Fri, Sep 27, 2024, 2:13 AM David Wiseman ***@***.***> wrote: Thanks for the suggestion. I'm not sure if this information is available in the DMVs - if you have a query that captures this, let me know. As a workaround a custom report/collection could be used. — Reply to this email directly, view it on GitHub <#1027 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/BGN5RX6FFCN2VPPUOWQBTYTZYUOTTAVCNFSM6AAAAABO3Z2S56VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDGNZYHAZDENZYGY> . You are receiving this because you authored the thread.Message ID: ***@***.***>

[DavidWiseman]

Thanks for the links. PowerShell commands are not an ideal fit as users would need to enable the Windows feature for the module to be available. The service account would also need access to run these PS commands. I'm unlikely to implement this feature as it's not something I need. As a workaround, you could collect this via PS script, store it in the repository, and create a custom report for it.

Note:
If anyone else is interested in this feature, please comment on this issue. If you are interested in working on it - let me know. Pull requests will be considered.