The Promises and Realities of SharePoint Database Management
May 28, 2012
Robert Schifreen has over 30 years of experience in reporting and implementing online technology with his latest projects focused on SharePoint installation. The positives and negatives of his experience are relayed in his post, “Attack of the BLOBs: Data Behaving Badly.” In this sixth installment of his SharePoint 2010 series, Schifreen analyzes the nuances of SharePoint databases.
Databases are the most important core of any farm as they store valuable content like user data, sites, documents, libraries, lists, calendars, wikis, and more. Schifreen explains some challenges with databases in SharePoint 2010:
You can have as many SQL databases as you like, but Microsoft recommends that you don’t allow any one database to grow larger than 200GB, after which performance apparently starts to degrade. It’s also best not to have individual drive volumes that run into tens of terabytes, because they’re a pain to back up. Microsoft has a solution to the problem of storing large data objects (BLOBs) in SQL databases, which is something called RBS or Remote Blob Storage. Each blob gets stored as a standard file on the file system and its entry in the database is replaced with a pointer to the external file.
He goes on to explain the complex nature of SharePoint architecture and RBS middleware. While a SharePoint deployment can get complicated quickly, it is important to analyze your environment and keep it simple until you need to add more complex features. Schifreen’s article is a good example of that process and may be worth the read. But we also know that a powerful search feature is necessary to navigate and get the most out of your SharePoint investments.
To fill in the search gaps in your SharePoint system, consider a third party application. We like the good reviews for the Fabasoft Mindbreeze suite of solutions. With clear navigation and a self-explanatory interface, Fabasoft Mindbreeze Enterprise facilitates findability.
Fabasoft Mindbreeze Enterprise finds every scrap of information within a very short time, whether document, contract, note, e-mail or calendar entry, in intranet or internet, person- or text-related. The software solution finds all required information, regardless of source, for its users. Get a comprehensive overview of corporate knowledge in seconds without redundancy or loss of data.
While databases can become convoluted, Mindbreeze can save employees time by connecting them to the right information via a user-friendly interface even with vast amounts of unstructured data. Navigate to http://www.mindbreeze.com/ to read more.
Philip West, May 28, 2012
Sponsored by Pandia.com
Comments
One Response to “The Promises and Realities of SharePoint Database Management”
-
- Subscribe to Beyond Search
Feature archive
News archive
-
I enjoyed reading Robert’s account of his Sharepoint journey thus far. Regarding his deployment of RBS, it seems Schifreen made a wise choice, at least for now.