msmdsvr
3 TopicsPower BI Server May 2022 - High memory usage on msmdsrv.exe
Hey all, We had the issues with the Jan release, where the CPU was causing issues, and upgraded to May on the weekend. This morning, I came in and found the memory for msmdsrv.exe using 300+gb of RAM, plus the same in virtual memory, and using everything the server had - not leaving any memory for the database service etc. I know it probably comes down to poor models from my team, but is there any way of limiting the amount of RAM available to the service in the config? There looks to be some guidence from Microsoft on this for Analysis Service, but I want to make sure it's the same guidence for Power BI Report Server, and which settings would be recommended to set.Solved7.7KViews0likes2CommentsPower BI Report Server hanging
HI, I am periodically finding that the reports on our Power BI report Server become unavailable and when I try and access them I just get a loading message on the web page. Investigating further each time they hang I see the following messages in the log file 2020-07-20 00:00:06.6986|INFO|125|Catalog max connection pool size: 100 2020-07-20 00:00:06.6986|INFO|125|Deleting expired log file: D:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\msmdsrv.log Last written: 6/19/2020 6:32:14 PM 2020-07-20 00:00:06.6986|WARN|125|Exception deleting expired log fileSystem.IO.IOException: The process cannot access the file 'D:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\msmdsrv.log' because it is being used by another process. at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.File.InternalDelete(String path, Boolean checkHost) at Microsoft.BIServer.HostingEnvironment.Logger.DeleteExpiredFilesInternal(Int32 keepUntilDays, FileInfo[] logFiles) 2020-07-20 00:00:06.6986|INFO|125|Deleting expired log file: D:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\RSHostingService_2020_07_05_00_00_02.log Last written: 7/5/2020 11:59:57 PM 2020-07-20 00:00:06.7142|INFO|125|Deleting expired log file: D:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\RSPortal_2020_06_25_18_05_44.log Last written: 6/25/2020 6:05:44 PM 2020-07-20 00:00:06.7142|WARN|125|Exception deleting expired log fileSystem.IO.IOException: The process cannot access the file 'D:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\RSPortal_2020_06_25_18_05_44.log' because it is being used by another process. at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.File.InternalDelete(String path, Boolean checkHost) at Microsoft.BIServer.HostingEnvironment.Logger.DeleteExpiredFilesInternal(Int32 keepUntilDays, FileInfo[] logFiles) Any idea if these are the cause of the hanging and how I can prevent the deletion exceptions from happening?3.6KViews0likes5Comments