Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

CSA 5.0 - SQL DB space problem

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
New Member

Re: CSA 5.0 - SQL DB space problem

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

101
Views
0
Helpful
1
Replies
CreatePlease to create content