Sladescross's Blog

Blogging about Sharepoint related stuff

LogParser and Perfmon CSV September 7, 2009

Filed under: Log Parser,PerfMon,Tool — sladescross @ 4:06 pm

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”

About these ads
 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
Follow

Get every new post delivered to your Inbox.

Join 63 other followers