SharePoint Tip of the Month
Tips on troubleshooting SharePoint 2013 performance issues
So you just migrated to SharePoint 2013 and you notice that certain pages takes longer than 5 seconds to load:
1. Enable SharePoint Developer Dashboard
To enable the developer dashboard, launch the SharePoint 2013 Management Shell and run the following SharePoint PowerShell command:
- $content = ([Microsoft.SharePoint.Administration.SPWebService]::ContentService)
- $appsetting = $content.DeveloperDashboardSettings
- $appsetting.DisplayLevel = [Microsoft.SharePoint.Administration.SPDeveloperDashboardLevel]::On
Once the developer dashboard is enabled, navigate back to the page then click on the developer dashboard icon in the upper right, and the new dev dashboard window opens.
Reload the slow load page so that data is captured within the developer dashboard. If data does not show in the developer dashboard after refreshing the page, verify that the “Usage and Health Data Collection Service Application” is configured and all timer jobs are running.
Once inside the developer dashboard you may want to review the SQL tab to see how many queries are being performed from the page and how long each query is taking. The other tab you should review is the ULS tab to determine if any control on the page is generating an error.
2. Review the Web Part Maintenance page
When accessing the web part maintenance page, you should check to see if there is any closed web parts on the page. Keep in mind that closed web parts are not visible on the page but still making SQL queries. Delete the close web parts from the web part maintenance page. Then, reload page to see if the page stills load slowly. To access the web part maintenance page on the page that is loading slowly, add the following text after .aspx?contents=1 (http://abelsolutions.com//SitePages/default.aspx?contents=1).
3. Verify Distributed Cache Service is configured correctly and running
Review your distributed cache configuration and setting. If unclear on the Distributed Cache service and how it affects SharePoint, refer to the reference below.
Manage the Distributed Cache service in SharePoint Server 2013
Object Cache is another optional configuration that could relieve the slow page load. Reference the following article: Improve page rendering by configuring output caching.
There are many factors that contribute to SharePoint performance issues. The approaches outlined in this article will help with the troubleshooting process.
This SharePoint Tip written by Marlon Roberts, SharePoint Consultant at Abel Solutions.