Forum Discussion
StreamBeforeRequestCompletes Option in On Premise Data Gateway not working
StreamBeforeRequestCompletes is only applicable when you are actually streaming (ie without transforms or with query folding). All other queries still require disk activity for mashups etc.
What you should do is change the directory for spooler and logs to a different disk, so that it doesn't thrash your system disk.
Your ideas is so great lbendlin
Hi, Anonymous
I'm wondering if you have resolved your issue by now. If so, it would be great if you could mark the helpful replies as Answered. This way, other members who have similar questions can find the solutions more easily.
In addition, you can also adjust the performance of the gateway with the CPU of the server. We recommend that you read the following documents to understand the performance logs of your gateway and optimize the performance of your gateway based on them:
Adjust gateway performance based on server CPU | Microsoft LearnConfigure gateway disk space | Microsoft Learn
Monitor and optimize on-premises data gateway performance | Microsoft Learn
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super UserStreamBeforeRequestCompletes is only applicable when you are actually streaming (ie without transforms or with query folding). All other queries still require disk activity for mashups etc.
What you should do is change the directory for spooler and logs to a different disk, so that it doesn't thrash your system disk.
Thanks for the quick response!
We will double-check the setup of the queries to see if your topics apply.
The spooler folder is currently not filling up, the files appear and disappear after some seconds to minutes.Your ideas is so great lbendlin
Hi, Anonymous
I'm wondering if you have resolved your issue by now. If so, it would be great if you could mark the helpful replies as Answered. This way, other members who have similar questions can find the solutions more easily.
In addition, you can also adjust the performance of the gateway with the CPU of the server. We recommend that you read the following documents to understand the performance logs of your gateway and optimize the performance of your gateway based on them:
Adjust gateway performance based on server CPU | Microsoft LearnConfigure gateway disk space | Microsoft Learn
Monitor and optimize on-premises data gateway performance | Microsoft Learn
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.