Alachisoft StorageEdge - Online Documentation

Remote BLOB Storage (RBS)

 
By default, SQL Server stores BLOB data in its databases. With the increase of database consumption, the total size of BLOB data stored in database also increases rapidly and grows larger than the total size of the file metadata and other structured data. The reason behind the increase in size is that BLOB uses a lot of file space and server resources which are optimized for database. It is suggested to move BLOB data from SQL Server database into a file system.
 
StorageEdge gives you the implementation of RBS with SharePoint and provides caching solution for faster storage and retrieval of BLOBs. Whenever a user wants to read a document from SharePoint, RBS will first look for a BLOB in a cache and if its not found in a cache then it will fetch it from target storage i.e. File System and place it in the cache for future references. Once RBS has been enabled for SharePoint, you may need to perform management tasks such as migrating content from the SharePoint database to RBS and reverting BLOBs from RBS to the SharePoint database at later time.
 
When you plug in the RBS, it becomes the main data source for SharePoint. RBS is a new way of externalizing the BLOB content to a external storage and a recommended way by Microsoft. 80% data of SharePoint consists of data streams that are in BLOB form and it does not take much advantage of SQL Server for unstructured data streams. It is because SQL Server is not optimized for handling BLOB read requests efficiently and it can not query the BLOBs very well either. The operations to read or query data from SQL Server impair data streaming performance dramatically.
 
RBS on the other hand is better alternative for storing BLOBs. It lets you store and retrieve BLOBs with lesser cost. RBS is more efficient in storing large BLOBs and it can query them faster and more efficiently.
 
Note: RBS on a local server requires: Microsoft SQL Server 2008 R2, SQL Server 2008 or SQL Server 2008 R2 Express.
RBS on a remote server requires: SQL Server 2008 R2 Enterprise edition. Microsoft SQL Server 2005 does not support RBS.
 
 
In this Section
Explains how to configure BLOB Store database.
Explains how to enable RBS for a Content Database.
Explains how to add a Storage Tier.
Explains how to disable RBS for a Content Database.
 
 
Copyright © 2012 Alachisoft. All rights reserved.