Thursday, December 24, 2009

Importing SharePoint ULS and IIS Logs into SQL

Various tools exist to parse these log files but one can use Microsoft’s Log Parser command line utility to write the log files to SQL Server tables.  From there the log data can easily be analyzed and used as the data source for Reporting Services reports.  Having the log data in a single queryable data structure offers a clear advantage over picking through thousands of log files when your site is down and the pressure is on to find the root issue.


An useful article by David Jansen at http://www.sqlservercentral.com/articles/ETL/68843/

No comments:

Post a Comment