REDUCE GROWING DISK SPACE BY REDUCING LOGGING/USAGE DATABASE SIZE

SharePoint Usage/ logging database grows very fast and it cause the storage problem most of the time in SharePoint.By default SharePoint system retains the usage data in the database for 14 days.

To reduce/purge the size of the usage/logging database you have to execute the following script: 

By following PowerShell script the value of retention days for the usage data changes from fourteen (14) day to one (1) day.

Power Shell code to change the retention day for the SharePoint usage data 

After that we need to run the two timer jobs to clean the old data 'Microsoft SharePoint Foundation Usage Data Import' and 'Microsoft SharePoint Foundation Usage Data Processing'.

Go to Sharepoint Central Administration -> Monitoring -> Configure Usage and health data collection-> Log Collection Schedule.

And it will take you to the timer jobs.