The publisher and all subscribers have the Max Records field set to 1500000 records and yet the CallDetailRecord table is currently holding 9670938 rows. The oldest entry is not being purged at night either.
The Maintenance Time is set to 24 and Maintenance Window is set to 2. This is the same settings we have for all our customers. All other customers have just a bit over 1500000 rows, and the old entries get purged nightly.
The only difference with this particular customer / CCM publisher is that we had to make the CDR database a publication at the customers request. The data from the CallDetailRecord table is pushed to an external SQL server on a regular basis.
Could this push have something to do with the ability of the DBL service to cycle out the old records nightly? I dont see any error messages in the event viewer application log at midnight when the maintenance window is scheduled nor at 1:00 am.
If we are using Max CDR Records as high disk space usage will increase a lot. You should really monitor the available disk space to make sure it does not get low. Things like remote StiBack operations during the night could also chew up unexpected amounts of disk space, so make sure you monitor over a period of time, not just during the day. If available disk space gets too low, you will definitely have problems (like DCD halting). Very large database tables can cause problems causing SQL transactions to hang. Specifically one case being if you use ART to perform automatic purges.
SIP traces provide key information in troubleshooting SIP Trunks, SIP
endpoints and other SIP related issues. Even though these traces are in
clear text, these texts can be gibberish unless you understand fully
what they mean. This document attempts to br...
Please find the attached HTML document, download and open it on your PC.
This provides an easy to use form where you simply answer a few
questions and it will render the proper jabber-config.xml file for you
to copy/paste. There is built in logic to verif...
CUCM Database Replication is an area in which Cisco customers and
partners have asked for more in-depth training in being able to properly
assess a replication problem and potentially resolve an issue without
involving TAC. This document discusses the bas...