This document summarizes a presentation about offloading SharePoint data from SQL databases using remote blob storage (RBS). It discusses how SQL stores SharePoint data inefficiently, leading to database bloating and performance issues. RBS allows moving binary large objects (blobs) like documents and images to other storage like network-attached storage or the cloud. The presentation compares Microsoft's RBS and Filestream APIs to third-party RBS products, noting products provide more features like compression, encryption, tiered storage and administration interfaces. It advises choosing an RBS provider that is a Microsoft Gold Partner with proven track record and customer success stories.
1 of 21
Download to read offline
More Related Content
SharePoint Saturday Durban Presentation
1. Dude Where Did You Park
My SharePoint Data?
WARREN MARKS
DURBAN 14 SEPTEMBER 2013
4. Some of the topics well discuss
How does SQL store your SharePoint Data?
What is a blob and why is it bad news?
What is the affect of big data in SQL?
What size should my content databases be?
What is EBS?
What is RBS?
How can I offload my blobs?
How do I pick my provider?
5. How SQL stores your SharePoint data
SQL reads 8K chunks called Pages
Disk formatted into 1K chunks
Fantastic database solution - not
designed to store unstructured
content in an optimal way
6. Understanding the B-L-O-B
Binary large object (blob) - is a collection of binary data stored
as a single entity in a database management system
7. The effect of the BLOB in SQL
Bloating of SQL content databases
Increased backup windows
Increased recovery windows
Increase in fast disk storage requirements
Increased TCO for SharePoint
Performance degradation
10. Content DB limitations best practices
200GB Content DB
4TB Content DB (Disk speed requirements)
500 DBs per farm
Shredded Storage
11. The EBS API (SharePoint Layer)
Supported from SharePoint 2007 SP1 & later
Farm-wide feature (natively)
Technology being deprecated and is not
support in SharePoint 2013
External Blob Storage
12. The RBS API (SQL Layer)
Supported from SQL 2008 R2 & later
Not unique to SharePoint any SQL application
Natively implemented as a content database
scoped feature
You can build your own RBS provider library
Remote Blob Storage
14. Filestream Provider
Can only be used on Storage local to the
SQL server
Does not bypass SQL for blob offload
No compression
No de-duplication
No Encryption
No tiered storage
Not built as an enterprise class solution
16. Filestream Provider vs Product
Feature RBS FILESTREAM Product
BLOB Externalization
Offload BLOBs to remote (NAS, CAS, or Cloud) storage platforms
Outbound BLOB cache for off-premises (i.e. Cloud) operations
Define multiple storage locations per content database
Filter endpoints by file type or scope (i.e. list or content type)
Use SharePoint filename or folder on offloaded BLOBs
Promote SharePoint properties to endpoint
Securely delete (shred) BLOBs
Report and Health Monitor Dashboard
Administration User Interface
PowerShell Support
Compression
Encryption
(Transmission and "at
rest)
Tiered Storage (HSM) support
Move BLOBs to less expensive tiers of storage based on admin-defined aging rules
Move BLOBs to less expensive tiers of storage based on admin-defined retained versions rules
Move BLOBs to less expensive tiers of storage based on admin-defined metadata change rules
Orphaned BLOB Garbage Collection
(Basic )
種
17. Picking your provider
Microsoft Gold ISV Partner
Installed into a Fortune 500 Company
Track Record
Gartner Recognition
Administrator Recognition
POC!!!!
18. Top 5 Reasons for using RBS
Rapid content growth
Performance issues
Realize cost savings
Risk mitigation
Develop a more agile storage strategy