Problems with SQL Threshold File

Mar 31, 2011 at 2:30 PM

I tried using the export feature to template for the SQL perf counters and then I created them manually using what was listed in the threshold file.  Everytime I run PAL and generate stats on a SQL .blg file I get the following in red letters on the screen.

 

File(s):
     C:\Documents and Settings\sgroner\Desktop\DataCollector01.blg (Binary)
Begin:    1/1/1601 0:00:00
End:      1/1/1601 0:00:00
Samples:  0
Error:
The specified record was not found in the log file.
MergeConvertFilterPerfmonLogs : [MergeConvertFilterPerfmonLogs] ERROR: Unable t
o find the converted log file:"C:\Documents and Settings\sgroner\Local Settings
\Temp\{083336dd-7ea4-4e50-af65-c3623e355173}\_FilteredPerfmonLog.csv"
At C:\Program Files\PAL\PAL v2.0.8\PAL.ps1:5059 char:38
+         MergeConvertFilterPerfmonLogs <<<<  -sPerfmonLogPaths $Log -BeginTime
 $global:BeginTime -EndTime $global:EndTime
    + CategoryInfo          : NotSpecified: (:) [Write-Error], WriteErrorExcep
   tion
    + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorExceptio
   n,MergeConvertFilterPerfmonLogs

MergeConvertFilterPerfmonLogs : Relog.exe failed to process the log. Review the
 results above this line. If relog.exe continues to fail, then try running Relo
g.exe manually and/or contact Microsoft Customer Support Servers for support on
 Relog.exe only. PAL is not supported by Microsoft.
At C:\Program Files\PAL\PAL v2.0.8\PAL.ps1:5059 char:38
+         MergeConvertFilterPerfmonLogs <<<<  -sPerfmonLogPaths $Log -BeginTime
 $global:BeginTime -EndTime $global:EndTime
    + CategoryInfo          : NotSpecified: (:) [Write-Error], WriteErrorExcep
   tion
    + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorExceptio
   n,MergeConvertFilterPerfmonLogs

 

I have no idea what the heck is missing or what I am supposed to do to fix this.  I have attached the blg file for review.

Here is a link to the file.

http://www.gronertech.com/support/DataCollector01.rar

 

 

 

Coordinator
Mar 31, 2011 at 5:35 PM

The counter log is fine. I was able to open it and work with it on Windows 7. The counter log was captured on a Windows Vista or Windows Server 2008 or newer operating system. If you are trying to use PAL on a Windows XP or Windows Server 2003 computer, then it will fail because the file format changed in Windows Vista and greater. Windows XP/2003 computers are unable to open logs captured on Windows Vista or greater.

Run PAL on a Windows 7 or Windows Server 2008 R2 computer.