KB42619: Useful diagnostics tracing for troubleshooting issues with Report Cache Memory usage in MicroStrategy Intelligence Server.

The following steps explain how to get Report Cache Memory usage trace in Strategy Intelligence Server.
 

• Open Strategy Diagnostics and Performance Logging tool.
• Check ‘File log’ for each of the counters ‘Memory Used by Report Caches(MB)’, ‘Number of Report Caches In Memory’ and ‘Total Report Cache Index Size(KB)’ of Category ‘Strategy Server Jobs’ and save as shown in the image below: 
   

• Note : Refer to the following Strategy Knowledge Base document for more information about Performance Configuration
  KB13313: How to enable logging of performance counters using the Diagnostics and Performance Logging tool for Strategy Intelligence Server 9.x in Microsoft Windows and Unix 
   
  
• Open the Diagnostics Configuration tab, set File log for ‘Cache trace’ Dispatcher at ‘Report Server’ component and save as shown in the image below:
  

•  
  Note : Refer to the following Strategy Knowledge Base document for more information about Report Cache trace:  
  KB15513: How to enable cache and user trace via the GUI for troubleshooting issues with report cache and History List features in Strategy Intelligence Server
   
  
• Execute a report to create a Report Cache and check the Report Cache creation time in the Cache Monitor, as shown below:
   
  

•  
  
  Note: Create time 2013-02-22 PM 3:22:21 , Cache Size is 3945KB and Cache ID is '3F1F77684421A2A25C9262B7313D0695’. 
   
  
• Delete the Report Cache in the Cache Monitor, as shown below: 
  

• In the Report Cache trace file, check the timestamp for deleting a Report as shown below:
   

• Note: delete time 2013-02-22 15:24:11 of Cache ID ‘3F1F77684421A2A25C9262B7313D0695’.
   
  
• In the Performance logging trace file, check the counter values for deleting the Report Caches as shown in the image below: 
  

•  
  Note:  
  After creating a Report Cache, the Total Report Cache Index Size(KB) is increased from 2 to 4, the Number of Report Caches In Memory is increased from 0 to 1 and the Memory Used by Report Caches(MB) is increased from 0 to 3.
   
  After deleting a Report Cache, the Total Report Cache Index Size(KB) is decreased from 4 to 2, the Number of Report Caches In Memory is decreased from  to 0 and the Memory Used by Report Caches(MB) is decreased from 3 to 0. 
  

 
KB48653