SharePoint 2010 Logging Database
As mentioned in other posts, SharePoint 2010, without doubt, is a bunch of exciting features and options. 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.
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 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!
Take advantage of SharePoint Logging Database and other useful features of Hosted SharePoint 2013, SharePoint 2010 hosting, SharePoint Foundation hosting or SharePoint Server 2010 – with shared or dedicated hosting by Apps4Rent. Also see feature by feature comparison of SharePoint Foundation vs Server 2010. We offer free SharePoint with our hosted exchange plans. Microsoft Office SharePoint Server 2007 or MOSS 2007 is also available.