Reading Tim Chapman's Chapter "Using PAL to analyze SQL Server performance" in the book "SQL Server MVP Deep Dives Volume 2" and playing with the PAL tool.
Problem:
See the screenshot for the error.
See the screenshot for the error.
Solution:
In my case, I need to download and install " Microsoft Chart Controls for Microsoft .NET Framework 3.5"
The website helped me to solve the problem: http://pal.codeplex.com/ - see the "Required Products" section
Now it works. But my concern is that it takes too long to produce the final report with charts. I used the SQL Server 2008/R2 template with the PAL tool on my laptop, it takes about one hour.
Hold on, still error although the .html report is produced. It is half done.
Generating the HTML Report...Done
C:\Users\CK\Documents\PAL Reports\PAL_Microsoft_SQL_Server_2008___R2_PAL_ANALYS
IS_2013-05-21_04-42-53.htm1
WARNING: Please post errors or problems with this tool to the PAL web site
located at http://www.codeplex.com/PAL with the following error message and a
brief description of what you were trying to do. Thank you.
Invoke-Expression : Program 'PAL_Microsoft_SQL_Server_2008___R2_PAL_ANALYSIS_20
13-05-21_04-42-53.htm' failed to execute: %1 is not a valid Win32 application
At line:1 char:2
+ & <<<< 'C:\Users\CK\Documents\PAL Reports\PAL_Microsoft_SQL_Server_2008___R2_
PAL_ANALYSIS_2013-05-21_04-42-53.htm'.
At D:\Program Files\PAL\PAL\PAL.ps1:5213 char:22
+ Invoke-Expression <<<< -Command "&'$HtmlReportFilePath'"
+ CategoryInfo : ResourceUnavailable: (:) [Invoke-Expression], Ap
plicationFailedException
+ FullyQualifiedErrorId : NativeCommandFailed,Microsoft.PowerShell.Command
s.InvokeExpressionCommand
Generating the HTML Report...Done
C:\Users\CK\Documents\PAL Reports\PAL_Microsoft_SQL_Server_2008___R2_PAL_ANALYS
IS_2013-05-21_04-42-53.htm1
WARNING: Please post errors or problems with this tool to the PAL web site
located at http://www.codeplex.com/PAL with the following error message and a
brief description of what you were trying to do. Thank you.
Invoke-Expression : Program 'PAL_Microsoft_SQL_Server_2008___R2_PAL_ANALYSIS_20
13-05-21_04-42-53.htm' failed to execute: %1 is not a valid Win32 application
At line:1 char:2
+ & <<<< 'C:\Users\CK\Documents\PAL Reports\PAL_Microsoft_SQL_Server_2008___R2_
PAL_ANALYSIS_2013-05-21_04-42-53.htm'.
At D:\Program Files\PAL\PAL\PAL.ps1:5213 char:22
+ Invoke-Expression <<<< -Command "&'$HtmlReportFilePath'"
+ CategoryInfo : ResourceUnavailable: (:) [Invoke-Expression], Ap
plicationFailedException
+ FullyQualifiedErrorId : NativeCommandFailed,Microsoft.PowerShell.Command
s.InvokeExpressionCommand
