Framework Database Server Role

If the database server role Entity that contains a logical, predefined set of components (system software or certified third-party software) deployed in the Data Center and Site Zones that provide specific functionality for the system. is used with remote SQL Servers (SQL Farms/Clusters), do not configure the TempDB data storage parameter.

The customer owns the SQL server and its configuration, including TempDB data storage parameter values.

SQL Server Details

Parameter	Description
SQL Server Name	Type the SQL server host address used as the default for all databases. For SQL cluster or SQL farm the server name must be the cluster name. The SQL instance name is not required.
Port	The TCP/IP static port from where the SQL Server hosting the database is listening. Default: 1433.

Parameter

Description

SQL Server Name

Type the SQL server host address used as the default for all databases.

For SQL cluster or SQL farm the server name must be the cluster name.

The SQL instance name is not required.

Port

The TCP/IP static port from where the SQL Server hosting the database is listening.

Default: 1433.

Database Sizing

These values are customized for each customer and documented in the "EM Config" tab of the Customer Furnished Equipment (CFE) Guide prepared for the customer site. If this tab is hidden in your CFE Guide, unhide it.

Parameter	Description
Database Storage Allocation (GB)	The total size in GB that is pre-allocated for the database's data and index Repository of transcribed interactions, which are used for analysis in Speech Analytics. files. Default: 8
Transaction Log Storage (GB)	The number refers to the GB that will be pre-allocated for the database's transaction log. Default: 2
TempDB Data Storage (GB)	The number refers to the GB that will be pre-allocated for SQL Server's TEMPDB data files, up to a maximum value of 64 GB. Default: 4
TempDB Log Storage	The number refers to the GB that will be pre-allocated to SQL Server's TEMPDB log file. Valid values are from 1GB to 10GB. Default: 2

Alert Thresholds

Parameter	Description
Coaching Application that provides a method of directing, instructing and training a person or group of people, with the aim of achieving a set goal or developing specific skills. Alert Threshold (GB)	If the amount (in GB) of coaching data exceeds the amount specified in this setting, an alarm is triggered. The alarm indicates that coaching data is over the threshold. The alarm is triggered once each minute. To address and acknowledge the alarm, you must either purge the data below the threshold or raise the threshold above the current size of the data. The pre-allocated storage for coaching is 20 GB, It is recommended that the value of this parameter not exceed 20 GB. Default: 10 The minimum entry is 1 and the maximum entry is 500. If an alarm is triggered indicating that coaching data is over the threshold, you can purge the coaching data by shortening the amount of time coaching data is retained. To purge coaching data, shorten the time period specified in the Coaching Area setting.

Parameter

Description

Coaching Application that provides a method of directing, instructing and training a person or group of people, with the aim of achieving a set goal or developing specific skills. Alert Threshold (GB)

If the amount (in GB) of coaching data exceeds the amount specified in this setting, an alarm is triggered. The alarm indicates that coaching data is over the threshold. The alarm is triggered once each minute. To address and acknowledge the alarm, you must either purge the data below the threshold or raise the threshold above the current size of the data.

The pre-allocated storage for coaching is 20 GB, It is recommended that the value of this parameter not exceed 20 GB.

Default: 10 The minimum entry is 1 and the maximum entry is 500.

If an alarm is triggered indicating that coaching data is over the threshold, you can purge the coaching data by shortening the amount of time coaching data is retained. To purge coaching data, shorten the time period specified in the Coaching Area setting.

Purging Data

If you have never purged the database, and you must purge a large amount of data to return the database to an acceptable data retention level, you must take the system out of production during a maintenance period, and purge the database then. In this scenario, if you do not take the system out of production, the purge process cannot purge the data fast enough to bring the data retention down to an acceptable level.

Parameter	Description
Purging Enabled	Check box, Is the purging job enabled for this database? Default: Check box not selected.
Report Area	Specify retention period in months and rows to be deleted for tables to be purged in the Reporting area. Defaults: 12 months and 1000 rows respectively.
Timerecord Area	Specify retention period in months and rows to be deleted for tables to be purged in the Time Record area. Defaults: 24 months and 1000 rows respectively.
Schedule Area	Specify retention period in months and rows to be deleted for tables to be purged in the Schedule area, including Request Management. Defaults:24 months and 1000 rows respectively.
Queue Area	Specify retention period in months and rows to be deleted for tables to be purged in the Queue area. Defaults: 24 months and 1000 rows respectively.
Audit Compliance Area	Specify retention period in months and rows to be deleted for tables to be purged in the Audit Compliance area. Defaults:84 months and 1000 rows respectively. Note that the “Audit Compliance area” includes these modules in the AUDITTRAILENTRY table: Remote Component Contact Attribute Installation Node Data Source Business Rule
Audit Non-Compliance Area	Specify retention period in months and rows to be deleted for tables to be purged in the Audit Non-Compliance area. Defaults:18 months and 1000 rows respectively Note that the “Audit Non-Compliance area” includes all modules in the AUDITTRAILENTRY table that are not listed in the “Audit Compliance Area” description above.
VCT Events (Managed) Area	Specify retention period in months and rows to be deleted for tables to be purged in Managed VCT Events area. Defaults:6 months and 1000 rows respectively.
VCT Events (Unmanaged) Area	Specify retention period in months and rows to be deleted for tables to be purged in the Audit Compliance area. Defaults: 0 months (all records deleted) and 1000 rows respectively.
My Notifications Suite-wide feature that provides a personal, read-only Inbox for notifications sent to users by other employees. Area	Specify retention period in months and rows to be deleted for tables to be purged in the My Notifications area. Defaults: 6 months (all records deleted) and 1000 rows respectively.
Coaching Area	Specify retention period in months and rows to be deleted for tables to be purged in the Coaching Purge area. Defaults: 24 months (all records deleted) and 1000 rows respectively.
Notify Rule Log Area	Specify retention period in months and rows to be deleted for tables to be purged in the Notify Rule Log area. Defaults: 1 month (all records deleted) and 5000 rows respectively.

Jobs

Parameter	Description
Kill Blockers Enabled	Enable this setting only under the direction of an authorized support representative. Default: Disabled

Parameter

Description

Kill Blockers Enabled

Enable this setting only under the direction of an authorized support representative.

Default: Disabled