29 October,18 at 09:18 PM
Problem:
The performance for opening some Centrify reports on SQL Server 2014 is not good enough if its database compatibility level is 120.
Root cause:
For the same SQL query, SQL Server 2014 cardinality estimator (CE) uses different execution plans if the database compatibility level is 120.
Solution:
Changing the database compatibility level to 110 using the following SQL statement will help alleviate this issue:
ALTER DATABASE <database name>
SET COMPATIBILITY_LEVEL = 110