On Premises Gateway perfmon all 0

Question

Hello, In the last few releases of the gateway, I've not been able to get any data other than "0" for each of the listed counters, even in the middle of a large refresh that takes an hour, the counters all stay 0.&nbsp;Spoiler (Highlight to read)# of ADO.NET open connection executed / secNumber of ADO.NET open connection actions executed per second (succeeded or failed).# of ADO.NET open connection failed / secNumber of ADO.NET open connections actions failed per second.# of ADO.NET queries executed / secNumber of ADO.NET queries executed per second (succeeded or failed).# of ADO.NET queries failed / secNumber of ADO.NET failed queries executed per second.# of ADOMD open connection executed / secNumber of ADOMD open connection actions executed per second (succeeded or failed).# of ADOMD open connection failed / secNumber of ADOMD open connection actions failed per second.# of ADOMD queries executed / secNumber of ADOMD queries executed per second (succeeded or failed).# of ADOMD queries failed / secNumber of ADOMD failed queries executed per second.# of all open connection executed / secNumber of open connection actions executed per second (succeeded or failed).# of all open connection failed / secNumber of failed open connection actions executed per second.# of all queries executed / secNumber of queries executed per second (succeeded or failed).&nbsp;&nbsp;# of items in the OLEDB connection poolNumber of items in the OLEDB connection pool.# of items in the Service Bus poolNumber of items in the Service Bus pool.# of Mashup open connection executed / secNumber of Mashup open connection actions executed per second (succeeded or failed).# of Mashup open connection failed / secNumber of Mashup open connection actions failed per second.# of Mashup queries executed / secNumber of Mashup queries executed per second (succeeded or failed).# of Mashup queries failed / secNumber of Mashup failed queries executed per second# of OLEDB multiple result set queries failed / secNumber of multiple result sets of OLEDB failed queries executed per second.# of OLEDB multiple result sets of queries executed / secNumber of OLEDB multiple result sets of queries executed per second (succeeded or failed).# of OLEDB open connection executed / secNumber of OLEDB open connection actions executed per second (succeeded or failed).# of OLEDB open connection failed / secNumber of OLEDB open connection actions failed per second.# of OLEDB queries executed / secNumber of OLEDB multiple result sets of queries executed per second (succeeded or failed).# of OLEDB queries failed / secNumber of OLEDB multiple result sets of failed queries executed per second.# of OLEDB single result set queries executed / secNumber of OLEDB single result set queries executed per second (succeeded or failed).# of queries failed / secNumber of failed queries executed per second.# of single result set OLEDB queries failed / secNumber of single result set OLEDB failed queries executed per second.# of ADO.NET open connection executed / secNumber of ADO.NET open connection actions executed per second (succeeded or failed).# of ADO.NET open connection failed / secNumber of ADO.NET open connections actions failed per second.# of ADO.NET queries executed / secNumber of ADO.NET queries executed per second (succeeded or failed).# of ADO.NET queries failed / secNumber of ADO.NET failed queries executed per second.# of ADOMD open connection executed / secNumber of ADOMD open connection actions executed per second (succeeded or failed).# of ADOMD open connection failed / secNumber of ADOMD open connection actions failed per second.# of ADOMD queries executed / secNumber of ADOMD queries executed per second (succeeded or failed).# of ADOMD queries failed / secNumber of ADOMD failed queries executed per second.# of all open connection executed / secNumber of open connection actions executed per second (succeeded or failed).# of all open connection failed / secNumber of failed open connection actions executed per second.# of all queries executed / secNumber of queries executed per second (succeeded or failed).&nbsp;&nbsp;# of items in the OLEDB connection poolNumber of items in the OLEDB connection pool.# of items in the Service Bus poolNumber of items in the Service Bus pool.# of Mashup open connection executed / secNumber of Mashup open connection actions executed per second (succeeded or failed).# of Mashup open connection failed / secNumber of Mashup open connection actions failed per second.# of Mashup queries executed / secNumber of Mashup queries executed per second (succeeded or failed).# of Mashup queries failed / secNumber of Mashup failed queries executed per second# of OLEDB multiple result set queries failed / secNumber of multiple result sets of OLEDB failed queries executed per second.# of OLEDB multiple result sets of queries executed / secNumber of OLEDB multiple result sets of queries executed per second (succeeded or failed).# of OLEDB open connection executed / secNumber of OLEDB open connection actions executed per second (succeeded or failed).# of OLEDB open connection failed / secNumber of OLEDB open connection actions failed per second.# of OLEDB queries executed / secNumber of OLEDB multiple result sets of queries executed per second (succeeded or failed).# of OLEDB queries failed / secNumber of OLEDB multiple result sets of failed queries executed per second.# of OLEDB single result set queries executed / secNumber of OLEDB single result set queries executed per second (succeeded or failed).# of queries failed / secNumber of failed queries executed per second.# of single result set OLEDB queries failed / secNumber of single result set OLEDB failed queries executed per second.&nbsp;# of items in the ADO.NET connection pool stays constant.&nbsp;Is this something that can be addressed here or do I need to open a ticket?&nbsp;Thanks!

v-piga-msft · Answer

Hi&nbsp;Anonymous&nbsp;,
It seems that your want to trace the on premises gateway.&nbsp;
You may could export Gateaway logs and analyze it.

For your requirement, I'm afraid that you'd better create a support ticket to get the further help.
Best Regards,
Cherry
&nbsp;

anonymous · Answer

Hi Cherry, I have access to the logs. There is very little documentation on what the messages mean - do you have a doc that explains MGAA MGPP and the other codes and fields in the logs?

My original request was to fix Performance Monitor (perfmon) counters that all show “0” - this is my goal.

Thanks, please let me know!

Joel

Forum Discussion

On Premises Gateway perfmon all 0

2 Replies

Related content

On-premises data gateways

Power BI Service on-premises gateway

On-premise date Gateway

On-premises gateway issue

On-premises data gateway Offline

# of ADO.NET open connection executed / sec	Number of ADO.NET open connection actions executed per second (succeeded or failed).
# of ADO.NET open connection failed / sec	Number of ADO.NET open connections actions failed per second.
# of ADO.NET queries executed / sec	Number of ADO.NET queries executed per second (succeeded or failed).
# of ADO.NET queries failed / sec	Number of ADO.NET failed queries executed per second.
# of ADOMD open connection executed / sec	Number of ADOMD open connection actions executed per second (succeeded or failed).
# of ADOMD open connection failed / sec	Number of ADOMD open connection actions failed per second.
# of ADOMD queries executed / sec	Number of ADOMD queries executed per second (succeeded or failed).
# of ADOMD queries failed / sec	Number of ADOMD failed queries executed per second.
# of all open connection executed / sec	Number of open connection actions executed per second (succeeded or failed).
# of all open connection failed / sec	Number of failed open connection actions executed per second.
# of all queries executed / sec	Number of queries executed per second (succeeded or failed).

# of items in the OLEDB connection pool	Number of items in the OLEDB connection pool.
# of items in the Service Bus pool	Number of items in the Service Bus pool.
# of Mashup open connection executed / sec	Number of Mashup open connection actions executed per second (succeeded or failed).
# of Mashup open connection failed / sec	Number of Mashup open connection actions failed per second.
# of Mashup queries executed / sec	Number of Mashup queries executed per second (succeeded or failed).
# of Mashup queries failed / sec	Number of Mashup failed queries executed per second
# of OLEDB multiple result set queries failed / sec	Number of multiple result sets of OLEDB failed queries executed per second.
# of OLEDB multiple result sets of queries executed / sec	Number of OLEDB multiple result sets of queries executed per second (succeeded or failed).
# of OLEDB open connection executed / sec	Number of OLEDB open connection actions executed per second (succeeded or failed).
# of OLEDB open connection failed / sec	Number of OLEDB open connection actions failed per second.
# of OLEDB queries executed / sec	Number of OLEDB multiple result sets of queries executed per second (succeeded or failed).
# of OLEDB queries failed / sec	Number of OLEDB multiple result sets of failed queries executed per second.
# of OLEDB single result set queries executed / sec	Number of OLEDB single result set queries executed per second (succeeded or failed).
# of queries failed / sec	Number of failed queries executed per second.
# of single result set OLEDB queries failed / sec	Number of single result set OLEDB failed queries executed per second.