How to reduce size of UsageAndHealth database?

Question

I have a database UsageAndHealth which is growing fast, I have changed the retention to 3 but how can I purge the data that is already in the database? Can I delete as is or what is the best approach to do it?

I tried to change the max storage for the db but it is not possible until I reduce the size of it.

Lachezar Stefanov · Answer 1 · 2018-07-18T06:58:32.677

0

did you try to find out the primary source of this extensive growth? (ex., by selecting your logging Database in SSMS -> (Right Click) -> Reports- > Standard Reports -> Disk Usage by Top Tables.)?

edited Jul 18 '18 at 06:58

answered Jul 16 '18 at 21:40

Lachezar Stefanov

181
2
16

I see in the top dbo.TaskUsage_Partition6 that should be unchecked in the monitoring services? – Carlos M Jul 16 '18 at 22:03
I wounder if you could provide a screenshot...? – Lachezar Stefanov Jul 18 '18 at 06:59
Sorry but I can't, I reduce the retention period and ran the timer job manually, it has reduced the size. – Carlos M Jul 18 '18 at 17:35
hello Carlos, I didn't mean reducing the retention period, just finding out the source of the extensive growth. – Lachezar Stefanov Jul 20 '18 at 08:00

score 0 · Accepted Answer · answered Jul 17 '18 at 09:04

After change the retention period, run the “Microsoft SharePoint Foundation Usage Data Import” timer job and “Microsoft SharePoint Foundation Usage Data Processing” timer job manually via Central Administration -> Monitoring -> Configure Usage and health data collection-> Log Collection Schedule.

Then the only 3 days log is retained and database has released the space.

Check the blog for more information: How to reduce the size of logging database OR How to purge the old data from Logging Database

How to reduce size of UsageAndHealth database?

2 Answers2