We've got about 600 agents running CSA 5.0.0.187, using a distributed SQL setup (Have a SQL DB on another server).
Our Database size has steadily grown to the point where we have only about 600 MB left out of 4 GB. We've set up pruning rules to delete out old events after 1 week. We've tried working with Cisco TAC, who didn't really provide any answers.
The real mind boggling issue is that our utilization stats for Event and config data show us using about 2 GB, and our application deployment size is less than half a GB, so according to that, we're only using 2.5 GB out of 4 GB, not over 3.
We're trying to work with our DBA group to see if they can find anything odd about the database. Any thoughts for things we can try?