Is there anything to help diagnose performance problems?

A. You can use the Excel Macro Perfmon.xla. Perfmon.xla can be downloaded from Use the macro as follows:

  1. Start Performance Monitor (Start - Programs - Administrative Tools (Common) - Performance Monitor)
  2. Move into Chart Mode (Select Chart from the View menu or press Ctrl-C)
  3. Add the following Counters
    - Memory-Pages/sec
    - Memory-Available Bytes
    - PhysicalDisk-% Disk Time
    - PhysicalDisk-Current Disk Queue Length
    - Processor-% Processor Time
    - Processor-Interrupts/sec
    - System-Processor Queue Length
    These are added by selecting "Add to Chart" from the Edit menu (or click the big + on the toolbar). The first part, e.g. Memory is the Object, and the second part is the Counter. Click Done when all are added
  4. Let the monitor run for a while and perform your normal day-to-day operations.
  5. Once it has run for a while select "Export Chart" from the file menu. In the "Save as type", select "Export CSV Files (*.csv)" and enter a name (it will add .csv for you). Click Save
  6. Exit Performance Monitor
  7. Start Excel and open a new blank spreadsheet.
  8. Select Open from the File menu. Select "Files of type" "Add-Ins" and move to the directory you extracted perfmon.xla to. Select perfmon.xla and click Open.
  9. Select Open from the Planning menu. Move to the directory you saved the file in step 5, select the file and click Open.
  10. Select Bottlenecks from the Planning menu and it will give a list of possible bottlenecks. Selecting one will give more detail in the Suggestions area. Click OK when you are finished.
  11. You can also create a chart by selecting "Create Chart" from the Planning menu, select the counters you want to show on the chart and click OK.

This macro is only basic, but it may give you some starting points to investigate and automates the line of thinking you should be following.

Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.