How to clear WSS_UsageApplication content?

Hi there,

I have a large WSS_UsageApplication database which is about 20gb.

We don't use this data so we have already stopped the  'usage data collection' application to stop the db growing.

Off course that seems to work, but for now we still have the collected data which isn't used anymore. What is the best way to get rid of this data?


May 17th, 2011 1:25pm


You can enable the 'usage data collection' application again and set the number of days of audit log data to retain from each site collection > top site > site settings > site collection administration > site collection audit settings > audit log trimming section. and wait to timer job running next time.

You can also check this:



Free Windows Admin Tool Kit Click here and download it now
May 19th, 2011 11:35am

While it seems logic to be the solution i tried it and for now it doesn't shrink the database.

in the 2 most used web applications (wiith a single site collection) enabled the audit log trimming.

in central administration enabled usage data collection.

then started the timer jobs 'Change Log' and 'Audit log trimming' for these web apps.


The RequestUsage view returns still about 16M rows.

the ULSTraceLog view returns about 700K rows. 

it seems that content stil exists after running the jobs.


May 23rd, 2011 11:58am


i tried the same steps and the DB remained huge. Is there another way to reduce the size of the Usage DB?


Kind regards


Free Windows Admin Tool Kit Click here and download it now
November 3rd, 2011 10:41am

No solution yet?

I'm still having a larege usage database.

Any help is very much appreciated!


kind regards!

November 25th, 2011 4:44pm


I have the same issue here.

The database is about 12 Gb and a shrink db on an SQL level didnt help.

Thanks for your help.

Free Windows Admin Tool Kit Click here and download it now
July 4th, 2012 4:18pm

This worked for me in SP2013:
January 17th, 2014 7:43pm

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

Other recent topics Other recent topics