際際滷

際際滷Share a Scribd company logo
Dude Where Did You Park
My SharePoint Data?
WARREN MARKS
DURBAN  14 SEPTEMBER 2013
Our Awesome Sponsor
About me
Warren Marks
Johannesburg
Director
GTconsult
Over 13 years in information management
First time SPS Speaker
On occasion I like standing on my head
@MarksWazza
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?
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
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
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
Performance Degradation Uncovered
How things get put back together
Content DB limitations best practices
200GB Content DB
4TB Content DB (Disk speed requirements)
500 DBs per farm
Shredded Storage
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
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
Native Vs Product
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
Product
NAS
PPT PDF
DOC
DOC
DOC
DOC
TIFF
XLS
NAS
Azure Azure
JBOD
PDFDOC XLS
PDF
TIFF
AVI
DOCPPTXLSTIFFPDF
+1 year
+2 years
Azure
DOCDOC
+5 years
Less relevant content becomes less-expensive to store
Blob Offloader
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 )
種
Picking your provider
 Microsoft Gold ISV Partner
 Installed into a Fortune 500 Company
 Track Record
 Gartner Recognition
 Administrator Recognition
 POC!!!!
Top 5 Reasons for using RBS
 Rapid content growth
 Performance issues
 Realize cost savings
 Risk mitigation
 Develop a more agile storage strategy
Final Goal
Q & A
Takeaways
 Contact me
@MarksWazza warren@gtconsult.co.za

More Related Content

SharePoint Saturday Durban Presentation

  • 1. Dude Where Did You Park My SharePoint Data? WARREN MARKS DURBAN 14 SEPTEMBER 2013
  • 3. About me Warren Marks Johannesburg Director GTconsult Over 13 years in information management First time SPS Speaker On occasion I like standing on my head @MarksWazza
  • 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
  • 9. How things get put back together
  • 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
  • 15. Product NAS PPT PDF DOC DOC DOC DOC TIFF XLS NAS Azure Azure JBOD PDFDOC XLS PDF TIFF AVI DOCPPTXLSTIFFPDF +1 year +2 years Azure DOCDOC +5 years Less relevant content becomes less-expensive to store Blob Offloader
  • 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
  • 20. Q & A
  • 21. Takeaways Contact me @MarksWazza warren@gtconsult.co.za