WSS_Logging DB getting to big in size

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

 

July 23rd, 2015 11:30am

There should be a space between -Identity and "Page Requests"

Keep in mind that this may clean up space in your database but it will not reclaim the space. While most people will recommend shrinking your database after cleaning it up, I recommend against it. That's because the WSS_Logging database is storing all of the operational data on your SharePoint farm on a regular basis. This means it will still require space. When you shrink the database, it will have to grow again to make room for additional data. It's better to pre-size the database according to forecasted growth and monitor accordingly to avoid filling up the disk

Free Windows Admin Tool Kit Click here and download it now
July 23rd, 2015 2:00pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics