TUNING

Resource balancing in Activity Trends
Using resource balancing, you can balance selected resources, such as database transaction load and disk space, among a selected group of servers. You decide which databases are available to be relocated as part of the resource balancing. All system databases are automatically "pinned" and cannot be moved. You can pin other databases to prevent them from being moved.

In addition to balancing the resources of existing servers, you can create phantom servers to use for future planning. Each phantom server represents a new server that can be loaded with databases. Then you can evaluate the effect of adding a new server before you incur the expense of additional hardware.

The role you assign to a server affects the resource-balancing results.


Related concepts
Resource balancing and activity trends

Related tasks
Setting up resource balancing in Activity Trends
Specifying databases that can move during resource balancing
Changing the layout of the Activity Trends view