Tips for finding Knowledge Articles

  • - Enter just a few key words related to your question or problem
  • - Add Key words to refine your search as necessary
  • - Do not use punctuation
  • - Search is not case sensitive
  • - Avoid non-descriptive filler words like "how", "the", "what", etc.
  • - If you do not find what you are looking for the first time,reduce the number of key words you enter and try searching again.
  • - Minimum supported Internet Explorer version is IE9
Home  >

KB-11267: Performance Issues When Opening Some Centrify Reports in SQL Server 2014

Authentication Service ,  

29 October,18 at 09:18 PM


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.


Changing the database compatibility level to 110 using the following SQL statement will help alleviate this issue:

ALTER DATABASE <database name>