cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
262
Views
0
Helpful
1
Replies

CSA 5.0 - SQL DB space problem

joseph.hamilton
Level 1
Level 1

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?

1 Reply 1

codycornell
Level 1
Level 1

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