Set load distribution thresholds values between 0 and 100 using sp_cluster profile, "set". A value of zero (0) disables that aspect of load distribution. You can set separate load thresholds for:
Login redirection
Dynamic load distribution
The hysteresis value
For example, to turn off dynamic load distribution in “my_profile,” enter:
sp_cluster profile, "set", my_profile, threshold, "dynamic", "0"
To set the login redirection threshold to 30 for “my_profile,” enter:
sp_cluster profile, "set", my_profile, threshold, "login", "30"
To set the hysteresis value to 20 for “my_profile,” enter:
sp_cluster profile, "set", my_profile, threshold, "hysteresis", "20"
