SQL Server Performance Forum – Threads Archive
IIS logs on SQL2000/MSDE(?)
In IIS there is a possibility to save the webserver traffic-logs directly to an odbc datasource such as SQL server 2000. Do any of you guys have experience in this field, what sort of strain it would pose on the database (it would have to be my production SQL2k-database, or an MSDE maybe?) and any pros/cons? —Frettmaestro
"Real programmers don’t document, if it was hard to write it should be hard to understand"
The big con is that it will stop IIS (at least IIS6) from caching, this probably makes it not a worthy option for a production implementation… Cheers
Twan
In terms of performance I agree with Twan and if its compulsory thensearch for MS Log Parser which is a easy to import log files into sql server without all that scripting and the risk of script timeouts if your log files are too large. And also I think there is a configuration in IIS that will store the logs in sql server. In the IIS configuration dialogs, under Web Site, where you enable logging, it allows you to specify the save format. One of the choices is to ODBC, which you can configure to use sql server. HTH
_________
Satya SKJ
Moderator
SQL-Server-Performance.Com
Basically I see no need for this.
However, you can directly query the log from your asp pages.
Maybe I’ll find a link for you. Is it that what you want or what are you looking for? Frank
http://www.insidesql.de
http://www.familienzirkus.de
What I’m looking for is a cheap and somewhat easy way to run reports on my IIS-logs, and I would also like some custom functionality like sql offers. I’m using WebTrends 7 at the moment but the reports it creates are too general so I need something more detailed. I know for sure satya that IIS can log to SQL server (I run the logs to an access-db locally) but if it prevents caching I definetly have to reconsider. The problem is that IIS generates about 60-70MB’s of logfiles every day and running monthly stats using some sort of scripting on the logfiles would get old pretty fast. I haven’t heared of "MS Log Parser" but I’ll look into it right away… —
Frettmaestro
"Real programmers don’t document, if it was hard to write it should be hard to understand"
More about LP from herehttp://www.microsoft.com/downloads/…familyid=8cde4028-e247-45be-bab9-ac851fc166a4 _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
Downloading as we speak… <img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ /><br /><br />–<br />Frettmaestro<br />"Real programmers don’t document, if it was hard to write it should be hard to understand"
Finally found the link, if it’s not too late…
http://www.iisfaq.com/default.aspx?View=A486&P=141 is for log files in general
Frank
http://www.insidesql.de
http://www.familienzirkus.de
Great Frank, I had to change recovery-model to simple but it worked. The bad part is that I have about 100 logfiles, so I’ll have to find a way to merge them or something. 1.8GB alltogether so it’s gonna be quite a handful for by poor laptop. Haven’t have the time to try Log Parser yet but I’ll surely look into that before I start anything huge. —
Frettmaestro
"Real programmers don’t document, if it was hard to write it should be hard to understand"
]]>