Ginneblog

Perspectives on business and technology

SharePoint Data Storage: Beam Me Up Scotty

Burzin Patel, Solutions Architect at StorSimple, provided some great guidance for SQL Server DBAs at the San Francisco SQL Server User Group recently.  You may know Burzin from his 8+ years at Microsoft, most recently leading the SharePoint efforts on the SQLCAT team.

For SQL Server DBAs charged with supporting Microsoft’s blockbuster SharePoint platform, including MOSS 2007 and soon to be released SharePoint 2010, there’s a lot to learn.  One specific problem area with SharePoint is storage.
captain kirk 300x291 SharePoint Data Storage: Beam Me Up Scotty

Captain Kirk - a cloud pioneer

By default, when you upload a document or any other large file to SharePoint, it gets stored as a Binary Large OBject (BLOB) in the content database in SQL Server.  As revisions are made, each version of that file also gets stored (not just the differences).  The amount of BLOB data grows significantly faster than associated metadata, causing SharePoint to consume large amounts of expensive SQL Storage space.  Burzin talked about externalizing BLOB storage, as well as options for storing infrequently used BLOBs in the Cloud. These approaches can help ease the backup and storage cost problems content-heavy SharePoint sites encounter.

Burzin’s SharePoint Storage Best Practices talk also covered Configuration, Maintenance, and Performance Tuning.  He explained some of the unusual stresses SharePoint puts on SQL Server, and offered suggestions on how to avoid degraded performance.  If you’re planning a significant SharePoint implementation, you’ll want to take a close look at his specific recommendations regarding recommended I/O Capacities, Database configuration and sizing, processors and memory.

View more documents from Mark Ginnebaugh.

Given the headaches SharePoint BLOBs cause in many organizations, it makes sense that StorSimple has a complete solution to externalize them. Their storage-on-demand appliance provides tiered storage for SharePoint with the option to secure and store infrequently updated BLOBs to the cloud to achieve substantial cost savings.  According to Ursheet Parikh, StorSimple’s Founder and CEO, Burzin’s extensive SQL Server and SharePoint experience make him a key member of the StorSimple team.

I’ll write about StorSimple’s product in an upcoming post, and will follow that with a case study once DesignMind has had a chance to implement StoreSimple’s Cloud Storage Solution for one of our clients.  For data storage, Space is the Final Frontier.

Popularity: unranked [?]

Sphere: Related Content

1 comment

1 Comment so far

  1. matt February 7th, 2010 6:23 am

    nice post, meeting have been great, need to check out more content and get interactive :)

    THANKS ::::))))

Leave a reply