The most common partitioned environment consists of a single database partition on each physical system that makes up the database partition cluster.

A common design would be to create a data partition for each month's data.

If no common paging space device is available, the partition will fail to activate.