Depends what you're trying to monitor as well. We're clusterring, so it's
not too bad... You may want to test it out. Just remember, that whether
you do the logging through Cold Fusion or through IIS, you'll likely have a
similar impact.
Here's the document on how exactly to configure:
http://support.microsoft.com/support/kb/articles/Q245/2/43.ASP
Here's the MS KB article on what Dave was talking about:
http://support.microsoft.com/support/kb/articles/Q142/5/57.asp
*** However, if your SQL Server isn't the same as your IIS box, and your SQL
Server has the performance, I wouldn't worry too bad either. When we
implemented, we never saw a performance loss because our SQL Server is a
workhorse. Best thing to do is test this yourself to see what kind of cost
there is to the database.
-----Original Message-----
From: Matt Robertson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 25, 2001 2:17 PM
To: CF-Talk
Subject: RE: Webstat
Thanks for the reality check. Makes perfect sense as all of a sudden you
could wind up body-slamming your db versus a simple textfile append. Maybe
the thing to do if I really want to get serious about this is to parse the
log file into a db table and go from there.
Bah. I need about another 6-8 hours in the day to keep up with all this
stuff.
Cheers,
--Matt--
---------- Original Message ----------------------------------
from: Dave Watts <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Wed, 25 Jul 2001 16:50:45 -0400
> Yup. With sql server in query analyzer, run the following script
> in the db you want logging. After that, go to your iis box(s) and
> create an odbc connection to that database if it doesn't exist.
> Finally, on the logging section of the iis properties, where it says
> log file format, it's normally set up to w3c log file format. One of
> the options is ODBC logging. Switch to that.
It's worth noting that this may significantly decrease web server
performance, according to Microsoft.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
