21/08/2012 Leave a comment
Sometime you may need to import ULS log files to SQL server . It can be done with several ways by using SQL Server import tools or import from an Excel file to SQL server. Or you can use fallowing free open source windows application tool. With this tool it can be done with more quickly . By multy-threading and bulk insert architecture feature provides you that ULS logs contains total 1.500.000 row can be upload in apprx. 2 minutes. (as you know it depends on your configuration and hardware)
Than you can query SQL tables as you wish : Fallowing query will return execution time over 1 sec for SPMonitoring event records.
select * from WFE1
where [ExecutionTime] > 1000 and [Eventid] =’b4ly’
order by [ExecutionTime] desc
“All These source codes are freeware and is provided on an “as is” basis without warranties of any kind, whether express or implied, including without limitation warranties that the code is free of defect, fit for a particular purpose or non-infringing. The entire risk as to the quality and performance of the code is with the end user“
For Download ULStoSQLImporter v1.0 for Sharepoint 2010: