Skip to content

How to improve performance for SharePoint and Project Server Part 1

March 15, 2014

Slow performance of SharePoint & Project Server

If you are one of those facing slow performance of SharePoint sites, try one or all of the items mentioned below. Tuning your SQL server will definitely help you to improve site performance.

I try to put all items at one place here and I will also try to post supporting links where ever possible.

These steps can be used in SharePoint 2010/2013 with or w/o project server running on SQL server 2005/2008 or 2012.

 1-      Antivirus software makes SharePoint/Project Server performance slow. Folder mentioned musts  be excluded if file level antivirus software is being used on the servers. See list of folders at:  http://support.microsoft.com/kb/952167

2-      Wake up script can save user from facing site slowness when hitting the site for the first time after nightly application pool recycle (usually at 9am in the morning).

3-      Add SharePoint Cert in the Trusted Root certificate authority http://blogs.msdn.com/b/brismith/archive/2012/03/05/project-server-2010-slow-load-times-of-pwa-and-sharepoint-pages.aspx

If you are getting event ID 8421 in event viewer, this will also resolve that issue.

4-      I resolved a performance issues for one of my customer by setting  NIC Card configuration property named “Link Speed & Duplex”to 1000 Mbps, I don’t know why it was set to 100Mbps or how it got there but took me long to find this. You should check with your network admin also before making any changes to this property.

5-      Check with your network administrator for TCP Chimney Offload http://support.microsoft.com/kb/951037. By Default in Wind 2008 Servers, this setting is “Automatic”, we need to disable it if it’s not. “netsh int tcp set global chimney=disabled

( Why : http://blogs.msdn.com/b/psssql/archive/2008/10/01/windows-scalable-networking-pack-possible-performance-and-concurrency-impacts-to-sql-server-workloads.aspx)

6-      On your SQL server enable Common Language Runtime

sp_configure ‘clr enabled’, 1
Go
Reconfigure
Go

 7-      For the project data bases  set AUTO_CLOSE property  to False http://technet.microsoft.com/en-us/library/ee662107.aspx

8-      For project server databases set  AUTO_UPDATE_STATISTICS and AUTO_UPDATE_STATISTICS_ASYNCHRONOUSLY properties to True

9-      Discuss data base maintenance plans with your DB Admin. In short index rebuilding is helpful to improve performance. Check http://technet.microsoft.com/en-us/library/cc262731(v=office.14).aspx & http://technet.microsoft.com/en-us/library/cc973097.aspx

10-   SQL server MAX Degree of parallelism should be set to 1, talk to your DBA if not sure about this property.  http://technet.microsoft.com/en-us/library/cc298801.aspx#Section6_3

11-   Most of the time SharePoint server and SQL server are in the same subnet. But in case they are not, moving SharePoint server in the same subnet as DB server will improve performance as well.

12-   Check to see if you have enough RAM on server, check RAM, CPU usage on servers especially on SQL and all SharePoint servers.

13-   If you have Project Server installed on top of your SharePoint and facing slowness talk to your DB team and get a report on slow running queries. Try to enhance these queries so you can get the same result in less time if possible.

14-   If you have project server installed on top of SharePoint make sure you don’t go beyond the recommended number of custom fields. Impact can be significant  if you are using more than recommended custom fields at  http://technet.microsoft.com/en-us/library/hh297440.aspx

15-   Now the last and my favorite, Add additional TempDB files. There is lots of information on it but only thing I will share from my experience is that you can create multiple files and this will definitely improve performance but don’t go crazy on creating additional TempDB files using some formula or with number of CPUs. Too many TempDB files can also be an impact on performance. Start with additional 2 or 3 files and test your application for any improvement first, you can add more TempDB based on Sever CPU and Drives availability.

Search for TempDB and read the section that has information about TempDB at http://technet.microsoft.com/en-us/library/gg263353(v=office.14).aspxn

Some more information: http://blogs.technet.com/b/sqlpfeil/archive/2012/07/14/four-tips-for-sql-tuning-for-sharepoint-part-3-tempdb.aspx

I will try to add more here on how you can tune your IIS but need to test few things before that.

Feel free to share more tricks, thoughts or any suggestions.

Hope this will help someone. Enjoy!

Please check out Part 2 for more information on improving performance.

Advertisements
5 Comments
  1. Bob permalink

    Great article. Did you ever get the IIS work completed?

  2. Thanks Bob,
    Did not get a chance to complete yet still on my list of ToDo items!

  3. Yuri permalink

    Can you give some specifics or a link concerning number 6? Enabling CLR is one of those things that DBAs like to have a good reason for.

  4. Enabling CLR is recommended if you are using Project sever specially, but I don’t see any harm if you enable for SharePoint as well. Project server send tons of queries to the databases and by enabling CLR on SQL server help execute queries in less time and reduce stress on Application servers. It also reduce the SQL round trips and improve performance. For more see enable CLR section at: http://technet.microsoft.com/en-us/library/ee662108%28office.14%29.aspx#section3

Trackbacks & Pingbacks

  1. Improve Performance for SharePoint and Project Server – Part 2 | SharePoint 2013

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

%d bloggers like this: