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 |