How Averages Are Calculated

Fields in an Accounting report can show:

• Averages presented with two decimal places behind the point.
• Totals presented as whole numbers. If it is not possible to distinguish the type of data, totals are indicated with a hash (#) as the first character in the label.
• Times presented with six decimal places behind the point.

Averages are calculated by dividing totals by QPACRLNU, which is the number of threads to roll data into this QPAC data section.

Average = Total of package counter or time (QPACxxxx)
	       / Number of threads that roll data into this QPAC data section (QPACRLNU)   

This applies to package class 7, 8, or 10 times and events:

• Package buffer pool activity - Class 10
• Package Locking Activity - Class 10
• Package SQL Activity - Class 10
• Package Times - Class 7
• Package Global Contention P-Locks - Class 8
• Package Global Contention L-Locks - Class 8
• Package Times - Class 8 - Suspensions
• Package Identification - Report
• Package Identification - Trace
• Package General (Short Report)
• Package General (Short Trace)

For more information refer to the Accounting trace sections for a package.