SSAS consume a lot of memory
Hi, I am analyzing why my SSAS server is consume a lot of memory sometimes what i can see it is not when the model is processing. I have run the dmv Memory usage to find what in SSAS service is take all the memory, and we talk about 115GB memory. My model is only 6GB when loaded in memory. The result of running memory usage can you see below. The what i can see from it, it is the OBJECT ID Big and Small the consume all the memory togeheter. So my question is, what is that? And how can i reduce the consume of memory?
High CPU Usage on Power BI RS (On premise)
Hello guys, I have a question about Power BI Reporting Services (On Premise) One of the users posted a report that, when this report starts to update the data, consumes 100% cpu and 90% memory. Is there any way to know which report is this? So that I can guide you how to schedule the update And how to limit the use of cpu and memory in the service? Or even by report? regards,Report Server Memory Management
Hi folks I'm using Power Bi Report Server on perm (August 2018) Evaluation mode and have some issues about memory management. We've created some reports ( mostly are live connections to SSAS and a few direct connections to a data source ). Our server has about 80 gigabytes of ram with 8 cores CPUs. The issue is after a few days, we see lots of processes in task management taken lots of memory shown as ReportingService.exe. Every process has its own PID. And when we stop the report server, all processes kill immediately advocating all of them are related to the main process ( power bi report server hosting ). Is there any way to limit the maximum memory allocation to report server?Schedule Refresh - memory
Hi all, if i use a schedule refresh on a report which takes 15 min to refresh and have 40Mega, are affected somehow the resources available for a regular license? i'm asking because i don't want to exceed a limit or something like that and i can reload manually and upload after that as an alternative. Thanks, CosminScheduled Refresh Causes Server Pagefile Usage to Grow Overtime
Hello! Roughly nine or so months ago, upgraded from using an older SSRS system to using Power BI Report Server. currently use PBIRS for on-premis data reporting. We have several pagenated reports with subscriptions that we used thorughout the years and are now beginning to make use of Power BI reports as well. Many of my reports connect to either SQL or Oracle databases and run stored procedures to get the data. I have figured out how to get Data Refresh working for my reports and it works very well. However, soon after I learned how to build Power BI reports and set up auto refresh, our subscriptions stopped sending out one day. The SSRS database would claim the subscriptions have been sent but the emails never were actually sent out. I restarted the Power BI service on our vm server and the subscriptions automatically started running again. Upon much investigation and monitoring using Performance Monitor on our server, I noticed that after each scheduled refresh of my power bi reports that several Microsoft.Mashup.Container.NetFX40 processes would start running. Then after these processes are complete, the page file would settle down with usage slightly higher than previously. This process repeats itself many times and after about 3 days or so, the page file would be completely full and I would have to restart the Power BI Report Server service. This would release the pagefile memory until it would get used up again. I came accross this issue where someone had a similar problem. The fix is to restrict data preview from downloading data in the background of each Power BI Report. I have attempted to integrate this fix but it does not reslove my issue. I am a bit at a loss of what to do. Any extra insight would be greatly appreciated!
