Database Performance Metric Provider SharePoint 2013 Timer Job causing 15 seconds page load

Recently, I came across a performance issue in my SharePoint 2013 development environment (RTM) with SQL Server 2012 causing every page to take about 15 seconds to load.

My SharePoint 2013 development environment has all the service applications deployed in line under the hood, with more than enough CPU and memory available, despite this the issue of 15 seconds page load still remained.

Many areas of SharePoint 2013 can be enhanced to gain performance improvements, but my issue was specifically related to a SharePoint timer job “Database Performance Metric Provider”. After some quick research, I found that this timer job is not even listed on TechNet Timer job reference (SharePoint 2013) and should not be confused with the“Performance Metric Provider” Timer Job – this is different!

Having checked the SQL Server error logs, I found the message “Using ‘dbghelp.dll’ version ‘4.0.5’” being logged about 5-6 times a minute – flooding SQL error logs and keeping SQL Server very busy!

sql-error-log-dbghelp

Furthermore, this is a known issue and a workaround is addressed in forums, but its unconfirmed if this is fixed with cumulative updates or with the March 2013 public update.

As a temporary resolution, I disabled Database Performance Metric Timer Job followed by restarting SharePoint services, my page loads reduced from 15 seconds down to about 2-3 seconds! Additionally the SQL error log messages as described above disappeared – nice!

I’d love to know if anyone have come across this issue and please leave comment if you have any additional info about the workaround above.

Hope this helps!
Chirag (@techChirag)

This post first appeared here: http://blog.pointbeyond.com/2013/06/20/database-performance-metric-provider-sharepoint-2013-timer-job-causing-15-seconds-page-load/

Advertisements

Chirag is an Independent Consultant at Patel Consulting, Chartered IT Professional, TOGAF9 Certified Architect and Microsoft Certified Solution Expert (Productivity, Data Platform) based in London, UK with more than 15 years of industry experience. He works with a wide variety of clients in many sectors, designing and implementing business collaboration, data and information management solutions and services based on SharePoint and Office 365 technologies to create business value for both themselves and their customers, including UK Microsoft Gold Partners with deployment, upgrade and migration services delivery. Chirag is an active SharePoint community participant, frequent speaker at local and international events including SharePoint Saturdays and Collab365. He is also one of the co-organisers of the SharePoint User Group UK (London) region. In 2011, for his valuable contributions to Microsoft TechNet forums he received a Microsoft Community Contributor Award. In his little spare time he enjoys cycling, cricket and every year participating in Charity bike rides and Duathlons. You can find him online at www.techchirag.com and follow Chirag on Twitter at @techChirag.

Tagged with:
Posted in SharePoint

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 )

Google+ photo

You are commenting using your Google+ 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 )

w

Connecting to %s

SharePoint Community

Categories
%d bloggers like this: