Finance | Project Operations, Human Resources, ...

MR 2012 (CU16) with value Application Intent readonly

(0) Share

Report

Posted on by hoang.nguyen83

275

Hello,

I have AAG database nodes, AOSes is pointing to listener

I want MR read into AAG secondary node as if it reads into primary node, there is huge performance impact. The integration even lock some table in AOS database which caused us real problem on AOS side

adding <add key="SetApplicationIntentReadOnly" value="false" /> into MRServiceHost.settings.config file in the MR Service folder would NOT help when I try to setup the integration. It said the database in availability group and only accessible when the application intent is set to read only

Regards,

Mark

All responses (5)

Answers (0)

André Arnaud de Cal... 293,099 Super User 2025 Season 1 on at

Like (0)

Report

RE: MR 2012 (CU16) with value Application Intent readonly

Hi Mark,

I do agree with Ludwig and create a ticket for Microsoft Support. They should be able to help you with performance issues or database blocks.
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: MR 2012 (CU16) with value Application Intent readonly

Hi Mark,

I believe that the best and fastest way to get this issue resolved is contacting the MS support by opening a ticket with them.

Would be great if you could do that and keep the community updated on how things are going.

Many thanks and best regards,

Ludwig
hoang.nguyen83 275 on at

Like (0)

Report

RE: MR 2012 (CU16) with value Application Intent readonly

Is there any idea, everyone?

Appreciated very much
hoang.nguyen83 275 on at

Like (0)

Report

RE: MR 2012 (CU16) with value Application Intent readonly

Hi André,

That means AlwaysOn Availability Group for SQL side

Regards,

Mark
André Arnaud de Cal... 293,099 Super User 2025 Season 1 on at

Like (0)

Report

RE: MR 2012 (CU16) with value Application Intent readonly

Hi Mark,

Can you explain the abbreviation AAG?