Configuring Retention of QoE and CDR Data
By default, both Quality of Experience (QoE) data and Call Detail Recording (CDR) data is purged after 60 days. If you wish to retain either type of data for a longer or shorter period, use the following procedure. You can also change the default time of day that each database is purged.
Configuring Monitoring Servers Connected to a Single Monitoring Database
If you deployed an Enterprise pool in which multiple Monitoring Servers are installed on separate computers and are connected to a single Monitoring database, it is important to configure the purge start time on each Monitoring Server so that the purges do not occur simultaneously. If multiple Monitoring services attempt to purge at the same time, a database lock might occur. The database lock might resolve without intervention, but the event appears in the Event Viewer.
You can configure the purges in either of the following ways:
Set one Monitoring Server to purge and the others to not purge.
If you choose this method to control purging, you need to reconfigure the servers to continue purging in a failover situation.
Set the purge times sufficiently far apart so that the purges do not overlap.
For either of these methods, set Windows Management Instrumentation (WMI) settings as described in this topic. For details about changing WMI settings, see your Windows Server documentation.
If you choose to configure only one Monitoring Server to purge, use WMI settings to set the number of retention days, as follows:
- For QoE data, set MSFT_SIPQoESetting.CallRecordRetentionDays on the computers where you want to suppress purging to a very high number between 0 and 2147483647. Set this WMI setting to a lower number for the Monitoring Server that you want to purge data. Set this WMI setting to zero (0) to purge everything.
- For CDR data, set MSFT_SIPCDRServiceSetting.DaysToKeepCDR on the computers where you want to suppress purging to zero (0). Set this WMI setting to a number from 1 to 2562 for the Monitoring Server that you want to purge.
If you choose to control purging by setting the purge start time, use the procedure below and ensure that the purges occur far enough apart that they do not overlap. Use the following examples to extrapolate the time you need for purges in your organization. These examples assume 100,000 users per pool and eight working hours per day.
- For QoE data, a growth rate of 200M bytes per hour takes 16 minutes to purge a single day's data.
- For CDR data, a growth rate of 105M bytes per hour takes 2 minutes to purge a single day's data.
It is recommended that you set the purge times at least an hour apart.
Configuring Purge Settings for QoE and CDR Data
Use the following procedures to configure purge settings for QoE and CDR data.
Do not use the following procedure to disable purging for QoE data. Instead, use the WMI settings described previously in this topic.
To specify retention of QoE and CDR data
Log in as a member of the RTCUniversalServerAdmins group, and open the Office Communications Server 2007 R2 snap-in: Click Start, point to Administrative Tools, and then click Office Communications Server 2007 R2.
In the console tree, expand Monitoring Servers.
Right-click the Monitoring Server that you want to configure, and then click Properties.
In the Call detail recording (CDR) box, do one of the following:
To turn on purging, select Maximum days logged and type the number of days to retain CDR data.
Valid values are zero (0) to 2562. A value of zero (0) suppresses purging.
To turn off purging, clear Maximum days logged.
In the Quality of Experience (QoE) box, do one of the following:
To disable purging for QoE data, use the WMI settings described previously in this topic.
To retain QoE data for a period of time, select Maximum days logged, and type the number of days to retain QoE data.
Valid values are zero (0) to 2147483647. A value of zero (0) purges everything.
To purge all QoE data, clear Maximum days logged.
To specify purge time for QoE and CDR data
For the QoE database, change the WMI setting for the PurgeJobStartTime property in the MSFT_SIPQoESetting class.
For the CDR database, change the WMI setting for the PurgeTime property in the MSFT_SIPCDRServiceSetting class.