SharePoint的用户配置文件数据库不断增长 [英] SharePoint's User Profile database growing continuously

问题描述

b


最近我们观察到User Profile的profile_db的巨大增长。

发现"dbo.ActivityEventsConsolidated" ; table正在利用数据库中的大部分空间。



我遵循以下步骤：

1）使用SharePoint Management Shell获取SharePoint用户配置文件服务应用程序并将DaysWorthOfActivityFeedsToKeep设置为零¥b
$ b $ ups = Get-SPServiceApplication -name"User Profile Services"

$ ups.DaysWorthOfActivityFeedsToKeep = 0

$ ups.Update（）



2）执行作业"用户配置文件服务 - 活动源清理作业"来自中央管理员。

但上面的帮助不大。

任何计划都非常感谢。

谢谢！

解决方案

您好

以下链接是相关文章，希望它可以提供帮助。

https://blogs.technet.microsoft.com/praveenh/2011/12/13/user-profile-synchronization-数据库成长外的控制/

Hi,

Recently we are observing tremendous growth in User Profile's profile_db.
Found that "dbo.ActivityEventsConsolidated" table is utilizing most of the space in database.

I have followed below steps:
1) Use SharePoint Management Shell to get the SharePoint User Profile Service Application and set DaysWorthOfActivityFeedsToKeep to zero

$ups = Get-SPServiceApplication -name "User Profile Services"
$ups.DaysWorthOfActivityFeedsToKeep = 0
$ups.Update()

2) Ran job "User Profile Services - Activity Feed Cleanup Job" from Central Admin.

But above was of not of much help.

Any plans much appreciated.

Thanks!

解决方案

Hi

Below link is a related article, hope it can help.

https://blogs.technet.microsoft.com/praveenh/2011/12/13/user-profile-synchronization-database-growing-out-of-control/

这篇关于SharePoint的用户配置文件数据库不断增长的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！