On Premises Gateway perfmon all 0

[joel_gibby_csc]

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.

Spoiler

# 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.

# of items in the ADO.NET connection pool stays constant.

Is this something that can be addressed here or do I need to open a ticket?

Thanks!

[v-piga-msft]

Hi @joel_gibby_csc ,

It seems that your want to trace the on premises gateway. 

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

[joel_gibby_csc]

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