So you have installed SharePoint inside your organization. Now they asked you to maintain it.
The SharePoint Farm is made by many pieces and each of them have Log files that are stored into separate files and different formats.
To fully monitor your SharePoint Farm you would need to monitor all the pieces:
– Windows 2003 Event Logs
– SQL Server Log files
– IIS Log files
– SharePoint ULS Log files
– SharePoint Usage Logs if enabled
– SharePoint Indexing Logs.
There are two ways to monitor all this: Microsoft System Center
Operation Manager 2007 or by using the LogParser, a free tool from Microsoft, and a lot of scripting.
System Center Operation Manager 2007:
– Offers Management Packs for: Windows Server, SQL Server, Exchange Server, SharePoint, IIS, ForeFront Security, Computer Hardware.
– For a more detailed list of Management Packs available for S.C.O.M 2007 read here: http://www.microsoft.com/technet/prodtechnol/scp/catalog.aspx
– If you want a headache free and supported solution the use SCOM 2007.
– If you are on a tight budget or for a DIY administrator this is the alternative.
– Is a free utility from Microsoft that allows parsing and reporting of event logs and log files using a SQL like query language from command prompt.
– It is available for download at: https://www.microsoft.com/downloads/details.aspx?FamilyID=890cd06b-abf8-4c25-91b2-f8d975cf8c07&displaylang=en
– By using this tool you can get most of the information necessary to investigate any issue into the SharePoint Farm and create reports and charts for monitoring the health of your Farm.
– You can monitor all the servers event logs, SQL server error logs, SharePoint Logs and IIS Logs and generate reports in an html format.