KB30497: How to monitor Report Services dashboards XML generation in MicroStrategy Web

SUMMARY:
This technical note is part of How to troubleshoot Dashboard Performance document that can be found KB4100-812-0001
If administrators or Strategy Technical Support require XML generation information, it is available through the Strategy Diagnostics and Performance counters.
ACTION:
First register the following DLL in the system
C:\program files\MicroStrategy\m8xmlapi.dll
 
Using regsvr32 "C:\Program Files\Common Files\MicroStrategy\M8XMLAPI.dll" from the command line

 
To log and monitor document data preparation, open the Strategy Diagnostics and Performance logging found under Start > Programs > Strategy > Tools.
 
Switch to the Performance Configuration tab and enable the following three counters:
 

• XML_GENERATION Total Counts
• XML_GENERATION Elapse Time(sec)
• XML_GENERATION CPU Time(sec)

 
Save the changes. There is no need to re-start the Strategy Intelligence Server.
 
The results of these counters are saved in a CSV file under \Program Files\MicroStrategy\Intelligence Server.
 
To obtain information on how to enable these counters in a UNIX environment, refer to the following Strategy Knowledge Base technical note:
 
KB13313 (KB5300-75x-0747): 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