Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mike123
Master Smack Fu Yak Hacker
1462 Posts |
 Posted - 2009-05-25 : 04:25:30
|
Pretty general question here ..Just wondering if anybody here has had any experience using Log Parser 2.2 for IIS, and inserting results of it into a MSSQL DB ..My concerns are regarding large log files and inserting summaries of the results etc.. perhaps there are certain tools out there I am unaware of ? Any references to anything of interest are greatly apprecaited !!thanks once again!  mike123 |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2009-05-28 : 00:09:19
|
| It works great, I just insert the raw rows. You could then create summaries of them to other tables and/or load them into an Analysis Services cube and delete the raw rows when you're done. I'm not sure offhand what performance I get but certainly thousands of rows per second, so I load millions of rows in a reasonable time. We use the IIS binary format so we get multiple sites in a single fairly compact log file and Log Parser works fine with that too. |
 |
|
|
ahmad.osama
Posting Yak Master
183 Posts |
Posted - 2009-06-13 : 06:38:06
|
quote:
Originally posted by mike123
Pretty general question here ..Just wondering if anybody here has had any experience using Log Parser 2.2 for IIS, and inserting results of it into a MSSQL DB ..My concerns are regarding large log files and inserting summaries of the results etc.. perhaps there are certain tools out there I am unaware of ? Any references to anything of interest are greatly apprecaited !!thanks once again! mike123
there is a report pack available for download at microsoft....I dont have a link but I do have the filename that I downloaded.....SQL2005RPIIS.msiU can google it to get to the link...Its great tool and easy to use...It has a database and the logparser query that u can use to insert log file database into the SQL Server database.As far as performance is concern...you can download the production log files locally and use this tool analyse the log files..Regards,Ahmad Osama |
|
|
|
|
|
|
inserting web logs into sql db