topic Re: Performance issue with Grid Report (CPU under utilized) in QlikView https://community.qlik.com/t5/QlikView/Performance-issue-with-Grid-Report-CPU-under-utilized/m-p/1433279#M430839 <HTML><HEAD></HEAD><BODY><P>Any ideas, what could be happening here?</P></BODY></HTML> Tue, 03 Oct 2017 11:23:06 GMT diwakarnahata 2017-10-03T11:23:06Z Performance issue with Grid Report (CPU under utilized) https://community.qlik.com/t5/QlikView/Performance-issue-with-Grid-Report-CPU-under-utilized/m-p/1433278#M430838 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am facing severe performance issues in one of the Grid reports. <SPAN style="font-size: 10pt;">The grid report has complex calculations and multiple metrics.</SPAN></P><P>The data volume is high 300 million rows (5 GB App Size), after applying all the standard best practices for Optimization.</P><P><SPAN style="font-size: 10pt;">Our server is 16 core, 128 GB RAM. </SPAN></P><P><SPAN style="font-size: 10pt;">The Grid report takes 3 mins to render, while the RAM and CPU usage are &lt;30% most of the time.</SPAN></P><P><SPAN style="font-size: 13.3333px;">Question: Why does the report not take the available resources (RAM and CPU) and provide results quicker. What govern's the maximum CPU utilization.</SPAN></P><P><SPAN style="font-size: 13.3333px;">Also, what can be done for optimization in such situations.</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Regards,</SPAN></P><P><SPAN style="font-size: 13.3333px;">Diwakar<BR /></SPAN></P></BODY></HTML> Thu, 28 Sep 2017 12:47:21 GMT https://community.qlik.com/t5/QlikView/Performance-issue-with-Grid-Report-CPU-under-utilized/m-p/1433278#M430838 diwakarnahata 2017-09-28T12:47:21Z Re: Performance issue with Grid Report (CPU under utilized) https://community.qlik.com/t5/QlikView/Performance-issue-with-Grid-Report-CPU-under-utilized/m-p/1433279#M430839 <HTML><HEAD></HEAD><BODY><P>Any ideas, what could be happening here?</P></BODY></HTML> Tue, 03 Oct 2017 11:23:06 GMT https://community.qlik.com/t5/QlikView/Performance-issue-with-Grid-Report-CPU-under-utilized/m-p/1433279#M430839 diwakarnahata 2017-10-03T11:23:06Z