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 WSS_Logging, 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.

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 in SharePoint Server is one of the many new concepts that will make the life of many SharePoint administrators quite a bit more enjoyable. So catch up on this soon! There is a lot of juice in the SharePoint family of products including Server 2010, SharePoint Foundation, SharePoint Server 2007, and associated free SharePoint templates!

by: Adrian Gates

POST COMMENT

Get Started With Lotus Notes Data Migration Process Data To Help You Decide On Nectarine Trees Stanley, Morgan & Associates Named Country's Leading Recovery Firm Addiction Recovery Programmes Credit Reporting Agencies Collect Data From Lenders Hypnosis For Anxiety: Taking Control Of Your Recovery From Social Anxiety Aspects Of Data Recovery Web Load Testing, Validation And Data Analysis Password Recovery Tool To Open Password-protected Database Better Opt For Outlook Password Recovery Than Using Pst19upg.exe The Ntfs System For Data Recovery How To Select A Good Data Logger Just What To Investigate For In A Executive Rehab And Substance Abuse Recovery Center