Conduct an MDR Capacity Plan

In general, before you decide to federate data from an MDR, you should conduct a thorough capacity planning process, answering the following questions:

  • How many users should an MDR serve before it becomes a Federated Data Source?
  • How many user requests will an MDR receive after becoming a Federated Data Source?
  • Does the MDR have enough resources to support federated requests: CPUs, Memory/Cache, IO Bandwidth?
  • Is it possible to optimize the MDR for federated queries, for example, by adding an index for a column of an MDR table?