Windows performance-monitor counters, specific to both the gateway service and the servers on which the gateway is running, are helpful in assessing workloads relative to available resources. For example, a BI team can determine whether a gateway server has adequate memory available to support the scheduled refreshes of large datasets. Likewise, the performance counters specific to the On-premises data gateway can be used to identify spikes or dips in query executions and failures throughout the day. The results of this analysis could suggest adding a gateway instance to a cluster or migrating a gateway instance to a server with additional CPU cores.
The Windows Performance Monitor tool can be used to create ...
