SharePoint Logging Database by:Adrian Gates

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!

About the author

Adrian Gates (adrian@apps4rent.com) is a Business Manager with Apps4Rent; which offers Microsoft Exchange Hosting, Windows SharePoint Services, SharePoint Foundation 2010, SharePoint Server 2010, and virtual dedicated servers.

POST COMMENT

Document Management Has Improved With SharePoint Library … How? by:Adrian Gates Sharepoint 2010 Ribbon Menu by:Adrian Gates SharePoint2010 Quota Template Feature by:Adrian Gates Microsoft Business Intelligence Indexing Connector helps discover lost files by:Adrian Gates Monitor Your Business Using SharePoint 2010 PerformancePoint Services by:Adrian Gates SharePoint Server 2010 Remote BLOB Storage (RBS) by:Adrian Gates SharePoint 2010 Multi-lingual User Interface by:Adrian Gates What is SharePoint Health Analyzer? by:Adrian Gates Check Out How Federated Search Is Different In SharePoint Server 2010 … by:Adrian Gates Be Secured Using SharePoint Server 2010 Claims Based Authentication by:Adrian Gates Microsoft Exchange and Android by:Adrian Gates Microsoft Exchange and Palm OS Operating System by:Adrian Gates Microsoft Exchange, Mac and Windows by:Adrian Gates