Centrify

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

Authentication Service ,  

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.

    Related Articles

     articleKB-7096: Unable to install SQL Server 2012 / 2014 using Report Services configuration wizard on Windows 2008 articleKB-4589: Error codes when installing SQL server bundled with Centrify DirectAudit and Centrify Reporting Services articleKB-7555: Unable to login as root after upgrade to Centrify Suite 2016 (CDC 5.3.0) articleKB-7066: Configuring Centrify Report Services for Large Active Directory Environments articleKB-6056: How to report the group policy settings that are in effect for the local computer? articleKB-6073: How to join the Linux/Unix Centrify Server to Active Directory with specific Computer Role? articleKB-6041: How to show current license type in use by adclient articleKB-6038: How to specify the license type to use when joining the server to AD using adjoin? articleKB-8065: SQL Server Reporting Services Service Start Timeout on Windows 2008R2