What are the issues that may affect performance of CDR processing and CallManager?
• Partner’s software and databases should never reside upon the MCS platform and should be place upon a separate physical system. • Do not use database triggers on CCM tables. • If a partner does not want Call Detail Records (CDRs) written to CCM, a Data Source Name (DSN) entry on CCM can be changed so that CDRs are written to the separate server. If a large memory cache is made available on the separate server, these actions should improve CCM performance. • If a partner wants CDRs written to CCM, a low priority thread can be activated to offload [100] CDRs at a time from CCM to the separate server during low volume periods. • If bulk pulling of CDRs from the database, a rule of thumb is to pull no more than 10K records at a time. Optimally, we would prefer that CDR records be pulled off and put on another system where complex queries would not impact callmanager performance. However, if this is not possible, queries should be small enough not to impact system performance. Queries sho
