Sharepoint Site慢速单一内容DB。 [英] Sharepoint Site Slow single content DB.
问题描述
我正在经历一个网站的速度减慢，似乎无法找到问题。
我们有一个拥有多个内容db的服务器场 放慢速度的网站是内容数据库中唯一的网站。 这是一个文档中心模板。 所有其他网站都是正常的，没有问题。
网站上只有一个图书馆。 它中有大约7000个文档。
- 每个文档都拥有自己的权限。
- 我们只使用一个文档库。
- 我们没有使用文件夹。
- 我确实增加了5000项限制的阈值，以避免出现阈值错误。
- 我们确实使用版本控制而没有保留的版本数量限制。
我一直在阅读有关许多权限，大型列表和问题的问题到很多版本。 所有这些似乎都有问题。
我正在考虑的事情。
- 在里面创建文件夹文档库和移动文档。
- 为文件夹分配权限并删除/重置继承。
- 更改版本控制信息以仅保留主要版本。
现在我的问题是。 这会有用吗？ 我真的想确保我建议的更改是正确的行动方案。 我问的原因是它真的只有7000件。 我一直在阅读有关20,000件物品的文章，所以我很困惑
为什么我的微小金额会是如此重要。
那究竟什么慢？ 好吧，它似乎是......的点击。 我可以看到检索元数据需要15-30秒。 然后我再次点击...获取下拉菜单需要同样的时间。 然后我点击修改和
打开需要大约45秒。
我正在寻找建议和保证我走在正确的轨道上。
David Jenkins
大卫 - 只是一个小小的注释：由于数量的原因，无需增加阈值列表或库中的项目。 列表和库的绝对限制是3000万，你还不到5000。阈值与查询的
返回的项目数有关，而不是列表或库中的项目数。 查询实际上是您在配置列表和库视图时创建的内容。 当查询开始返回超过5000时，性能会下降。 请参阅下面的第一个参考
了解一般细节。 第二部分对列表和库阈值进行了深入的技术分析，尽管2010年的编写仍然适用于2013年和2016年。
参考文献
I'm experiencing a slow down of a site and can't seem to find the issue.
We have a farm with multiple content db's. The website that slowed down is the only site in the content db. It's a Document Center template. All other sites are normal and have no issues.
There is only one library on the site. It has about 7000 documents in it.
- Each document does have it's own permissions.
- We are only using one Document library.
- We are not using folders.
- I did increase the threshold for the 5000 item limit to avoid the threshold error.
- We do use versioning and do not have a limit in the number of versions kept.
I've been reading about issues with to many permissions, large lists and to many versions. All appear to be problematic.
Things I'm thinking of.
- Creating folders inside the document library and moving the documents.
- Assigning permissions to the folders and removing/resetting inheritance.
- Change the versioning information to only keep major revisions.
Now the questions for me is. Will this work? I really want to ensure that my suggested changes are the right course of action. The reason I ask is it really is only 7000 items. I keep reading articles about 20,000 items so I'm confused why my tiny amount would be such a big deal.
So what exactly is slow? Well it appears to be the clicking of the … . I can see it takes like 15-30 seconds to retrieve metadata. Then I click … again and it take equally as long to get the drop down menu. Then I click modify and it takes about 45 seconds to open.
I'm looking for suggestions and assurance I'm on the right track.
David Jenkins
David - just a small note: no need to increase threshold due to number of items in list or library. Absolute limit of lists and libraries is 30 million, which you're not close to yet at 5,000. Threshold has to do with the number of items returned from a query, not the number of items that are in the list or library. Queries are effectively what you create when configuring list and libraries views. When queries start returning more than about 5000, performance degrades. See the first reference below for general details. The second provides an in-depth technical analysis of list and library thresholds and even though written for 2010 is still valid for 2013 and 2016.
References
这篇关于Sharepoint Site慢速单一内容DB。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
