CSA 5.0 - SQL DB space problem

Unanswered Question
Jun 4th, 2007

We've got about 600 agents running CSA, 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?

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
codycornell Tue, 06/05/2007 - 08:08

Check out the transaction log for the database [csamc51_log.LDF]. It possible you need to do a backup or shrink.


This Discussion