Analysis fails when reading a SQL Server 2008 performance monitor blg file

Jun 29, 2015 at 3:42 PM
Hello --

I generated a blg file on our SQL Server 2008 R2 server last night, and I attempted to do an analysis of it using PAL 2.7.4. However I encountered an error condition, and per the instructions of the file, I am posting its contents here:

Overall progress... Status: Calculating counter statistics [very CPU intensive]..., PAL 2.7.4 Progress: 65%... Calculating counter statistics [very CPU intensive]...,

An error occurred on...
$iPercentComplete = ConvertToDataType $(($iIndexOfJobs / $iTotalJobs) * 100) 'integer'
At C:\Program Files\PAL\PAL\PAL.ps1:2289 char:65 + $iPercentComplete = ConvertToDataType $(($iIndexOfJobs / <<<< $iTotalJobs) * 100) 'integer'
Attempted to divide by zero.

Log: C:\Users\ahk\Documents\Performance Monitor Logs\MGHROSTOR3_DataCollector01.blg
ThresholdFile: C:\Program Files\PAL\PAL\SQLServer2008R2.xml
AnalysisInterval: AUTO
IsOutputHtml: $True
IsOutputXml: $False
HtmlOutputFileName: [LogFileName]_PAL_ANALYSIS_[DateTimeStamp].htm
XmlOutputFileName: [LogFileName]_PAL_ANALYSIS_[DateTimeStamp].xml
OutputDir: [My Documents]\PAL Reports
AllCounterStats: $True
NumberOfThreads: 8
IsLowPriority: $True
DisplayReport: True

Please contact the PAL tool team with this error by posting it to Thank you!

For detailed information, please look at the script execution log at C:\Users\ahk\AppData\Local\Temp\PAL.log

What do I need to do in order to correct this?