LogParser and Perfmon CSV

Microsoft Log Parser Toolkit

 By Gabriele Giuseppini, Mark Burnett

Checking the fields parsed by LogParser from the CSV file.

logparser.exe file: -i:CSV Test_000001.csv -iTsFormat: “MM/dd/yyyy hh:mm:ss.ll”

Example, of a query to calculate the average, maximum and minimum number of processes in each minute:

SELECT TO_STRING(Minute, ‘hh:mm’) As MinuteStr,

AVG(\\GAB1\System\Processes) As AvgProc,

MAX(\\GAB1\System\Processes) As MaxProc,

MIN(\\GAB1\System\Processes) As MinProc

USING QUANTIZE([(PDH-CSV 4.0) (Pacific Daylight Time) (420)], 60) As Minute

FROM Test_00000.csv

GROUP BY Minute

logparser.exe file:Ch01PerfMonAverages.sql -i:CSV -iTsFormat:”MM/dd/yyyy hh:mm:ss.ll”