Editing server properties for resource balancing
You can balance resources based on capacity or on a specified target. For example, if you have a new server, you can redistribute server activity to accommodate the increased resource capacity. However, if you need to increase the number of transactions per server, you balance resources by redistributing activity based on achieving a new target value.
About this task
In addition, you can assign a weight to each server's capacity. For example, assume you have one server with 1.5GB of RAM and a 60GB hard drive and have a second server with 3GB of RAM and a 120GB hard drive. You can enter the capacity of the first server as 1 and the second server as 2, giving it twice the weight.
If you set a capacity (or target) of zero for source-only or any-role servers, resource balancing tries to move all unpinned databases on the server. This is useful when decommissioning servers and moving their contents to new servers.
If a server's data cannot be obtained, you can treat the server as a phantom server and then change it back to a real server when data becomes available. After changing it back, press F9 to refresh and read the data from the server.