« Previous Next »

• 12-01-2008, 2:15 AM

  ziver_register Joined on 12-01-2008, 7:06 AM Posts 1

  Does ODBC Logging disable IIS Cache? Reply Contact Hello,  I want to store IIS logs directly to database, in order to get real time information about the site traffic. I will show custom advertisements in order to egt more traffic to the parts of the site that have low hits.  I have read that i might create a ODBC DSN to store the IIS log files in db, as mentioned in the article below : http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/8ea48fac-28c0-46ae-9b7a-e4682dae3264.mspx?mfr=true However it warns us as: "When ODBC logging is enabled, IIS disables the HTTP.sys kernel-mode cache. For this reason, implementing ODBC logging will degrade overall server performance. ODBC logging is not recommended unless your database limits you to this option" Does this mean IIS will disable all Caches? I use OutputCache in my pages, and also use System.Web.HttpRuntime.Cache to insert and fetch my frequently used objects. The question is: Using ODBC logging will disable my caching mechanism or not? Regards, Ziver

  Tags: LogsIIS 6cachingIIS Performance

• 12-01-2008, 5:39 AM

  In reply to

  steve schofield Joined on 06-10-2002, 8:54 PM MI Posts 3,966

  Re: Does ODBC Logging disable IIS Cache? Reply Contact Caching is two modes (kernel, user (aka output).  ODBC logging disables kernel level caching for logfiles.  I don't believe it disables kernel level caching for page content.  What it's referring to is logging. I'd recommend against using ODBC logging.   I'd look at other ways including using log parser to import files on a periodic basis to sql server.  This way you could control which columns are inserted, plus your server and sql server performance wouldn't be effected. Steve Schofield Windows Server MVP - IIS http://weblogs.asp.net/steveschofield http://www.IISLogs.com Log archival solution Install, Configure, Forget