内容数据库大小超过100Gb [英] Content database size is more than 100Gb

问题描述

大家好，

对于我的一个客户，我有一个大小超过100GB的内容数据库。

For one of my clients, I have a content database which has size more than 100GB.

它有一个网站集。我有哪些选择？

It has one site collection. What are the options do I have?

推荐答案

Hello SPAdmin，

Hello SPAdmin,

来自" Scaling SharePoint 2007：Storage Architecture" 白皮书的精彩报价：



"这通常被称为"100GB内容数据库大小限制"。事实上，这不是一个真正的限制，而是一个建议。多年来，SQL Server数据库的扩展速度已远远超过100GB。实际上，建议
主要基于两个重要因素：b


给定组织的服务水平协议（SLA）要求可能要求SharePoint数据库必须在有限的时间内可执行。内容数据库的大小将直接影响执行该备份需要多长时间
。



存储子系统必须足够强大以便处理它所服务的SharePoint解决方案的磁盘I / O要求。

A nice quote from The "Scaling SharePoint 2007: Storage Architecture" whitepaper:

"This is commonly referred to as the "100GB content database size limitation". In fact, this is not a true limitation but rather a recommendation. SQL Server databases have been scaling far beyond 100GB for years now. Practically speaking, the recommendation is based primarily on two significant factors:

Service Level Agreement (SLA) requirements for a given organization may dictate that backup operations for the SharePoint databases must be executable in a limited amount of time. The size of the content databases will have a direct impact on how long it takes to execute that backup.

The storage subsystem must be robust enough to handle the disk I/O requirements of the SharePoint solution that it serves.

只要给定的组织能够缓解这两个考虑因素，就可以允许内容数据库增长。实际的实施已经成功实现了SharePoint部署，实现了100GB，150GB，
200GB，250GB，300GB，350GB和400GB的数据库大小。"

As long as a given organization is able to mitigate these two considerations, then the content databases can be allowed to grow. Real-world implementations have seen successful SharePoint deployments that have implemented database sizes of 100GB, 150GB, 200GB, 250GB, 300GB, 350GB and 400GB."

检查版本控制和检查您是否未保留审核日志。确保你没有保留数百个文档修订版。

Check Version control and check that you aren't retaining Audit logs. Make sure you aren't retaining hundreds of revisions of docs.

此外，请确保您可以在适当的时间内备份​​数据库。确保MDF / NDF所在的卷上有足够的IOPS。

Also, make sure you can back up the database in an appropriate amount of time. Make sure you have enough IOPS on the volume where the MDF/NDF(s) reside.

这篇关于内容数据库大小超过100Gb的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！