[QUESTION] Always on Supported? If so how?

[MariusNe87]

Which component is your question about?

Full Dashboard

Performance Monitor Version

Full Version, 2.4.1

Is your question about how it works, or the results?

Results

What's your question?

SQL-Server Always On supported?

Additional Context

Some Collectors show the following error: The target database ('xyz) is in an availability group and is currently accessible for connections when the application intent is set to read only. For more information about application intent - can we configure application intent somewhere or whats best approach?

[MariusNe87]

Additionally to mention we also use readonly routing on secondary for reporting purposes... ;) Query_Stats_Collector and waiting_tasks_Collector is affected with failing state or warning state.

[erikdarlingdata]

@MariusNe87 Well that's a bit embarrassing! I added this to Lite and did all the testing against Azure with a readable secondary, and then neglected to add this to the full dashboard. You should see this in the #728 merge. I do not have a local AG to test against, so you may have to be ready to file some bug reports if you catch anything odd. It should be a 1:1 port though.

[MariusNe87]

No worries - we all are humans 🤣

[erikdarlingdata]

@MariusNe87 well, we try to be, anyway. Hopefully Turing doesn't notice anything odd. Anyway, this is added in dev so I'm going to close this issue. If you find any problems with the implementation, please do open issues about them.