We are planning to move our Dynatrace Server from one location to another. Would like to understand whether Performance Warehouse DB/server should also be moved to the same location where server located or that can be reside in the existing DC. Is there any latency issue?
I remember Agent & collector should be in the same DC, likewise for the above statement, do we have any such condition.
In the documentation there isn’t any recommendation about the PWH location but as we know that AppMon stores very large amounts of measure data points in the Performance Warehouse. Being highly optimized, it bursts data every minute to the database.
So in case it is possible for you to move the DB nearly to the AppMon server that will be a good practice instead facing unexpected consequences.
the larger your installation, the more essential it becomes that your pwh is close to your appmon server (network-wise). However, unless it becomes extreme, latency isn't our main performance concern. Rather it's i/o, memory and cpu on the db server itself, after that network throughput and only after that latency. Best regards,