By Iqbal Khan
SharePoint has become an extremely popular portal platform. It provides a great number of applications for collaborating among different company groups or even between different companies. Process management, document management and other major applications are all part of SharePoint’s array of features.
But SharePoint’s popularity has its downside as well. As more people use it, there can be major performance and scalability bottlenecks because SharePoint makes a heavy use of SQL Server database for everything. This could include structured data or documents coming from Microsoft Word, Excel, PowerPoint and Adobe Acrobat. All these documents are coming from the database.
There are two potential issues associated with SharePoint 2010. One: Databases can grow exceptionally large because of all the binary large object (BLOB) data. Two: Reading and writing BLOBs, as well as other relational data, can slow down SQL Server performance because it’s not the ideal place for storing BLOBs.Read full Article