Why Is SharePoint Slow?

3. Optimize SharePoint:

The above points primarily dictate that "Hardware Requirement" and "Capacity Planning" are fundamental concepts and designed by the SharePoint architect, by gathering user requirements to provide a pilot SharePoint environment. Generally speaking, while setting SharePoint infrastructure and SQL server is quite easy to set up, the primary challenge arrives when more data is added to SharePoint lists/libraries and users keep complaining that SharePoint has become slow. The below are the reasons for slow SharePoint:

1. Tasks Manager on servers: Check the services which are consuming too much RAM and CPU. Use PowerShell script the services which are consuming more RAM.
   
2. Offload the SharePoint logs from C drive to other some drive on server.
   SharePoints logs are usually on the drive it was installed on, and in most cases that’s the C drive of the server. It’s recommended to move these logs to another partition, and preferably different drives altogether.
   
   • Go to Central Administration >> Monitoring >> Configure Diagnostic Logging.
   • Note the top part, Event Throttling. This specifies what SharePoint will log. If any of these have been changed from default, they’ll be in bold. Your ideal settings for all of them are
   • Least critical event to report to the event log: Information
   • Least critical event to report to the trace log: Medium
   • In the next section, Event Log Flood Protection, make sure that’s checked.
   • And in Trace Log section, feel free to move the logs to a different drive to either free up space on the current drive or to a unique drive. You may limit the amount of days or space the logs use per your preference.
   • Click OK.
     
3. Web Parts:
   
   • Large number of closed Web Parts, often on the home pages, will slow down a page. Every closed Web Part causes a small amount of processing overhead, and it can add up. To check this, add ?contents=1 to the page’s URL and remove any Web Parts which aren’t displayed. It can make a huge difference.
   • Enable Developer Dashboard - Any custom developed web part or third party web pat that is slowing the page. Developer dashboard contains information about Web Parts, events, DB calls and a whole lot of nifty information.
     
4. Large lists and libraries containing several thousand items can slow things down a lot too.
   
   Optimize: Content Query Web Part, list view and metadata navigation and search
   
5. Consider Warming up your SharePoint Site
   
   Warming up the pages across your SharePoint site is a good idea for two reasons. Firstly, ASP.NET’s Just-In-Time compiler will often cause the first access of a site to be extremely slow compared to usual. Secondly, the caching techniques discussed previously only kick in once a page has been visited for the first time. By running a script or job to warm up the site you can avoid the ‘first hit’ performance lag associated with these issues. There are a number of sources of information regarding this topic but one such article that seems to collate a lot of them is Wahid Saleemi’s Roundup: SharePoint Warm-Up Scripts.
   
6. Make Use of SharePoint’s Built-In Caching Functionality
   
   • Output Caching (Configurable)
     The concept of Output Caching is something that natively comes with SharePoint 2010, as it builds on and relies on ASP.NET caching techniques. This means that you can configure your SharePoint 2010 site to cache the Pages it outputs. The reasoning behind caching a page is obviously that it takes time to generate the content on any page, and on a heavily accessed site it would be a performance impact to generate a new page on every request – that’s where Output Caching comes in handy.
   • Object Caching (Configurable)
     In SharePoint Server 2010 you’ve got the option to use Object Caching as well, which is a mechanism to cache specific page items. This is especially likable if you’re playing around with Cross-List data queries and need to cache the results of such a query.
   • BLOB Cache (Configurable)
     In SharePoint 2010 you also have something called the BLOB Cache, which is a disk-based caching mechanism that caches resources on the disk. Normally these resources are files served by a web page and are named Binary Large OBjects (BLOB).

     <BlobCache location="D:BLOB" path=".(gif|jpg|jpeg|jpe|jfif|bmp|dib|tif|tiff|ico|png|wdp|hdp|css|js|asf|avi|flv|m4v|mov|mp3|mp4|mpeg|mpg|rm|rmvb|wma|wmv)$" maxSize="10"
     enabled="false" />

     
     Make Use of SharePoint’s Built-In Caching Functionality
     
7. Distributed Cache Service Application:
   
   SharePoint Distributed cache service is an automatic service. However, if we configure to a dedicated distributed cache service you may face some challenges.
   I had earlier written a detailed blog specifically about the challenges with Distributed Cache service.
   I had a chance to work an outsourced (inexperienced) vendor and they claimed that SharePoint server on pre-release were slow servers. As a matter of fact, vendors has absolutely no idea how to solve the issue. It is a migration project from SharePoint 2010 to SharePoint 2013 and the SharePoint 2010 had a heavily custom site and branding.
   
   This how I found the root cause.
   • Hardware specifications: I checked both the staging environment and pre-release environment hardware specs. There were absolutely identical. So it's ruled out.
   • SQL Server: SQL server settings, parameters and assigned memory were identical. So it's ruled out.
   • Firewall: The Firewall rules were verified for both the environments there were identical. So it's ruled out.
   • Search settings: Content Sources were configured as incremental. Continuous crawl was configured. So it's ruled out.
   • Distributed cache settings: Service is started status on App server. It's not enabled on WEB server.
   • Developer Dashboard: I turned on Developer dashboard both the staging and pre-release environments to check the page performance. I noticed staging environment Internet Explorer developer tools showed page load 1.5 seconds but whereas pre-release environment showed 6 seconds for the custom branding site.
     I checked if any error on the ULS tab for developer dashboard. I couldn't find any error that showed whatsoever that jump of execution of 6 seconds.
     ULS viewer didn't give error that gives any indication of 6 sec jump. However, I know it could be of Distributed Cache service. What I know is that there is some wrong in this pre-release environment.
   • New Web Application: To narrow down this issue, I created a Web application using team template. I asked vendor if they have code related My Site or Distributed cache. They do have some custom code related to My Site. I removed their solution.
     Turn off and turn on the Distributed cache sever. Restarted the timer service on App and web server. The new Web application's site loads within 1 second.
     It tuned out that issue was custom code made web application non performant and vendor admitted that it was their code that had an issue.
     
8. Search Service Application:
   
   One of the sluggish performances could be from Search service application. Following the tips to improve:
   • Ensure that we have SharePoint 2013 March patch.
   • Reduce the Search crawl time interval.
   • Major change could be change the Search’s server’s noderunner. Make a copy of noderunner.exe.config (C:\Program Files\Microsoft Office Servers\15.0\Search\Runtime\1.0\noderunner.exe.config)
     
     The default is Maximum. We can adjust the search performance by setting PartlyReduced or Reduced
     
     Set-SPEnterpriseSearchService -PerformanceLevel Reduced

I hope this blog helps and please comment if this blog post is helpful.