search cancel

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

book

Article ID: 91935

calendar_today

Updated On:

Products

CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction



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

Environment

CA Service Management 17.1
Insights Datamart

Resolution

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