Monitoring On-Premises Data Gateway

[Brettp761]

Hi,

I've been using the gateway and other performance monitor counters via PBI Desktop on a project recently. The paper available for download on my blog describes the approach and related considerations:

Monitor On Premises Gateway

Best,

Brett

[Anonymous]

We have started working on monitoring for our Gateway servers and have set up performance counters to review what the gateways are doing.  The on-Premises counters are almost all 0's even though I know my gateways are running hard.  

Are the perf monitors working or is there something more se have to set up to get this information?

Also another issues with monitoring I am having is identifying what dataset is updating on which server.  We are running a cluster of 4 Gateways and when datasets are running and I am trying to understand what dataset is using high resources I cannot because it is not identified in the logs that I can find.  Any idea how to tell what server is updating specific datasets in a cluster system?  

Thanks

[rexifan]

Hi Brett,

Thanks so much for sharing!

I reproduced the similar work on my machine and it worked fine. However, after I updated the on-premise Data gateway by the end of Aug, metrics like "# of all queries executed" somehow declined to 0 till now (before updating, there were around 200 queries per month). And the gateway worked fine at the same time, so I am wondering maybe some configuration/setting up is off after updating.

Would you or anyone has an idea on what happened here?

Thank you in advance!

M

[Anonymous]

I am experiencing the same behavior since the November release. We're currently on the December release.

Since installing Nov. and then Dec as well there's been no performance counter data shown except for "# of items in the ADO.NET connection pool"

All other counters are 0 and do not change over time, even if a large refresh is running.

Any insight or steps to resolve?

[Anonymous]

Did you manage to get data on who the users of the gateway are?

[sfibaek]

Information about which automatic updates have been setup on the gateway would also be very usefull!

[Brettp761]

I can't comment on these two items (gateway users, gateway schedules configured). Gateway monitoring is part of my current project and I may write a new, updated paper or blog post in February of 2018. Much greater detail (22 pages) would be available in May as part of the current project.   

[royal_aryan7]

Hi Bret, Did you release the new paper with gateways users and schedule information? 

[Brettp761]

Hi royal,

No, I'm afraid not. I've just been busy with other projects and this was pushed off indefinitely. Sorry. 

[sfibaek]

Thanks! Looking forward to it! If I find a solution to the problem at hand, I'll update here.

[Anonymous]

We look forward to that Brett!

[v-qiuyu-msft]

Hi @Brettp761,

Good job! Thanks for your sharing.

Best Regards,
Qiuyun Yu