sql server mseq: IIS Logs Max Per Hour -- sql server mseq

IIS Logs Max Per Hour

Simon Jelinek
8/26/2004 8:13:51 AM

sql server mseq:

Hi

Being very new to SQL so iam hoping that this will be
easy.

Using a dts package to transfer IIS logs into a SQL
database i would now like to knpw of there is any
resource that gives some idea on the best stats to take
from IIS Logs.

i have create a query that is a count of [c-ip] i would
like to find out what is the max hourly count of [c-ip]
grouped by day the data is very mixed as when log a is
recorded could be 3 a second or not one for a few

Re: IIS Logs Max Per Hour

nemb
10/8/2004 8:33:37 AM

[quoted text, click to view]

Try asking your manager, I hear he is very good at this sort of thin

-
nem
-----------------------------------------------------------------------
Posted via http://www.mcse.m
-----------------------------------------------------------------------
View this thread: http://www.mcse.ms/message994945.htm