how do I configure IIS to post logs to sql server?

Posted by stacker on Server Fault See other posts from Server Fault or by stacker
Published on 2010-05-14T23:48:17Z Indexed on 2010/05/14 23:56 UTC
Read the original article Hit count: 354

Filed under:

analytics

|

logging

|

iis7.5

|

.net4.0

|

sql-server-2008

how do I configure IIS to post logs to sql server?

How want to save ANY log to my site. the site has a lot of views and the data can be big in a very small time. In addition, I want to show analytics of the use, in real time, and for all the time.

Is it make sense to save all the logs in sql-server?
What is the pros and cons taking this approach have?
what other solution can I have?

© Server Fault or respective owner

Related posts about analytics

Google Analytics www 301 causing issues with In-Page Analytics

as seen on Pro Webmasters - Search for 'Pro Webmasters'
The closest question I could find to my problem is This one. The similarity is: I have a profile in Google Analytics (GA) that has been collecting data for a year. The domain setting in GA is "http://example.com". The site, however, will redirect any non-www request, to www.example.com, via a… >>> More
Real-time Big Data Analytics is a reality for StubHub with Oracle Advanced Analytics

as seen on Oracle Blogs - Search for 'Oracle Blogs'
What can you use for a comprehensive platform for real-time analytics? How can you process big data volumes for near-real-time recommendations and dramatically reduce fraud? Learn in this video what Stubhub achieved with Oracle R Enterprise from the Oracle Advanced Analytics option to Oracle Database… >>> More
Documentation in Oracle Retail Analytics, Release 13.3

as seen on Oracle Blogs - Search for 'Oracle Blogs'
The 13.3 Release of Oracle Retail Analytics is now available on the Oracle Software Delivery Cloud and from My Oracle Support. The Oracle Retail Analytics 13.3 release introduced significant new functionality with its new Customer Analytics module. The Customer Analytics module enables… >>> More
Google Analytics - Can I download the logs?

as seen on Server Fault - Search for 'Server Fault'
Can I download the raw logs of my Google Analytics data? I want to do some processing on the data. >>> More
Custom Tracking with Google Analytics

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to figure out how to use my google analytics account, and do custom tracking on certain links and such, but following the technical information on the help site on google isn't getting me anywhere. Has anyone done something like this? Point me in the right direction. >>> More

Related posts about logging

log file is not getting created using JDK logging with Commons-logging

as seen on Stack Overflow - Search for 'Stack Overflow'
When I run the TestJcLLoggingService class log messages are coming to Console but no log file is created, please help me if you know the answer. two source files are pasted below. TestJcLLoggingService.java package com.amadeus.psp.pasd.logging; import org.apache.commons.logging.Log; import org… >>> More
Python logging before you run logging.basicConfig?

as seen on Stack Overflow - Search for 'Stack Overflow'
It appears that if you invoke logging.info() BEFORE you run logging.basicConfig, the logging.basicConfig call doesn't have any effect. In fact, no logging occurs. Where is this behavior documented? I don't really understand. >>> More
Python: combine logging and wx so that logging stream is redirectet to stdout/stderr frame

as seen on Stack Overflow - Search for 'Stack Overflow'
Here's the thing: I'm trying to combine the logging module with wx.App()'s redirect feature. My intention is to log to a file AND to stderr. But I want stderr/stdout redirected to a separate frame as is the feature of wx.App. My test code: import logging import wx class MyFrame(wx.Frame): … >>> More
Redirect logging output using custom logging handler

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi Guys, I'm using a module in my python app that writes a lot a of messages using the logging module. Initially I was using this in a console application and it was pretty easy to get the logging output to display on the console using a console handler. Now I've developed a GUI version of my app… >>> More
Java Logger API

as seen on Oracle Blogs - Search for 'Oracle Blogs'
This is a more like a tip rather than technical write up and serves as a quick intro for newbies. The logger API helps to diagnose application level or JDK level issues at runtime. There are 7 levels which decide the detailing in logging (SEVERE, WARNING, INFO, CONFIG, FINE, FINER, FINEST)… >>> More