SAP Knowledge Base Article - Preview

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

Symptom

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?


Read more...

Environment

  • SAP IQ 15.4
  • SAP IQ 16.0

Product

SAP IQ all versions

Keywords

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.