Why is SQL Server Enterprise Edition the only supported SQL Server version for Insights Datamart?

Document ID : KB000091935
Last Modified Date : 20/06/2018
Show Technical Document Details
Question:
Why is SQL Server Enterprise Edition the only supported SQL Server version for Insights Datamart?
Environment:
CA Service Management 17.1
Insights Datamart
Answer:
The CA Service Management 17.1 Supportability Matrix shows that only SQL Server Enterprise Edtiion (2012, 2014 and 2016) is the only SQL Server version supported/certified with Insights Datamart.

The technical reason for this is that there are some online index operations that the Insight Datamart jobs depend on (Pentaho API) that SQL Server Standard Edition does not support.  

Since the online index operations can only be successfully executed with SQL Server Enterprise Edition, therefore SQL Server Enterprise Edition (2012, 2014 and 2016) is the only SQL version supported/certified with Insights Datamart.
Additional Information:
https://docops.ca.com/ca-service-management/17-1/en/ca-service-management-17-1-release-notes/supportability-matrix#SupportabilityMatrix-Database

The information in this article has been included in our product documentation. You can find further details here:

https://docops.ca.com/ca-service-management/17-1/en/troubleshooting/troubleshooting-insights/why-is-the-microsoft-sql-server-enterprise-edition-the-only-supported-sql-server-version-for-insights-datamart