Advertisements

AvePoint Releases FREE BLOB Management Tool for SharePoint 2007 and 2010


AvePoint - SharePoint Backup and Administration Software

A few weeks back, I had written a quick post about BLOB (Binary Large OBject) storage in SharePoint. Well, one of our partners, AvePoint, released yet another of their tools for FREE, the DocAve Extender, for SharePoint 2007 and 2010, to aid in this matter.

Straight from their website – here is some more information on the groundbreaking release of this tool, for free.

“Databases like SQL Server are designed to handle relational data of relatively small size (typically less than 1MB). However, when it comes to larger, non-relational data streams, known as Binary Large Objects (or BLOBs), databases like SQL are not optimal. This is because managing BLOB I/O calls takes up substantial SQL CPU and memory resources.

Since more than 95% of the data a typical organization uploads into SharePoint are BLOBS, SharePoint’s SQL resources become quite overburdened, and have less capacity to perform transactional data operations and queries.

To avoid this, organizations have a few options. The first option is to spend money on additional SQL Server resources. But SQL Server licensing is relatively expensive when compared to file-based storage, so this is not the most cost-effective route.

The second, more cost-efficient option is to extend this BLOB content directly to file-based storage, while providing unfettered user access to the BLOB content via SharePoint.  To do this, administrators can either:

  • Write custom code that leverages Microsoft’s APIs to create their own BLOB management functionality
  • Buy some expensive third party tool
  • Use AvePoint’s FREE DocAve Extender.

With DocAve Extender, BLOBs are never stored on the SQL Server database, meaning SharePoint can perform optimally, your SQL Server resources can be utilized efficiently, and your database costs can be kept to an absolute minimum.”

The utility allows you to literally have terabytes of data within a single content database. It can be encrypted and compressed as well for secure and trimmed storage, and stored on file servers, NAS, SAN, or even Cloud storage mediums.

So if you are looking to offload large file storage in SharePoint from your SQL server – look no further. http://www.avepoint.com/sharepoint-storage-extender-docave/.

 

Advertisements

About Geoff Varosky
Geoff Varosky is a Senior Architect for BlueMetal Architects, based out of Watertown, MA. He has been architecting and developing web based applications his entire career, and has been working with SharePoint for the past 13 years. Geoff is an active member of the SharePoint community, Co-Founder and Co-Organizer of the Boston Area SharePoint Users Group, co-founder for the Boston Office 365 Users Group, co-organizer for SharePoint Saturday Boston and speaks regularly at SharePoint events and user groups.

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: