SharePoint 2010 Logging Database

One of the features of SharePoint 2010 that is getting me really excited is the logging database. The purpose of this database (which is named WSS_Logging [One per Farm] by default) is to aggregate logging information from the farm into one central location.

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.

· ULS Logs

· Event Logs

· Selected Performance Monitor Counters:

o % Processor Time

o Memory Available Megabytes

o Avg. Disk Queue Length

o Process Private Bytes (OWSTIMER and all instances of w3wp)

· Blocking SQL Queries

· SQL DMV Queries

· Feature Usage

· A host of information on search crawling and querying

· Inventory of all site collections

· Timer job usage

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.

http://www.sharepointinnovations.com