When designing a partitioned database, use the following information to help you determine which data to include in each partition:
Which database should be the data source and which the data target? The database that “owns” the data, where the data is updated and where most of the detail data is stored, should be the data source.
Are some parts of the database accessed more frequently than others?
How frequently is the data accessed, updated, or calculated?
What are the available resources: disk space, CPUs, and network resources?
How much data must be transferred over the network? How long does it take?
Is there information in separate databases that should be accessed from a central location? How closely are groups of data related?