We have QPR Metrics 2015.1 up and running on a HP DL380 server with 64GB of memory with windows server 2012 R2. Also SQL Server 2014 is running under the same machine as database for QPR Metrics.
In QPR Configuration Manager, I set the memory usage limit to 30 GB to let the SQL Server use the rest of memoty. but after I start the QPR Metrics service, it take about 63 GB of memory and the system start lagging. It seems the memory usage limitation option in setting, doesn't work properly.
Please let me now if there is any solution. Thanks.