Once you collect perfmon counters using perfmon.exe.we need to analyse the historic data collected from the server.Here we are using PAL(Performance Analysis of Log).which can be download from here.
when download and installation is done,
Counter Log path .
select the perform couter files.you can give any extension blg,tsv and csv
select the Microsoft SQL Server 2005/2008/2008 R2.you can change the threshold file as per yuor requirements.
In the Questions
OS :- Select the operating system
Physical Memory :- give the Installed RAM of the server from where the perfmon counters are collected
UserVA:- for 32 bit SQL Server we have to give the Virtaul addess space .if you are using 64 Bit server you can ignore this option
here you can set the delay in time interval
specify the path where your outfile must be created
In the Queue
you can take this powershell script and make necessary changes
Execute the query ot add it to the queue
when you perfmon counters are analysed screen looks as below
Output of the PAL