Reader small image

You're reading from  Microsoft SharePoint 2010 Administration Cookbook

Product typeBook
Published inJan 2011
Reading LevelIntermediate
PublisherPackt
ISBN-139781849681087
Edition1st Edition
Languages
Right arrow
Author (1)
Peter Serzo
Peter Serzo
author image
Peter Serzo

Peter Serzo is an English major from Kent State who started his technical career with EDS out of college. 20 years later, all as a consultant, he is a national speaker regarding to SharePoint having worked at organizations of all sizes. His next challenge is to bring SharePoint to children and teach them. He has been working with SharePoint since 2003 in companies such as Microsoft, Ford, ADP, and many others throughout the United States. He is a Senior SharePoint Architect for High Monkey Consulting. The name refers to an old Jamaican proverb that means the higher up you go, the more responsible you must be; High Monkey takes pride in its accountability and excellence of work in regards to its clients' needs.
Read more about Peter Serzo

Right arrow

Accessing the SharePoint 2010 logging database


As mentioned in the introduction, the SharePoint 2010 logging database is a major enhancement to monitoring, debugging, and protecting the health of the farm.

By default, the database is called WSS_Logging. This database should be the starting point for administrators to collect and analyze information.

In this recipe, we will access the database and run a view (that already is installed) against it.

Getting ready

You must have farm-level administrative permissions to the Central Administration site. You must have read and execute permissions as well to the WSS_Logging database in order to open and execute views.

How to do it...

  1. 1. Open up SQL Server Management Studio.

  2. 2. When asked for authentication, log in to the correct instance where SharePoint is running using your windows authentication credentials. If SQL authentication is the preferred method of connecting, use the appropriate User ID/Password.

  3. 3. Navigate to the WSS_Logging database and...

lock icon
The rest of the page is locked
Previous PageNext Page
You have been reading a chapter from
Microsoft SharePoint 2010 Administration Cookbook
Published in: Jan 2011Publisher: PacktISBN-13: 9781849681087

Author (1)

author image
Peter Serzo

Peter Serzo is an English major from Kent State who started his technical career with EDS out of college. 20 years later, all as a consultant, he is a national speaker regarding to SharePoint having worked at organizations of all sizes. His next challenge is to bring SharePoint to children and teach them. He has been working with SharePoint since 2003 in companies such as Microsoft, Ford, ADP, and many others throughout the United States. He is a Senior SharePoint Architect for High Monkey Consulting. The name refers to an old Jamaican proverb that means the higher up you go, the more responsible you must be; High Monkey takes pride in its accountability and excellence of work in regards to its clients' needs.
Read more about Peter Serzo