Select your SQL Server

Owned by Kiss, Mate
May 08, 2019

The system uses a standard Microsoft SQL Server database to store the system configuration parameters for each server and the conversation metadata (CDR) for each conversation.

We recommend to review this topic and select your SQL Server edition based on your requirements.

For more information on the differences of the SQL Server editions, see https://docs.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2017

Supported SQL Server versions:

  • SQL Server 2012
  • SQL Server 2014
  • SQL Server 2016
  • SQL Server 2017

Scalability

Conversations stored in the system at any momentRecommended SQL Server edition
less than 1.000.000 conversations and instant messagesExpress Edition
more than 1.000.000 conversations and instant messages

Standard or Enterprise Edition

In very large deployments, partitioning has to be enabled, which is only available in Enterprise Editions or Standard Edition of SQL Server 2016 SP1 or later

If you have configured Data management policies in your system that automatically remove calls, you can plan for the maximum amount of calls that you store in the system at any moment, and not the total amount of conversations you have recorded.

Resiliency

Different SQL Server editions, support different resiliency features. Choose the editions, which is most suitable for the resiliency requirements of the deployment. For highly available deployments, we recommend using Always On availability groups which are available in Enterprise and Standard (basic version) edition only.

FeatureEnterpriseStandardExpress
Database mirroringYes

Yes

Full safety only

Witness only
Always On failover cluster instances

Yes

Number of nodes is the operating system maximum

Yes

Support for 2 nodes

No
Always On availability groups

Yes

Up to 8 secondary replicas, including 2 synchronous secondary replicas

Yes, basic only

Requires SQL Server 2016 or later

No