本文介绍了SharePoint的用户配置文件数据库不断增长的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

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)执行作业"用户配置文件服务 - 活动源清理作业"来自中央管理员。


但上面的帮助不大。


任何计划都非常感谢。


谢谢!


解决方案

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!

解决方案


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

08-19 03:03
查看更多