SQL 2012 Counters

Sep 30, 2013 at 3:24 PM
Any plans to update PAL with SQL 2012 Counters?
Coordinator
Oct 3, 2013 at 5:17 PM
Not that I know of. David Pless (dpless@microsoft.com) is published in the PAL tool as the content owner when you select the SQL Server 2008 R2 threshold file. I'll ping him to see if there are any updates that he wants to add.
Oct 15, 2013 at 12:09 AM
I tried to change the template to work quickly but of course the actual tool doesn't recognise it when loading.
:-/ Dang!
2012 template would be cool.
Oct 31, 2013 at 10:46 AM
Hi! Can I support the creation of a 2012 template? I urgently need to create base linign for several SQL Server 2012 and PAL is a great tool for that Job!
Coordinator
Nov 4, 2013 at 5:10 PM
David Pless just sent me a SQL Server 2012 threshold file. I will upload it to the main downloads portion of the site for now since there is no significant changes to PAL at this time other than the threshold file.
Nov 5, 2013 at 5:45 AM
Hi Client, hi David,
works like a charm, thanks a lot!
Nov 6, 2013 at 10:55 AM
Hi!
I just ran in this Problem, what does it mean?
[Started] SQLServer:Buffer Node Page life expectancy
        Counter data for "000"...Done
        Generating Charts..Done
        Processing Thresholds.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 : The variable '$CollectionOfSQLServerBufferManagerPagelifeex
pectancy' cannot be retrieved because it has not been set.
At C:\Program Files\PAL\PAL\PAL.ps1:3392 char:22
+     Invoke-Expression <<<<  -Command $sCode
    + CategoryInfo          : InvalidOperation: (CollectionOfSQL...elifeexpect
   ancy:Token) [Invoke-Expression], RuntimeException
    + FullyQualifiedErrorId : VariableIsUndefined,Microsoft.PowerShell.Command
   s.InvokeExpressionCommand
I happens either with the .blg or the .csv data file.
System is Windows Server 2012 and SQL Server 2012.
Coordinator
Nov 7, 2013 at 8:50 PM
Hi MaxiPalle,

Please download the SQLServer2012.xml file again from the PAL download page. I recently fixed this problem.

Thank you,
Nov 11, 2013 at 9:24 AM
Hi Clint,

still same error message.

Regards from the Baltic coast!
Coordinator
Nov 12, 2013 at 6:01 PM
Is it the exact error? Please make sure that you deleted the old SQLServer2012.xml file. If it is the same error, then I'm not sure what else it could be.
Nov 21, 2013 at 9:51 AM
Hi Clint,
yes, I deleted the XML and ran the reports. No matter which system I tested, the error always occurs!
Is there any way I can provide you with additional Infos?
Nov 21, 2013 at 5:14 PM
Just sharing the error that I got processing SQL Server 2012 data with the latest (Nov 6th 2013) XML file. GIFs rendered but the HTML processing was halted - analysis not complete.

Using PAL 2.4 (latest release).

Error received in the CMD window:

Invoke-Expression : The variable '$iMemPoolMax' cannot be retrieved because it has not been set.
At C:\Program Files\PAL\PAL\PAL.ps1:3401 char:5
  • Invoke-Expression -Command $sCode
  • ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    • CategoryInfo : InvalidOperation: (iMemPoolMax:String) [Invoke-Expression], RuntimeException
    • FullyQualifiedErrorId : VariableIsUndefined,Microsoft.PowerShell.Command
      s.InvokeExpressionCommand
Coordinator
Nov 21, 2013 at 7:54 PM
Hi hakksaww,

Thank you for reporting this. What parameters was passed into the script? That variable is only in the QuickSystemOverview.xml file - not in the SQL Server 2012 threshold file.
Coordinator
Nov 21, 2013 at 7:58 PM
Hi MaxiPalle,

What parameters are you passing into the script? I'll see if I can reproduce the problem. Also, if you can upload the counter log as well, then I can debug it. http://bit.ly/PalUpload.
Jan 8 at 12:41 PM

Hi Clint,

I’m currently uploading the .blg. These are the parameters I’m using:

Powershell ".\PAL.ps1"

-Log 'C:\PerfLogs\BSHDB02_20140108-000001\PAL_Microsoft_SQL_Server_2012_PLT.blg'

-ThresholdFile 'C:\Program Files\PAL\PAL\SQLServer2012.xml'

-Interval 'AUTO'

-IsOutputHtml $True

-HtmlOutputFileName '[LogFileName]_PAL_ANALYSIS_[DateTimeStamp].htm'

-IsOutputXml $False

-XmlOutputFileName '[LogFileName]_PAL_ANALYSIS_[DateTimeStamp].xml'

-OutputDir 'c:\PAL Reports'

-AllCounterStats $False

-NumberOfThreads 1

-IsLowPriority $False

-PLEHealth '1000'

-OS '64-bit Windows Server 2008 R2'

-PhysicalMemory '16'

-UserVa '2048'

Thanks and regards,

MaxiPalle

Von: ClintH [email removed]
Gesendet: Donnerstag, 21. November 2013 21:59
An: [email removed]
Betreff: Re: SQL 2012 Counters [PAL:459720]

From: ClintH

Hi MaxiPalle,

What parameters are you passing into the script? I'll see if I can reproduce the problem. Also, if you can upload the counter log as well, then I can debug it. http://bit.ly/PalUpload.

Coordinator
Jan 11 at 7:19 PM
Hi MaxiPalle,

I used those parameters and it processed just fine. I'm using an unpublished version through. I will publish it as PAL 2.4.1 soon, so please try that version when it releases.
In addition, put the counter log and the output directory at locations that your user account can write to without requiring elevated privileges. C:\Perflogs is considered a high privileged location since it is not directly under your user account's My Documents folder. Try putting the counter log and specifying an output directory under your My Documents folder. Other than that, make sure that you are using an English-US locale as well.

Thank you,
-ClintH