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  >
article

KB-8464: Report Services Running Slow with SQL Server 2014

Centrify DirectControl ,  

31 March,17 at 06:25 PM

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

Problem:
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.

Cause:  
Microsoft re-designed cardinality estimator in SQL Server 2014 to improve the quality of query plans. (https://msdn.microsoft.com/en-us/library/dn600374(v=sql.120).aspx). But we found that the SQL Server received a worse query plan with the new cardinality estimator. This greatly reduced the query performance.

Workaround:
In this case, you can
fall back to the old version cardinality estimator on the database level or the query level.
Resolution:
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

 




 

    Still have questions? Click here to log a technical support case, or collaborate with your peers in Centrify's Online Community.