Select your SQL Server
- Kiss, Mate
- Gabor Moczar
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 moment | Recommended SQL Server edition |
|---|---|
| less than 1.000.000 conversations and instant messages | Express 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.
| Feature | Enterprise | Standard | Express |
|---|---|---|---|
| Database mirroring | Yes | 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 |