Change where advanced finds and exports read from

(0) Share

Report

Posted on by EVOKCCO

I'm implementing an always on database with a new Dynamics 365, on-premise deployment. The question at hand: is it possible to set it up so advanced finds and exports to Excel pull from the secondary node by default as to prevent potential performance hits? Or if this is impossible/unsupported without causing unwanted repercussions?

I know how to change the connection in Excel after the export for a dynamic one.

Thanks!

-Eric

Categories:

Customization / Solutions / SDK and API

Other Functionality

All responses (2)

Answers (0)

EVOKCCO 5 on at

Like (0)

Report

RE: Change where advanced finds and exports read from

Thank you, Kokulan.

We are load balanced, the problem lies with the amount of data in the system and what those queries are hitting. The system itself is pretty robust compared to standard deployments I've seen over the last decade. When I looked into this 8 or 9 years ago, it just wasn't possible and wonder now that always on is available and supported if things had changed.

-Eric
Suggested answer

Kokulan 18,052 on at

Like (0)

Report

RE: Change where advanced finds and exports read from

Hi

If you have CRM installed on multiple servers, you could consider configuring and fine-tuning load balancing rather than changing the advance find to use specific server async service

crmbook.powerobjects.com/.../multiple-server-deployment-2