1

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,

Step 1

1

Step 2

Counter Log path .

2

Step 3

select the perform couter files.you can give any extension blg,tsv and csv

3

Step 4

select the Microsoft SQL Server 2005/2008/2008 R2.you can change the threshold file as per yuor requirements.

4

Step 5

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

5

Step 6

here you can set the delay in time interval

6

Step 7

specify the path where your outfile must be created

7

Step 8

In the Queue

you can take this powershell script  and make necessary changes

8

Step 9

Execute the query ot add it to the queue

 

9

Step 10

when you perfmon counters are analysed screen looks as below

 

10

Output of the PAL

 

12 11

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *