Skip to content

SharePoint 2010 Remote Blob Storage (RBS)

by on October 8, 2010

If your database is getting unwieldy and you want to speed it up as well as slim it down, you may want to consider Remote Blob Storage (RBS). Usually 80-90% of your data is files, therefore can be moved to file (ie. cheaper) storage.

Pretty much anything over 1MB is best stored outside the database. Performance is also greatly improved for accessing large files, particularly streaming media.

There are many third-party providers which offer RBS, and charge quite a bit of money. However, there is also a native SQL RBS provider supported by SharePoint.

You can use the FILESTREAM provider that comes in the SQL Server Remote Blog  Store installation package in the Feature Pack for Microsoft SQL Server 2008 R2. It stores Binary Large Objects (BLOBS), which is what SharePoint uses to store your files – whether they are video, image, or documents -  using the NTFS file system. This allows you to store on cheaper disks (Raid 5 instead of the RAID 10 required for the whole database).

 

NOTE: You cannot access data except through SharePoint 2010 and SharePoint 2010 Products!

 

Download the Only Version of RBS supported By SharePoint Foundation 2010(older versions not supported)

 

FILESTREAM is also the only RBS provider supported for SP 2010 farm database backup and restore operations. Backup and restore, and import & export, download the file contents and upload it back to the server.

Remote RBS FILESTREAM is possible to allow storage on remote storage (DAS, NAS), however, SharePoint Foundation does not support the remote FILESTREAM provider.

One thing to be aware of is the fragmentation of files on the disk as they grow. As files become less contiguous, reads can be slowed – periodically use a disk defragmenting tool to maintain a high level of read performance on the disk itself.

Don’t bother compressing the data stored in NTFS, as the cost of CPU resources to compress and decompress the data outweighs the benefit of compression, and some data in uncompressable.

RBS and SharePoint 2010 – Microsoft Article

Advertisements
Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: