Reduce the size of logging database

To reduce the size of the logging database or to purge the old data from the logging database we can these steps:

By Default the system retains 14 days of Usage data in this database. You need to decrease value of the retention days by the following PowerShell Command:

Set-SPUsageDefinition –Identity "Event Selection" -DaysRetained days

Example:

Set-SPUsageDefinition –Identity “Page Requests" -DaysRetained 3

You can get values of retention days by the following command

Get-spusagedefinition

After that we need to run the two timer jobs to clean the old data, Go to Job Definitions and Run the following Jobs:

• Microsoft SharePoint Foundation Usage Data Import
• Microsoft SharePoint Foundation Usage Data Processing

Once the timer jobs is run you can check and confirm database has released the space.