How big should the database partitions be?

For Web, see Partitioning.

For Email, see Partitioning.

For Data, see Rate of network and endpoint incidents.