SharePoint Takes 15 Seconds to Load Page

Question

I've got a problem with my SharePoint 2010 farm and I can't think where to start. Bizzarly, this is happening in multiple completly seperate environments (DEV/TEST/PREPROD/PROD).

Every so often (apparently randomly, about 10 to 50 minutes apart), a page will randomly go from loading in under a second to taking 15+ seconds.

This happens totally randomly, even with a warmup script and multiple users browsing all day.

I've gone through my logs and found that the following entries correspond to the slow loading pages.

11/17/2011 16:02:21.15  w3wp.exe (0x1600)                           0x1410  SharePoint Foundation           Monitoring                      b4ly    High        Leaving Monitored Scope (ExecuteWcfOperation:http://schemas.microsoft.com/sharepoint/taxonomy/soap/IDataAccessReadOnly/GetChanges). Execution Time=15026.2985938157  
11/17/2011 16:02:21.15  w3wp.exe (0x1600)                           0x1410  SharePoint Foundation           Monitoring                      b4ly    High        Leaving Monitored Scope (Proxy Channel call for Enterprise Metadata Service). Execution Time=15027.1171336022    
11/17/2011 16:02:21.18  w3wp.exe (0x0510)                           0x0D08  SharePoint Foundation           Monitoring                      b4ly    High        Leaving Monitored Scope (ExecuteWcfOperation:http://schemas.microsoft.com/sharepoint/taxonomy/soap/IDataAccessReadOnly/GetChanges). Execution Time=15040.257909874   
11/17/2011 16:02:21.18  w3wp.exe (0x0510)                           0x0D08  SharePoint Foundation           Monitoring                      b4ly    High        Leaving Monitored Scope (Proxy Channel call for Enterprise Metadata Service). Execution Time=15040.9197258311   

At the time of freeze the CPU on the SharePoint WFE and APP servers is fine, CPU and disk IO on the SQL server are fine and everything looks 'normal'.

Does anybody know what could be causing this strange behaviour? I've been looking at scheduled jobs and can't see anything that corresponds to the time of the delays.

Would love suggestions of things that could be causing this! Many thanks in advance.

Answer 1

We were having this same issue, though with a different service, search instead of managed metadata. The load frequently took 15 seconds. This KB article had the fix for us: http://support.microsoft.com/kb/2625048 .

SharePoint 2010 uses SSL to encrypt intra-farm communication. It should work invisibly, but under the right conditions, it can cause problems, resulting in these 15 second timeouts. The fix is to export SharePoint's SSL cert through PowerShell, then explicitly add it to the server's Trusted Root Authentication Provider store through the MMC's Certificate snap-in. The KB article has the steps.

Answer 2

Have you checked if the application pool from IIS has been reset when the page get 15+ seconds to load?

Answer 3

Here are some points which I could think of, which might help you,

1. It may depend on your farm configuration. If your farm is a stand alone server or the index server is hosted on the same web front end servers, this might occur when crawling occurs parallely.

2. Check for any timer jobs or user profile synchronization which might be running parallely.

3. Check for the custom web parts or custom codes that you have created on these pages which could have performance issues.

4. Check for Disk spaces, Database sizes or database performances that might have affected recently.