SAP Knowledge Base Article - Preview

1951841 - How to read TempCachePagesInUsePercentage in sp_iqstatistics output - SAP IQ


Even when there are few connections and no active transactions on the IQ server, the TempCachePagesInUsePercentage value returned by the sp_iqstatistics procedure is over 50%.

Is it a normal behavior or a signal of a wrongly configured parameter?



  • SAP IQ 15.4
  • SAP IQ 16.0


SAP IQ all versions


tempcache, temprary cache, statistics, monitoring, TempCachePagesPinnedPercentage , KBA , BC-SYB-IQ , Sybase IQ , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.