Re: IIS Logs Max Per Hour

From: nemb (nemb.1dtcel_at_mail.mcse.ms)
Date: 10/08/04

  • Next message: Steve Kass: "Re: SQL 2000 fails to detect NULL values" 
    Date: Fri, 8 Oct 2004 08:33:37 -0500

    Simon Jelinek wrote:
    > *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 

    --
nemb
------------------------------------------------------------------------
Posted via http://www.mcse.ms
------------------------------------------------------------------------
View this thread: http://www.mcse.ms/message994945.html
  • Next message: Steve Kass: "Re: SQL 2000 fails to detect NULL values"

    Relevant Pages

    • Re: Automated analysis of logs?
      ... > into (especially IIS logs) and get not only statistics, ... save output in some various format like XML, IIS log or directly to the SQL ... Is SPAM over-loading your e-mail server, ... SurfControl E-Mail Filter is flexible, ...
      (Security-Basics)
    • Re: Selecting rows from a distinct selection of one field
      ... > You can get the first row for each IP with: ... >> I'm not that new to SQL, but still I can't figure this out. ... >> I'm writing some routines to check through IIS logs. ... >> Adam Smith ...
      (microsoft.public.sqlserver.programming)
    • Re: Selecting rows from a distinct selection of one field
      ... Please post DDL + sample data + desired result. ... > I'm not that new to SQL, but still I can't figure this out. ... > I'm writing some routines to check through IIS logs. ...
      (microsoft.public.sqlserver.programming)
    • IIS Logs Max Per Hour
      ... Using a dts package to transfer IIS logs into a SQL ... i have create a query that is a count of [c-ip] i would ... but generally data is at per second level? ...
      (microsoft.public.sqlserver.mseq)
    • How to import text files using a wildcard in the filename
      ... I am trying to import IIS logs using a DTS package. ... I dont see a good way to make a primary key. ... I selected the Date, Time, C-IP, and Stem and tried to make them a key, but ...
      (microsoft.public.sqlserver.dts)