Appendix B: QueuePeriodStatisticsInterval Server Parameter

Appendix B: QueuePeriodStatisticsInterval Server Parameter

The installation sets the Queue Period Statistics (QPS) interval in Interaction Administrator using the server parameter, QueuePeriodStatisticsInterval. The default value of the parameter is 1800 seconds (30 minutes) at the time of installation, but you can change it. You can set the value to anything greater than 300 seconds. There is a very high upper limit (max value = max signed integer, in case you were wondering), but the practical range for most sites is from 900 to 3600 seconds. The default CIC reports generally expect a one-hour or less interval setting but the reports will work with any setting. If you set an interval that is not an even part of an hour it leads to odd-looking statistics, but that is not necessarily wrong, it just may be hard for you to read the statistics. You can set a one-day interval setting, but this is unlikely to give you meaningful statistics on a busy IC server.

If you change this parameter it will affect the number of records stored in the SQL tables, therefore, it will affect the size of the database.

If you change this parameter it will not affect records CIC has already stored in the database. If you run any QPS reports using a date/time range that includes a date/time in which a different setting was in effect, the report will reflect the setting in effect when the records were written to the database.

The QPS process of writing statistics to the SQL tables may cause additional processing load on your server. If you change the parameter it will affect how often the QPS processing load occurs and you should considered this if you have a heavily-used server that is near its maximum processor capacity.

In some cases, the interval start times might not be exactly on the hour. Stopping and starting CIC usually causes this. You might see these odd interval start times in the reports.

If you change the value of the parameter, you do not have to reboot the server for this parameter change to take effect. CIC processes the change dynamically and it takes effect immediately. The system reschedules the current end of the interval with the new value.

Although it often appears that way, the setting is not necessarily always relative to the hour. The setting is scheduled from midnight. Therefore, as long as 60 is divisible by the value without a remainder, the hour is one of the times. However, nothing restricts it to this behavior.

If you change the setting to run every 5 minutes, then QPS will run at the next 5-minute period. For example, if you change the setting to 5 minutes at 12:01, then QPS will run at 12:05. If you change it to one hour at 12:30 PM, then it will run at 1:00 PM.