IIS Logs Max Per Hour

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
seconds ? but generally data is at per second level?

Quote:

Originally posted by Simon Jelinek
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
seconds ? but generally data is at per second level?

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