KB14624: How to enable logging of performance counters using Microsoft Windows XP and 2003 Performance Monitor for MicroStrategy Intelligence Server 9.x and 10.x

To configure Microsoft Performance Monitor for Microsoft Windows 2003, follow the steps below:
 

• Open Microsoft Performance Monitor by going to Start -> Programs -> Strategy -> Intelligence Server.
• Under the left window, go to Performance Logs and Alerts and highlight Counter Logs, as shown below:
  

• In the right window, right-click and choose New Log Settings to open the following dialog box;
  

• Type in a name and click OK.
• Under the General tab, click on Add Counters, as shown below:
  

• In the drop-down box, choose Process, as shown below:
  

• Select the radio buttons for 'All counters' and 'All instances'. By including all counters and all instances, this will allow users to take a look at the machine as a whole and see if there are any application conflicts in regards to memory. Additionally, most database Instances in Strategy are set up to run in multi-Process mode. This spawns a new executable for each and every active database connection. Without all counters and all Instances selected, these processes will not be recorded as they are spawned and killed.
• Click on Add.
• Repeat this process for the Performance objects Memory, Strategy Server Jobs, and Strategy Server Users.
• Once all have been added, click on OK.
• Under the General tab, change the Interval to 30 seconds. This will give enough granularity without capturing too much data.
• Go the Log files tab and click on Configure, as shown below:
  

• Check the location where the files will be stored and set the log file size limit to a number around 25 MB, as shown in the image below. This will keep give enough data in a single file to be useful without interfering with system performance. This number may need to be lowered if the machine is under stress or underpowered.
  

• Click OK.
• Click OK to close the window.
• Right-click on icon for the new log settings and select start.

When monitoring Strategy Intelligence Server 9.x for memory, users should capture the data from re-start of the service through to the issue. This will show how memory is used over time.