Use sp_cluster profile, "set" to configure weights for each of the metrics covered in the load profile:
User connections
CPU busy
Run-queue length
I/O load
Engine deficit
User metric (optional, see “Creating a user metric”)
See “Workload metrics” for a description of the workload metrics.
Set each metric individually using values between 0 and 255. For example, to set weights for “my_profile”, enter:
sp_cluster profile, "set", my_profile, weight, "user connections", "0"
sp_cluster profile, "set", my_profile, weight, "cpu busy", "20"
sp_cluster profile, "set", my_profile, weight, "run queue", "30"
sp_cluster profile, "set", my_profile, weight, "io load", "10"
sp_cluster profile, "set", my_profile, weight, "engine deficit", "10"
sp_cluster profile, "set", my_profile, weight, "user metric", "30"