Skip to end of metadata
Go to start of metadata

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-2016

Scalability

Conversations stored in the system at any momentRecommended SQL Server edition
less than 1.000.000 calls and instant messagesExpress Edition
more than 1.000.000 calls and instant messagesStandard or Enterprise Edition

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 calls 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 edition only.

FeatureEnterpriseStandardExpress
Database mirroringYesYes

Full safety only
Witness only
Always On failover cluster instancesYes

Number of nodes is the operating system maximum
Yes

Support for 2 nodes
No
Always On availability groupsYes

Up to 8 secondary replicas, including 2 synchronous secondary replicas
NoNo
  • No labels