Microsoft SharePoint team sharing about two related changes to the data storage in SharePoint.
"First, by taking advantage of performance and reliability improvements in SP1 and by defining specific requirements for large data storage in SharePoint, Microsoft is able to increase the supported limits for data storage from 200GB to 4TB in SharePoint, when certain requirements are followed. In addition, SharePoint 2010 now supports an unlimited content database size for document archive scenarios when best practices and some restrictions are followed, helping remove storage barriers for some customers."
"Additionally, the SQL Server FILESTREAM RBS provider is now supported for use with SharePoint so that lower cost iSCSI connected NAS disk can be used," revealed a tem member.
Software boundaries and limits and the primary changes are:
- For a SharePoint content database up to 200 GB there're no special requirements and this limit is included for consistency.
- For a SharePoint content database up to 4 TB you need to additionally plan for the following two requirements:
- Requires disk sub-system performance of 0.25 IOPS per GB, 2 IOPS per GB is recommended for optimal performance.
- Requires the customer to have plans for high availability, disaster recovery, future capacity, and performance testing.
- And you need to review additional considerations in the TechNet Boundaries and Limits article.
- SharePoint sites must be based on Document Center or Records Center site templates and must be an archive scenario where less than 5% of content is actively read from each month and less than 1% of content is actively written to.
- Do not use alerts, workflows, link fix-ups, or item level security on any SharePoint objects in the content database. Note: document archive content databases can be the recipient of documents as a result of Content Routing workflow.
- A new limit of 60million items in any one SharePoint content database
- The specific 5 TB limit per SQL Server instance has been removed. Instead you should work with a SQL Server professional to plan for database storage.
For full more information, refer to this TechNet Article: "SharePoint Server 2010 capacity management: Software boundaries and limits document."
Also, a guide on SharePoint 2010 scalability is publihsed and is available here.
[Source: SharePoint Team Blog]