2013-10-24

With fast user adoption is positive for any business organization leveraging SharePoint for content management and version control. As user adoption increases, it leads to more amount of data that must be stored in SharePoint. This results in “Content overload” which can wreak havoc on SharePoint infrastructure, and can become a leading cause of poor performance and finally not to mention the corresponding management headaches.

Following are the top 5 performance killers:

  1. Most SharePoint content is saved in SQL Server as unstructured data, otherwise known as BLOBs (Binary Large Objects). It takes extra processing power and time to read data from these files, and yet, they contribute to nearly 95 percent of storage overhead in SharePoint content databases. Simply put, unstructured data is taking over SQL server space.
  2. SharePoint is not optimized to house large media files such as videos, images and PowerPoint presentations. As more of this content is stored in SharePoint, it amplifies the likelihood that users will experience browser timeout, slow Web server performance and upload and recall failures.
  3. It’s not uncommon for the majority of SharePoint content to go completely unused for long periods of time. Many organizations waste space by applying the same storage treatment for old, unused data as they do for new, active content.
  4. As SharePoint content grows, its supporting hardware can become under powered if growth rates were not accurately forecasted from the start. Organizations unable to invest in new hardware need to find alternatives that enable them to adhere to best practices and keep SharePoint performance optimal.
  5. Many organizations have not yet explored Microsoft’s recommended externalization capabilities, Remote BLOB Storage (RBS) and External BLOB Storage (EBS), and, therefore, are missing out on significant storage and related performance benefits. By taking advantage of Microsoft’s data externalization features, SharePoint administrators are able to move large, old and unused data from a SQL server content database to secondary, less expensive repositories, all while keeping the data accessible to end users via SharePoint.

About the author 

Vikram Samal