I installed Management Reporter RU4 a couple of months ago at a client site. They wanted this as they were going to use the webviewer at 80 sites, previously they were receiving pdf versions. The performance of Management Reporter was fine, this was until the first reports were sent out to the web users. As soon as the sites started accessing the report Management Reporter virtually stopped working, the memory on the 8GB server was maxed out and it was taking minutes to drill into reports instead of this happening instantly. As soon as all the sites were asked to stop using the webviewer performance returned to normal. The memory being used on the server returned to around 2GB. I then got one user to login from a site and this instantly maxed out the server memory again.
The server is used only for Management Reporter and all finance users that connect to MR have a client installed on their PC's. Has anyone experienced these problems before? If so was there a resolution.
*This post is locked for comments