Issue Parsing perflog of SQLServer.Databases(*)\*

Oct 13, 2010 at 2:32 PM

I am relatively new to the windows performance logs and PAL so I apologize if this is a problem on my end.  I have created performance logs in the SQLServer.Databases(*)\* and WebServices(*)\* counter and when I try to parse either of the generated logs with PAL v2.0 I am getting:

Property 'Count' cannot be found on this object. MakeAt C:\Program Files\PAL\PAL v2.0.4\PAL.ps1:4381 char:4+         For ($t=0;$t -lt $alQuantizedTime. <<<< Coun    + CategoryInfo          : InvalidOperation: (.:Ope   ntainsErrorRecordException    + FullyQualifiedErrorId : PropertyNotFoundStrict

This is with the 64-bit version of PAL v2.0.4

Any help would be appreciated.

 

Coordinator
Oct 15, 2010 at 6:55 AM

I don't know what could cause this. Can you provide the PAL.log file at %temp%\pal.log?

Oct 25, 2010 at 5:08 PM

Hello,

I read this new and I have exactly the same behavior with my CSV perfolg but concerning one of my IIS server.

I shall be glad if you have some idea.

I provide you my pal.log below

 

**********************
Windows PowerShell Transcript Start
Start time: 20101025174430
Username  : ********
Machine   : ********* (Microsoft Windows NT 5.1.2600 Service Pack 3)
**********************
Transcript started, output file is C:\DOCUME~1\********\LOCALS~1\Temp\PAL.log
PAL v2.0.5 (http://www.codeplex.com/PAL)
Written by: Clint Huffman (clinth@microsoft.com) and other contributors.
Last Modified: 09/30/2010 00:34:30
The information and actions by this tool is provided "as is" and is intended for information purposes only. The authors and contributors of this tool take no responsibility for damages or losses incurred by use of this tool.

SCRIPT ARGUMENTS:
-Log D:\pour_BPACK\perf_serv_app\perf_Bpack_Web_000008.csv
-ThresholdFile C:\Program Files\PAL\PAL v2.0.5\IIS.xml
-Interval AUTO
-OutputDir [My Documents]\PAL Reports
-IsOutputHtml True
-HtmlOutputFileName [LogFileName]_PAL_ANALYSIS_[DateTimeStamp].htm
-AllCounterStats False
-IsOutputXml False
-XmlOutputFileName [LogFileName]_PAL_ANALYSIS_[DateTimeStamp].xml
-BeginTime
-EndTime


Creating session working directory...
Creating directory "C:\DOCUME~1\******\LOCALS~1\Temp\{e7f9e902-bc85-4d81-b14d-33fa454e86c4}"
Creating file "C:\Documents and Settings\******\Mes documents\PAL Reports\perf_Bpack_Web_000008_PAL_ANALYSIS_2010-10-25_17-44-31.htm"
Creating directory "C:\Documents and Settings\******\Mes documents\PAL Reports\perf_Bpack_Web_000008_PAL_ANALYSIS_2010-10-25_17-44-31\"

Threshold File Load History:
C:\Program Files\PAL\PAL v2.0.5\IIS.xml
SystemOverview.xml
QuickSystemOverview.xml
AspDotNet.xml
DotNet.xml

Generating the counter list to filter on...Done
Removing duplicate counter expressions from counter list...Done

Number Of Counter Instances In Perfmon Log: 67

Processing: Web Service Current Connections

Processing: Web Service ISAPI Extension Requests/sec

Processing: Web Service Other Request Methods/sec

Processing: Web Service Connection Attempts/sec

Processing: Memory Leak Detection

Processing: Handle Leak Detection

Processing: Process Thread Count

Processing: Process Working Set

Processing: Process Percent Processor Time

Processing: High Virtual Memory Usage

Processing: Process IO Data Operations/sec

Processing: Process IO Other Operations/sec

Processing: Memory Available MBytes

Processing: Processor % Processor Time

Processing: Processor % Privileged Time

Processing: Network Interface % Network Utilization

Processing: Network Interface Output Queue Length

Processing: System Processor Queue Length

Processing: System High Context Switching

Processing: LogicalDisk % Free Space

Processing: Processor % Interrupt Time

Processing: PhysicalDisk Read Latency Analysis

Processing: PhysicalDisk Write Latency Analysis

Processing: LogicalDisk Read Latency Analysis

Processing: LogicalDisk Write Latency Analysis

Processing: LogicalDisk % Idle Time

Processing: Memory Free System Page Table Entries

Processing: Memory Pool Non-Paged Bytes

Processing: Memory Pool Paged Bytes

Processing: Memory Pages/sec

Processing: Memory System Cache Resident Bytes

Processing: Memory Cache Bytes

Processing: Paging File % Usage

Processing: Memory Percent Committed Bytes In Use

Processing: LogicalDisk Disk Transfers/sec

Processing: Server Pool Nonpaged Failures

Processing: Server Pool Paged Failures

Processing: Memory Pages Output/sec

Processing: Memory Transition Pages RePurposed/sec

Processing: Network Interface Packets Outbound Errors

Processing: Memory Committed Bytes

Processing: LogicalDisk Read/Write Ratio

Processing: LogicalDisk Bytes/Read

Processing: LogicalDisk Bytes/Write

Processing: PhysicalDisk Current Disk Queue Length

Processing: LogicalDisk Avg. Disk Queue Length

Processing: Processor % DPC Time

Processing: Memory Commit Limit

Processing: ASP.NET Request Execution Time

Processing: ASP.NET Requests in Application Queue

Processing: ASP.NET Application Restarts

Processing: ASP.NET Worker Process Restarts

Processing: ASP.NET Requests Current

Processing: ASP.NET Request Wait Time

Processing: ASP.NET Requests Rejected

Processing: ASP.NET Apps v2.0.50727 Request Execution Time

Processing: ASP.NET Apps v2.0.50727 Requests/Sec

Processing: ASP.NET Apps v2.0.50727 Requests In Application Queue

Processing: .NET CLR Exceptions / Second

Processing: .NET CLR Loading Current appdomains

Processing: Memory Leak Detection in .NET

Processing: .NET CLR Memory % Time in GC

Generating the HTML Report...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.
Property 'Count' cannot be found on this object. Make sure that it exists.
At C:\Program Files\PAL\PAL v2.0.5\PAL.ps1:4381 char:43
+         For ($t=0;$t -lt $alQuantizedTime. <<<< Count;$t++)
    + CategoryInfo          : InvalidOperation: (.:OperatorToken) [], ParentCo
   ntainsErrorRecordException
    + FullyQualifiedErrorId : PropertyNotFoundStrict
 
**********************
Windows PowerShell Transcript End
End time: 20101025174433
**********************

 

Thanks

Coordinator
Nov 3, 2010 at 3:42 AM

It looks like PAL failed to match up counters in the threshold file with counters in the counter log. This commonly happens when running PAL on a non-English US locale. Are you running with an English US locale?

Nov 21, 2010 at 8:33 AM
Hello, it's look That I'm not With an "english us local" and now I don't have the possibility to correct this. If I have to use PAL in the future, I 'll set it in "english us local"
THanks for all


Le 3 nov. 2010 à 03:42, "ClintH" <notifications@codeplex.com> a écrit :

From: ClintH

It looks like PAL failed to match up counters in the threshold file with counters in the counter log. This commonly happens when running PAL on a non-English US locale. Are you running with an English US locale?

Read the full discussion online.

To add a post to this discussion, reply to this email (PAL@discussions.codeplex.com)

To start a new discussion for this project, email PAL@discussions.codeplex.com

You are receiving this email because you subscribed to this discussion on CodePlex. You can unsubscribe on CodePlex.com.

Please note: Images and attachments will be removed from emails. Any posts to this discussion will also be available online at CodePlex.com