SharePoint Logging Database


SharePoint Server 2010, without doubt, is a bunch of exciting features and options, some of which were not available in Microsoft SharePoint Server 2007. And one of the features that really enthuses me in SharePoint 2010 is the Logging Database feature. Logging Database, named as WSSLogging, helps aggregate logging data or information from the server farm into one central location. SharePoint aggregates all of the raw logging data accumulated in the text files under the 14 hive and imports it into this wonderful logging database. This is the only database in SharePoint that Microsoft will be happy to let the developers directly read, query and build reports against it. For someone who spends time in front of customers helping them to maintain a healthy and stable farm, logging database will be a constructive app in SharePoint 2010 and SharePoint Foundation.

The logging database by default contains the following information from all servers within the farm and it is fully supported to query this database directly.