We are looking at deploying DPA globally, and we initially thought of standing up three rather beefy Servers, one in North America, one in Europe, and one in Asia, with the intent that each one has about 10-15 critical DBs monitored within their own region. Congruently, we have 3 primary pollers, one in each region, that we would be tying the DPA instances into. We have Two Ideas on how to accomplish that;
1 - Our original Idea was to have One DPA in each region, Polling the DBs at different sites withing there region.
(Example: DPA located in New York, Polling DBs in Colorado, Phoenix, and Seattle)
2 - A Team has been adamant that we would need a DPA Instance built at each site, all feeding into their regional "Central" DPA, and then tie in the Central DPA to Orion.
Standing up another ~40 servers just for DPA would create a lot of care and feeding for or relatively small Monitoring team, However we are now concerned that going with Idea 1 will cause performance issues that would offset any good DPA is doing.
Is it recommended to have a DPA server located at each site you are monitoring?
I'd welcome anyone experience with this.
Thanks in Advance!