Monday, April 22, 2013

How to improve SharePoint performance?

MS SharePoint has become the most popular product of Microsoft because so many organizations are adopting it. But the point of concern is that SharePoint performance is not that good because of  heavy use of SQL Server database. There are many reasons behind SharePoint slow performance like incorrect configuration, BLOB storage issue, large media files and many more. Here are some tips on improving SharePoint performance.

  1. Use different networks: Since SharePoint require SQL Server for performing most of its job, this increases load on server. So you should use different physical network for SQL and front end server to separate the user and database traffic.
  2. Reduce server load: A server farm basically consists of front end server, index application and SQL Server. Index server is responsible for processing both search and user queries. It also increases load on index server. You should add one more server for retrieving the search queries.
  3. SQL Server maintenance: In order to improve the efficiency of read/write operations SQL server maintain its own indexes. Gradually these indexes got fragmented and degrade SharePoint performance. So it is important to perform SQL maintenance operations including index fragmentation.
  4. Optimize server performance: If there is heavy load on server then it will affect the performance of SharePoint. Make sure to follow the best practices for server as recommended by SharePoint engineering team.
  5. Page customization: Although SharePoint Designer is a great tool for administrators but page customization can decrease the performance of SharePoint. In page customization, every time a page request occurs, entire content including inline code is retrieved. So with thousands of page request, this back and forth of database degrade SharePoint performance. So to avoid this problem, it is administrator duty to use page customization only when it is necessary.
  6. IIS compression: You can reduce the payload of HTTP response by using IIS compression. This will reduce the data size that is send to the client, resulting shorter load time.

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...