Which edition of Microsoft SQL Server should I use?
When deciding which edition of Microsoft SQL Server to use with Venafi Trust Protection Platform—Microsoft SQL Server Enterprise or Standard Edition—carefully review the following table:
Use Microsoft SQL Server Enterprise Edition (Recommended) if you want |
Use Microsoft SQL Server Standard Edition if you want |
---|---|
Automated database maintenance | Manual database maintenance |
Automated indexing operations TIP The performance of index operations online is a major benefit of using Microsoft SQL Enterprise Edition. Enterprise Edition allows Venafi Platform to perform these maintenance tasks automatically and in the background with the service remaining active. |
Manual indexing operations IMPORTANT Microsoft SQL Server Standard Edition only lets you rebuild and reorganize indexes—a recommended weekly task performed manually—and requires that you take your database server offline, which results in an outage of Venafi Platform. |
Support for all three on-premise levels:
For more information about levels, see Locally Hosted MSSQL Requirements. |
Support for two of the three available levels:
For more information about levels, see Locally Hosted MSSQL Requirements. |