KB6227: How to monitor Report Services dashboards data preparation step in MicroStrategy Web.

This technical note is part of How to troubleshoot Dashboard Performance document that can be found in KB19625 : Dashboard performance troubleshooting in Strategy 9.x
Rarely Data Preparation is the performance bottleneck when executing Report Services dashboards. However, if the administrators or Strategy Technical Support require this information, it is available through the Strategy Diagnostics and Performance Counters.
 
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:

• DSSDocumentDataPreparationTask CPU Time
• DSSDocumentDataPreparationTask Elapse Time
• DSSDocumentDataPreparationTask total Counts

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: How to enable logging of performance counters using the Diagnostics and Performance Logging tool for MicroStrategy Intelligence Server 9.x in Microsoft Windows and Unix
 
KB6227