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

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

SQL ART/CDR tables too large

I reviewed our SQL tables and found CDR (we enabled CDR and diagnostic CDR and ART) had 1.2 million rows using a lot of disk space. Art was almost as big. We wanted to delete everything older than Jan 2002 (we export is to Infotel for billing on a daily basis).

Not sure if this was best done via SQL commands, or if Cisco had any tools.

Our last upgrade took forever due to a large CDR database. How can we best regulary minimize these tables ?


Re: SQL ART/CDR tables too large

You could either set up a DTS Package on the CallManager publisher to delete records older than a certain date, or you could use ARTs Database Purge feature. By default, I believe that ART is configured to purge the database of all ART records older than 180 days (approx 6 months) and CDR records older than 60 days, but it is disabled unless changed by a user.

You can perform a manual or automatic purge. Look up the "Database Purge" topic in the ART help files, and it will show you how to configure ART to purge old CDR and ART records when ART retrieves it's data. Or, in ART on the System menu, go to Database and choose Database Purge, and that will bring up the Purge options screen.

Hope that is of some help!

CreatePlease to create content