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

Home >

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

Product:

Centrify DirectControl ,

Published:

31 March,17 at 06:25 PM

Rating:

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.

Database level: https://msdn.microsoft.com/en-us/library/bb510680.aspx
Query level: Use QUERYTRACEON 9481 https://support.microsoft.com/en-us/kb/2801413

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