Well I believe there are lot of problems that contribute to performance bottlenecks in SharePoint however it is a very useful extremely popular product that improves effectiveness of organizations through content management and enterprise search, shared business processes, and information-sharing across boundaries for better business insight.
The SharePoint performance problems occur primarily due to the following reasons:
- BLOBs overwhelm SQL Server
- Too many database trips for lists
You can dramatically improve SharePoint performance if you use a few of intelligent techniques which are:
- Externalize Documents (BLOBs)
- Cache Lists and BLOBs
StorageEdge provides precisely such a blob caching facility. It offers a unique combination of externalization and BLOB caching for effective blob management and access from a single interface. It makes use of NCache® technology to let you cache frequently used BLOBs in a distributed fashion with high availability, complete replication and failover. A distributed cache can give your SharePoint infrastructure a significant scalability boost because it keeps things distributed across multiple servers and still giving one logical view. But the cache actually lives on multiple servers and that’s what allows the cache to really scale.