As Microsoft SharePoint becomes the central repository for enterprise content within organizations, increasing user adoption and integration from data sources can cause unstructured data, called Binary Large Objects (BLOBs), to consume up to 95 percent of SharePoint SQL Server space. If ignored, BLOBs can lead to database performance and user experience degradation.
With DocAve Storage Manager, organizations can mitigate the negative consequences of exponential data growth by combining multiple real-time and scheduled business-rules to externalize BLOB content based on file size, type, or other document properties, allowing SharePoint administrators to:
As an integrated product part of the DocAve Software Platform, the NEW DocAve Storage Manager provides a seamless solution to implement, enforce, and manage information lifecycle governance policies, ensuring all SharePoint content is fully protected and managed regardless of where it resides.
Databases like SQL Server are designed to handle relational data of relatively small size (smaller than most Office documents!). However, for larger data, known as Binary Large Objects (BLOBs), databases like SQL are not optimal.
Since more than 95 percent 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.
SQL Server licensing is relatively expensive when compared to file-based storage. Another more cost-efficient option is to extend this BLOB content directly to file-based storage, while providing limitless user access to the BLOB content via SharePoint. To do this, administrators can either:
With DocAve Storage Manager, BLOBs are never stored on the SQL Server database, meaning SharePoint 2013 and 2010 can perform optimally, your SQL Server resources can be utilized efficiently, and your database costs can be kept to an absolute minimum.
Free up SQL Storage space, and save on SQL Server licensing costs, by leveraging existing storage investments and seamlessly externalizing BLOB content from SQL Server to less expensive or hierarchical storage systems.
Remove unstructured data from SQL Server instantly or on a scheduled basis for enriched performance and shortened response times while providing end-users with seamless access and interaction of SharePoint content, no matter where it resides.
Because DocAve leverages Microsoft's fully supported EBS and RBS APIs, users maintain seamless access to – and interaction with – externalized content, which works with SharePoint management functions including alerts, workflows, versioning, Microsoft Office applications, and most third-party applications.
Since DocAve is a fully integrated platform, DocAve's powerful management and protection solutions help ensure all SharePoint assets – including externalized content – are fully protected and managed no matter where they reside.
All content offloaded to logical devices by DocAve Storage manager can be managed using all of SharePoint's management and collaboration tools as if it were residing directly in SharePoint's SQL databases.
Leverage multiple rules for real time externalization based on file size, and combine with scheduled externalization based on any document property including created or modified time and / or size, for truly comprehensive hierarchical storage management.
Externalize BLOBs to any network addressable file-based storage system. Overlay externalization rules to leverage HSM systems for SharePoint content storage to optimize storage resources and costs.
All data residing in file-based storage is fully integrated with SharePoint's native, full text search functionality, as well as all other search tools that leverage the standard SharePoint API.
Store BLOB content on leading hardware and cloud storage systems to leverage advanced features such as de-duplication, self-healing, and enhanced disaster recovery. Supported storage platforms and providers include EMC Centera, Dell DX Object Storage, NetApp, Windows Azure, Rackspace Cloud Files, and Amazon Web Services.
Not fully migrated to SharePoint 2013 or 2010 yet?
Find out how DocAve helped Prairie South School Division administrators save time managing SharePoint and address challenges in the areas of end-user adoption, maintenance, governance, and platform scalability.
This document is intended to provide a comprehensive and balanced examination of SharePoint storage concepts and issues, and to equip you to fully understand, communicate and make informed decisions about the role of BLOB externalization in your storage architecture
Still on a prior release of SharePoint?
AVEPOINT IS A GLOBAL TECHNOLOGY COMPANY AND PROVEN SOFTWARE LEADER. SINCE ITS FOUNDING IN 2001, AVEPOINT HAS BECOME THE WORLD'S LARGEST PROVIDER OF ENTERPRISE-CLASS GOVERNANCE, COMPLIANCE, AND MANAGEMENT SOLUTIONS FOR SOCIAL ENTERPRISE COLLABORATION PLATFORMS, HELPING MORE THAN 10,000 CUSTOMERS. AVEPOINT, INC. IS HEADQUARTERED IN JERSEY CITY, NJ, WITH WHOLLY OWNED OPERATIONAL CENTERS ON FIVE CONTINENTS WORLDWIDE.