Contact OLTP 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.

Parameter

Description

SQL Server Host Address

Type the SQL server host address of the Contact OLTP Database Server role in the Data Center that is used to upload (known as marking) recorded interactions and interaction metadata for short-term storage management. server. The instance name is not required.

Default Value: Value provided during the installation process.

SQL Server Port

Type the SQL server port number of the Contact OLTP Database server.

Default Value: 1433

Options:

Any number between 0 and 65535

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)

 

 

Set the total size that will be allocated to the database’s data and index Repository of transcribed interactions, which are used for analysis in Speech Analytics. files.

Default Value: 3

Options:

Minimum value of 0.001

Transaction Log Storage

Set the size that will be pre-allocated to the database’s transaction log.

Default Value: 2

Options:

Any number between 1 and 128

Tempdb Data Storage (GB)

Set the size that will be pre-allocated to the Tempdb data files, up to a maximum value of 64 GB.

Default Value: 4

Options:

Any number between 1 and 64

Tempdb Log Storage (GB)

Set the size that will be pre-allocated to the Tempdb log file. Valid values: from 1GB to 10GB.

Default Value: 2

Options:

Any number between 1 and 10

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

Contact Segments Retention Period (days)

Set the number of days the database retains the contact The entire communication experience for a customer, from beginning to end. segments.

Default Value: 5

Options:

Any number between 1 and 50000

After a contact segment is copied to the Contact Database Server role in the Data Center that includes long-term interactions. The Contact Database is optimized for searching operations, and interactions are inserted and updated in bulk operations., the segment is no longer retained in the Contact OLTP Database.

Contact Segments Retention Quantity (millions)

Set the number of contact segments the database retains.

Default Value: Clear

Options:

Any number between 0.000001 and 2000

Parameter

Description

Default Timeout (seconds)

Set the interval in seconds after which query processing times out.

Default Value: 30

Related topics 

Contact OLTP Database Server Role and Associations

Contact OLTP Database Server Role Associations