Adjusting the number of machines
To define the number of machines, run this script against the BIFarmConfig
database.
Adjust the scaling node count parameter, according to the number of scaling servers:
declare @decriptorID char(36)
declare @nodeCount nvarchar (10) = '<scaling node count>'
select @decriptorID = DESCRIPTOR_ID from SETTING_DESCRIPTORS where NAME = 'MGR_SCALE_MINWORKERS'
update SERVICE_SETTINGS set VALUE = @nodeCount
where
SERVICE_ID in (select SERVICES.SERVICE_ID from SERVICES where SERVICES.APP_NAME in ('Application Studio', 'Application Engine', 'Dashboards'))
and DESCRIPTOR_ID = @decriptorID
Restart your farm after you run the script.