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 a collector set of the necessary counters, as shown in the following image:

As you can see in the preceding image, several of the same counters are available per query type, such as ADO.NET, ADOMD, OLEDB, and mashup. The ADO.NET counters are used by DirectQuery connections and the mashup counters relate to the refresh of imported datasets. Detailed descriptions of all counters and types can be obtained via the Power BI docs website under Gateways.

Power BI tools and services are well suited to integrating and analyzing performance-counter data. A detailed paper describing this solution, as well as a sample Power BI Desktop file, is available on the Insight Quest blog at http://bit.ly/2Dssgbh.