PAL SQL Server 2012 hangs at SQLServer:Buffer Node Page life expectancy



I downloaded the SQLServer2012 counters,
moved the 'SQLServer2012.xml' to 'C:\Program Files\PAL\PAL',
started the tool and generated the data collector template under 'Threshold File/Export to Perfmon Template file',
imported the template on my SQL 2012 Sp1 Cu4 box (Microsoft SQL Server 2012 (SP1) - 11.0.3368.0 (X64)
May 22 2013 17:10:44 
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)),
collected an hour worth of data
and started analyzing the .blg file with PAL v2.4.

The error message at about ~60%:

_[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
Workaround for me:
I removed the counter SQ'LServer:Buffer Node Page life expectancy' and ran another data collection. This time with not 1 hour worth of data, just about 5 minutes. The analysis finished successfully.


file attachments

Closed Nov 7, 2013 at 6:53 PM by ClintH


TimDebisz wrote Nov 6, 2013 at 6:21 AM

wow my formatting is off... sorry for that.

ClintH wrote Nov 6, 2013 at 6:47 AM

Thanks, Tim. I'll look into this. The threshold file is still being tested, so thank you for the feedback.

ClintH wrote Nov 6, 2013 at 6:57 AM

Ah, found it. There was a typo in the variable name. I fixed it and updated the SQLServer2012.xml threshold file on the PAL download page. I haven't tested it yet. Please let me know if it works.

wrote Nov 6, 2013 at 5:45 PM

TimDebisz wrote Nov 6, 2013 at 5:45 PM

Hi Clint,

just downloaded the new .xml and setup a new data collector set.
I don't see the 'Template Data Collector Set' after I:
Create new Data Collector Set/Which template would you like to use/Browse

The window stays empty and I'm not able to click 'next' or 'finish'

TimDebisz wrote Nov 6, 2013 at 6:42 PM

Hi Clint, please ignore my previous comment.
I used the wrong xml. The new version works like a charm.

ClintH wrote Nov 7, 2013 at 6:42 PM

Ah, good to hear. Thanks for the feedback and follow up. I appreciate it.

wrote Nov 7, 2013 at 6:53 PM

wrote Nov 7, 2013 at 6:53 PM