Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have a MOSS publishing site. Content is quite small. I noticed that content database size is now 5GB without any significant content changes made. Using a script to show the tables' sizes, I noticed that the EventCache table size alone is over 3.5 GB. Why is this? what is the reason for this? What to do about it to reduce the size?

share|improve this question
add comment

2 Answers

up vote 2 down vote accepted

did you checked the following things: 1. Did you migrated your content DB from a previous version (SPS 2003)? - In this case, it might be sometimes the timerjobs to clear the eventcache table on its expiries date does not perform well and rows older than the defined number of days still remaining in the table.

  1. In MOSS Sp2 we fixed some parts which also causes an unexpected growth of databases but not sure if this applies also to the eventcache table in certain.

  2. In one case I had, the free diskspace on SQL Server did not have enough space to perform the creation of the temp DB which is built during the proceeding of eventcache ta ble to delete expired rows. We could figure out in that case with an 75GB DB where eventcache allone tooks 8GB that we had free up space of about 260GB to clear the table.

  3. Another hint may find here as well: KB Article: 957691 - Build 12.0000.6331.5000) "Supported method to clear the EventCache table"

Hope this may help you,

greets, Steve Chen, Support Engineer SharePoint EMEA GTSC

share|improve this answer
1  
Welcome aboard Steve! Very pleased to see MSFT people monitoring Sharepointoverflow :-) –  Anders Rask Dec 17 '09 at 10:00
add comment

Try changing how many days to keep your change log and see if that table gets smaller.

Also, is your SPTimer service running correctly with the correct domain account?

Do you have a lot of users with a lot of alerts setup?

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.