Optimizing storage to meet the needs of scalability for productivity and cost control is important for any business, and users of Microsoft SharePoint are no exception. SharePoint automatically stores data in SQL Server content databases. As a relational database, SQL is efficient at storing structured data, but less so when dealing with larger, non-relational data streams. Unfortunately, this can often account for up to 95 percent of all data in a typical organization.
SharePoint users have several options to keep the cost of storage in check. One would be to leverage aggressive content life-cycle management policies to address or delete SharePoint content that has not been accessed or modified in a specified time frame. Another would be to set strict site quotas and locks that prevent users from uploading significant amounts of data in particular lists.
This interesting information was found in Computer World UK’s blog post titled, “Save money with smart content storage in SharePoint.”
Melody K. Smith
Sponsored by Access Innovations, the world leader in thesaurus, ontology, and taxonomy creation and metadata application.