Hi all,
We are facing the performance issue in BOXI R3.1 info view; After checking the respective servers and found in the Task Manager WIReportserver.exe is consuming 25% of the CPU utilization
We have checked in the Instance Manager no report has been running but in the Task Manager WIReportserver.exe is consuming a huge memory.
Please let us know how to find out the report that is running which is causing this memory usage.
mgopinat 
(BOB member since 2010-03-02)
You need to monitor your server to find out when the 25% CPU usage begins (perfmon or some other tool). Then make sure auditing is turned on and you can use the audit universe to determine what queries were running when Webi started CPU usage. Webi reports having multiple tabs (6 or more) and/or reports bringing back large amounts of data.
tmcd 
(BOB member since 2005-10-02)
Which SP and FP are you running?
Andreas 
(BOB member since 2002-06-20)
We are running our BO on Service Pack 2 and FP2…
We have found out one root cause for this issue…
One of our server was not having enough free space for our BO services to run. It is always recommended to have atleast 20% of free space in the server. We have cleared some of the files in the server…Now the performance seems to be much better.
Also we need to check if any reports are hanging in the backend. That also might take huge memory…
These are only some of the findings based on our investigation…Any other solution is also appreciable… 
mgopinat 
(BOB member since 2010-03-02)