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-8464: Report Services Running Slow with SQL Server 2014

Authentication Service ,  

31 March,17 at 06:25 PM

Applies to: Centrify DirectControl Report Services with SQL Server 2014.

Reports are running slow in SQL Server 2014 or above (compared to previous SQL Server editions) and sometimes fail to be finished with error code 500.

Microsoft re-designed cardinality estimator in SQL Server 2014 to improve the quality of query plans. ( But we found that the SQL Server received a worse query plan with the new cardinality estimator. This greatly reduced the query performance.

In this case, you can
fall back to the old version cardinality estimator on the database level or the query level.
No resolution as this is a Microsoft limitation.

Centrify Corporation does not take any responsibility for the content or availability of the links and it was provided as a courtesy.  Customers should contact the vendor if there are any further questions