SharePoint Dragons

Nikander & Margriet on SharePoint

Leveraging the logging database to see performance counters

SharePoint Server 2010 ships with a logging database (default name: WSS_Logging). You can make sure information gets added into it by opening SharePoint Central Administration > Monitoring > Timer Jobs > Review Job Definitions and enable or run all timer jobs starting with “Diagnostic Data Provider”.

After that, if you want to take a look at the performance counters, you can use the PerformanceCounters view in the logging database. Since it only shows counterid’s, the view in itself is not very helpful unless combined with information coming from the PerformanceCountersDefinitions table that includes the path and the instance name of the performance counters, like this:

SELECT TOP 1000 [PartitionId]
      ,[RowId]
      ,[LogTime]
      ,[MachineName]
      ,[CounterId]
      ,[Value]
      ,[RowCreatedTime]
      , pd.counter
      , pd.instance
  FROM [WSS_Logging].[dbo].[PerformanceCounters]
  join [WSS_Logging].[dbo].[PerformanceCountersDefinitions] pd ON counterid = pd.id

About these ads

3 responses to “Leveraging the logging database to see performance counters

  1. Pingback: Using the entity framework to see the contents of the SharePoint logging database « SharePoint Dragons

  2. Pingback: The SharePoint Blog » SharePoint 2010 – Tips for dealing with performance issues

  3. Pingback: SharePoint 2010: Tips for Dealing with Performance Issues (en-US) « Wayne's Arbitrary Article Collection

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 349 other followers

%d bloggers like this: