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?

Regards,
Lennard

Hi,

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:

http://technet.microsoft.com/en-us/library/ee663480.aspx#section3

Regards,

Seven

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.

Hi,

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

Kind regards

Gottfried

No solution yet?

I'm still having a larege usage database.

Any help is very much appreciated!

kind regards!

Hi,

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.