Currently, My Sharepoint LOG DB keeps growing. I change the configuration to only keep ULS logs for 5days and size stays under 5GB. Why does the DB keep growing.
I tried to set spusagedefinition but I keep getting errors:
ErrorMessage: (Reference:
http://blogs.msdn.com/b/manhar/archive/2012/04/17/how-to-reduce-the-size-of-logging-database-or-how-to-purge-the-old-data-from-logging-database.aspx )
PS C:\Users\SP13_Farm> get-spusagedefinition
Name Retention
Enabled
---- ---------
-------
Analytics Usage 14 True
App Monitoring 14 True
App Statistics. 14 True
Bandwidth Monitoring 14 False
Content Export Usage 14 True
Content Import Usage 14 True
Definition of usage fields for Education t... 14 True
Definition of usage fields for microblog t... 14 True
Definition of usage fields for service calls 14 True
Definition of usage fields for SPDistribut... 14 True
Definition of usage fields for workflow te... 14 True
Feature Use 14
True
File IO 14
True
Page Requests 14
True
REST and Client API Action Usage 14 True
REST and Client API Request Usage 14 True
Sandbox Request Resource Measures 14 True
Sandbox Requests 14 True
SQL Exceptions Usage 14 False
SQL IO Usage 14
False
SQL Latency Usage 14 False
Task Use 14
True
Tenant Logging 14 False
Timer Jobs 14
True
User Profile ActiveDirectory Import Usage 14 True
User Profile to SharePoint Synchronization... 14 True
PS C:\Users\SP13_Farm> Set-SPUsageDefinition -Identity"Page Requests" -DaysRetai
ned 3
Set-SPUsageDefinition : The usage definition with the given identity does not
exist.
At line:1 char:1
+ Set-SPUsageDefinition -Identity"Page Requests" -DaysRetained 3
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : ObjectNotFound: (Microsoft.Share...initionPipeBi
nd:SPUsageDefinitionPipeBind) [Set-SPUsageDefinition], PSArgumentException
+ FullyQualifiedErrorId : Microsoft.SharePoint.PowerShell.SPCmdletSetUsage
Definition
Will this help the DB from growing?
Thanks
Jose Fleitas