SharePoint Logging Database

Re-Publish this Article

<h1>SharePoint Logging Database</h1><strong> Author: <a href='http://www.articleseen.com/profile_AdrianG.aspx'>AdrianG</a></strong><br /><p>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! </p><strong>About the Author:</strong><br />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.<p> Article Source: <a href='http://www.articleseen.com/Article_SharePoint-Logging-Database_36873.aspx'> http://www.articleseen.com/Article_SharePoint Logging Database_36873.aspx</a></p>

Article Source : http://www.articleseen.com/Article_SharePoint Logging Database_36873.aspx

Keywords : SharePoint, SharePoint Server 2010, Logging Database, SharePoint Logging Database,

Category : Computers : Computers