Re: SQL Logging question ISA 2000
- From: "josephk" <josephk@xxxxxxxxx>
- To: "[ISAserver.org Discussion List]" <isalist@xxxxxxxxxxxxx>
- Date: Wed, 8 Sep 2004 03:26:23 -0700
Hi Pukhow,
I process approximately 5GB of data daily, small in comparison to other
sites I'm sure.
I bring in all the raw data, with scripts that I've created that
strip out the trailing blanks on all the fields. I don't like writing
directly to SQL from ISA Server.
Once, I have the raw data in place, I process all the raw stuff down
into appropriate tables, number hits,
By referrer, By Status Code etc. I then, save the current raw data to
disk and truncate my Db. All the processed tables
Are then used in cool graph's, OLAP, SQL reporting services and some
Crystal reports slowly moving all over to RS).
I've also have been creating tools to read in the raw data and place
into word and excel documents just in case
Management likes to read that type of stuff.
You might check out http://isatools.org for the scripts that I use at
my sites to read in the data.
The more people using them and giving feedback the better. I've been
working on C++ programs to read the data and
Do some up front processing before moving into SQL. It's faster then
script. But, heck the scripts work quite well.
Anyone else using them?
Thank you,
Joseph
-----Original Message-----
From: puukhow [mailto:puukhow@xxxxxxxxxxxxxxxxx]
Sent: Wednesday, September 08, 2004 2:35 AM
To: [ISAserver.org Discussion List]
Subject: [isalist] Re: SQL Logging question ISA 2000
http://www.ISAserver.org
Hello Joseph,
Thank you for your reply. I checked log in SQL2000 again,i confirmed
your words true.
>The ISA direct logging to SQL, pad the 255 field with blanks which
>would then take up the entire Field length. As to why It does this, I'm
>not sure
I wonder about it.
Hmmmmmm, Why ISA Server pad blank space?? I think if ISA dose not pad
blank
space,
SQL database can be small.
- Pukhow
----- Original Message -----
From: "josephk" <josephk@xxxxxxxxx>
To: "[ISAserver.org Discussion List]" <isalist@xxxxxxxxxxxxx>
Sent: Wednesday, September 08, 2004 3:17 AM
Subject: [isalist] Re: SQL Logging question ISA 2000
http://www.ISAserver.org
Hi Pukhow,
ISA doesn't always send 255 characters to the sql log. However, it must
at least be that amount to Cover the size that it does send. Varchar,
nvarchar are just that. They are variable length fields. A record could
be the size of 10 or 255 and the record will reflect that. I have at
times seen The ISA direct logging to SQL, pad the 255 field with blanks
which would then take up the entire Field length. As to why It does
this, I'm not sure.
Thank you,
Joseph
-----Original Message-----
From: PuKhow [mailto:puukhow@xxxxxxxxxxxxxxxxx]
Sent: Monday, September 06, 2004 8:22 PM
To: [ISAserver.org Discussion List]
Subject: [isalist] Re: SQL Logging question ISA 2000
http://www.ISAserver.org
Hi All,
Please teach me why ISA Server send car(255) to SQL Server. x-(
- Pukhow
> I tried ISA Server 2000 with SQL Server 2000.
> It works good but I have a question about W3PROXY.SQL and query from
> ISA 2000.
>
> Some w3proxy service log fields are "varchar(255)" by W3PROXY.SQL ,but
> ISA Server send always "char(255)" (if less characters than 255,ISA
> 2000 add blank space till 255 character). Why ISA 2000 send always 255
> characters??
>
> - Pukhow Tattoraya
------------------------------------------------------
List Archives: http://www.webelists.com/cgi/lyris.pl?enter=isalist
ISA Server Newsletter: http://www.isaserver.org/pages/newsletter.asp
ISA Server FAQ: http://www.isaserver.org/pages/larticle.asp?type=FAQ
------------------------------------------------------
Other Internet Software Marketing Sites:
World of Windows Networking: http://www.windowsnetworking.com Leading
Network Software Directory: http://www.serverfiles.com No.1 Exchange
Server Resource Site: http://www.msexchange.org Windows Security
Resource Site: http://www.windowsecurity.com/ Network Security Library:
http://www.secinf.net/ Windows 2000/NT Fax Solutions:
http://www.ntfaxfaq.com
------------------------------------------------------
You are currently subscribed to this ISAserver.org Discussion List as:
josephk@xxxxxxxxxxxxxxxxx To unsubscribe visit
http://www.webelists.com/cgi/lyris.pl?enter=isalist
Report abuse to listadmin@xxxxxxxxxxxxx
------------------------------------------------------
List Archives: http://www.webelists.com/cgi/lyris.pl?enter=isalist
ISA Server Newsletter: http://www.isaserver.org/pages/newsletter.asp
ISA Server FAQ: http://www.isaserver.org/pages/larticle.asp?type=FAQ
------------------------------------------------------
Other Internet Software Marketing Sites:
World of Windows Networking: http://www.windowsnetworking.com Leading
Network Software Directory: http://www.serverfiles.com No.1 Exchange
Server Resource Site: http://www.msexchange.org Windows Security
Resource Site: http://www.windowsecurity.com/ Network Security Library:
http://www.secinf.net/ Windows 2000/NT Fax Solutions:
http://www.ntfaxfaq.com
------------------------------------------------------
You are currently subscribed to this ISAserver.org Discussion List as:
puukhow@xxxxxxxxxxxxxxxxx To unsubscribe visit
http://www.webelists.com/cgi/lyris.pl?enter=isalist
Report abuse to listadmin@xxxxxxxxxxxxx
------------------------------------------------------
List Archives: http://www.webelists.com/cgi/lyris.pl?enter=isalist
ISA Server Newsletter: http://www.isaserver.org/pages/newsletter.asp
ISA Server FAQ: http://www.isaserver.org/pages/larticle.asp?type=FAQ
------------------------------------------------------
Other Internet Software Marketing Sites:
World of Windows Networking: http://www.windowsnetworking.com Leading
Network Software Directory: http://www.serverfiles.com No.1 Exchange
Server Resource Site: http://www.msexchange.org Windows Security
Resource Site: http://www.windowsecurity.com/ Network Security Library:
http://www.secinf.net/ Windows 2000/NT Fax Solutions:
http://www.ntfaxfaq.com
------------------------------------------------------
You are currently subscribed to this ISAserver.org Discussion List as:
josephk@xxxxxxxxxxxxxxxxx To unsubscribe visit
http://www.webelists.com/cgi/lyris.pl?enter=isalist
Report abuse to listadmin@xxxxxxxxxxxxx
Other related posts:
