This post is a continuation of this article.

Scenario 8:Find out what is the peak time for your IIS Server

How can you find out what is the peak time (peak hour) for your Website using Logparser?

Answer:

Logparser "SELECT quantize(time,60), count(*) as Frequency from ex080716.log GROUP BY quantize(time,60) order by quantize(time, 60)" -rtp:-1

Here is a brief snapshot of my LogFile...

And here is the output...

QUANTIZE(time, 60) Frequency
------------------ ---------
02:37:00           4
02:38:00           3
02:39:00           8
02:40:00           55
02:41:00           215
02:45:00           40
02:46:00           36

Statistics:
-----------
Elements processed: 361
Elements output:    7
Execution time:     0.00 seconds

You may also try...

Logparser "SELECT quantize(time,60), count(*) as Frequency INTO Image.GIF from ex.log GROUP BY quantize(time,60) order by quantize(time, 60)"

Here is the output...

This tells me that 2:41 GMT is the Peak Minute for my web-site. If you want to get the details per hour... change the query to...

Logparser "SELECT quantize(time,3600), count(*) as Frequency INTO Image.GIF from ex.log GROUP BY quantize(time,3600) order by quantize(time, 3600)"

As you can easily figure out, my site doesn't have too many hits after all

Hope this helps...
Rahul

Quote of the day:
People who have no weaknesses are terrible; there is no way of taking advantage of them. - Anatole France