Understanding BLOB

To solve the storage problem of large files in SQL server. Some smart guys developed the BLOB concept, it stands for Binary Large Object.

From the following diagram, you can see that the large files are stored in the DB table when there is no BLOB provider applied. This definitely will decrease the database performance significantly.

Without BLOB provider


BLOB provider and RBS (Remote BLOB Storage) provider allows the SQL database to offload the large files from the tables, and only keep the pointers.

With BLOB provider


With remote BLOB provider


Note there are limitation applying to different BLOB providers.

BLOB Provider BLOB Storage Place
Filestream (comes with SQL 2008) Only the directly attached disks
RBS Filestream (free Microsoft addon) A dedicated remote BLOB SQL database. (the disk has to be direct attached to the remote host)
AveDoc (developed by AvePoint) Remote file storage








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 )

Connecting to %s