1/2/2007

The following text was taken from our readme.txt file for AICodePerformance:

Once performance data has been collected the report can be opened using your preferred analysis tool.

We are going to cover how to open the report in Excel:

1. Choose File Open from the Excel menu

2. Select the XML report file from the Open File Dialog:

3. Excel will ask how you want to open the XML file. Choose XML List for now:

4. You will notice that the report data is displayed by columns.

You should be able to see the following standard columns:

Date
Time
Type
Block
StartTime
EndTime
TimeDifference
CustomMessage


Date The date a Capture method was called (useful if you are automating AICodePerformance over several days)

Time The time of the capture

Type The type of capture START (a timed block was started), END (a timed block was stopped) or SNAPSHOT (a Capture method was called, with no timing information)

Block The GroupID you specified when calling the Start or EndBlockCapture

StartTime The time is automatically recorded when calling the StartBlockCapture method

EndTime The time is automatically recorded when calling the EndBlockCapture method

TimeDifference The time span difference (in seconds) is automatically calculated when calling the EndBlockCapture method

CustomMessage The custom message you specified when calling Capture, StartBlockCapture or EndBlockCapture

MEM_PCB
MEM_CB
NETMEM_TCB
NETMEM_PTGC
LOGDISK_DRT
Etc..

All performance data following the default fields to the right of the report. Depending which data you choose to include you will see the appropriate fields for each.

e.g. MEM_PCB = Memory Percent Committed Bytes performance counter

Each field name has been condensed to make them easier to read. To see the full performance counter name, see the properties section we covered earlier.

5. Now, lets take a quick look at the XML Source for the report. To open the source:

Select Data XML XML Source, from the Excel menu

This will open a new window pane on the right hand side of the spreedsheet. You will see a list of all available XML elements generated in the report. Here you can perform mappings and adjust the XML transformations as you wish