Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I wanna ask some question regarding Enterprise Gateway data refresh performance.
Does it help if I install the Enterprise Gateway at an SSD drive instead of spinning drive? Just wondering...
Hope some expert could shed some light.
Thanks.
Solved! Go to Solution.
Hi @Anonymous ,
in short it does help.
Longer version of my answer 🙂
In step 6, queries like Power BI refreshes and Azure Analysis Services refreshes can return large amounts of data. For such queries, data is temporarily stored on the gateway machine. This data storage continues until all data is received from the data source. The data is then sent back to the cloud service. This process is called spooling. We recommend you use a solid-state drive (SSD) as the spooling storage.
If this post was helpful may I ask you to mark it as solution and give it some kudos?
Have a nice day!
BR,
Josef
Hi @Anonymous ,
in short it does help.
Longer version of my answer 🙂
In step 6, queries like Power BI refreshes and Azure Analysis Services refreshes can return large amounts of data. For such queries, data is temporarily stored on the gateway machine. This data storage continues until all data is received from the data source. The data is then sent back to the cloud service. This process is called spooling. We recommend you use a solid-state drive (SSD) as the spooling storage.
If this post was helpful may I ask you to mark it as solution and give it some kudos?
Have a nice day!
BR,
Josef
Thank you so much for this!
Just one more thing. My main system disk is spinning drive which is where my current Enterprise Gateway installed. Recently Infra has added 2 new SSD drive to my server. So if i just uninstall my current Enterprise Gateway and reinstall at this new SSD drive, I would see performance improvement right?
Again thanks for replying.
Is there any improvement? we are facing some performance issues now.
Hi @Anonymous ,
It does has some improvement on our server disk and CPU utilization.
Refer to this thread on how to change the location of the default spooler folder path:
Remember to restart your On-Prem Data Gateway service after changing the folder path in order for it to take effect.
Regards,
Max
Any improvement?
Hey @Anonymous,
I would say yes. But I'm not quite sure since I can't find any resource confirming this info.
BR,
Josef
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
60 | |
20 | |
18 | |
18 | |
9 |