The following considerations should be taken into account while implementing this pattern:
- Partitioning Strategy: Choosing a partition strategy is the key to efficiently balance load across multiple partitions. Following are few of the partitioning strategies which can be considered:
- Horizontal Partitioning (Sharding)
- Vertical Partitioning
- Functional Partitioning
Data Partitioning guidelines published by Microsoft (https://msdn.microsoft.com/en-us/library/dn589795.aspx) is a good reference document to understand these strategies.
- Data replication: It is advisable to replicate static data and commonly used data across data partitions to avoid cross partition queries which can be resource consuming.
- Rebalancing: Always ...