Database Storage Configuration

Use "Home > Database Storage" to navigate to the database storage configuration page.

This pane is used to configure the storage duration of the main CDRv5 tables: CDR, CPM and Summary tables. The default values are:

- CDR=90 (days)

- CPM=1 (day)

- Summary=12 months

The CDR table is useful for generating many type of reports including reports that require originating numbers.

The Summary table aggregates the details using the dialed number and the terminating number as keys. The originating number details are lost. The summary table provides faster performance and requires less disk space. Hence, the record retention period can be much longer.

The CPM table keeps call progress messages and is useful for querying detailed events of calls. Most of the information is captured in the final CDR. Hence the retention requirement is generally short.

When you select a storage duration, you should consider your practical needs and factors such as:

• Your MS-SQL product. If you use MS-SQL 2014 Express, you are limited to a storage of 10Gbytes. This should support more than 10 million calls.
• Computer storage capacity. The longer the archive period, the more space it will require. The CDR/CPM is approximately 240 bytes each record. Each call is comprised of one CDR and 2 or more CPMs. Relational Database Management System also needs overhead storage. You should monitor the disk space usage of your database files. By default, these CDRv5 Database file are located under the sub-folder "..\CDRv5DatabaseFiles". The filenames are "CDRV5Database.ldf" and "CDRV5Database.ldf".
• Storage hardware. You may consider to store the CDRv5 Database files in fast and fail-safe drives (RAID Arrays for example).
• Query response time and record insert rate. The longer the duration, the slower the query response time. You need to make a choice between your query duration requirements and your response time requirements.
• Sharing vs. not sharing CDRv5 Database. The CDRv5 architecture allows for as many instances of the CDRv5 Database as your performance requirement demands. If you share the CDRv5 Database, you need to consider every users requirements for storage duration.

Database Maintenance (Cleanup)
Database maintenance occurs automatically once daily and optionally when the CDRv5 Client application is launched. You can select this option by selecting "Run on application start" . The database maintenance is implemented as a stored procedure (i.e.; a program inside the MS-SQL Database). This function may use your computer resource and slow it down. It performs many functions such as removing old records and updating tables that are dependent on the contents of the CDR table. Click "Start Now" to manually launch the database maintenance stored procedure.

Summary Table Update

The CDRv5 Application has the logic to summarize incoming CDRs and CPMs and update the summary table on a frequent basis. The default update frequency is 2 minutes. This parameter is configurable.
You can also force an update by clicking "Update Now".