Home Forums SQL Server 2014 Administration - SQL Server 2014 Upgraded from 2008 to 2014, queries slowed to a crawl RE: Upgraded from 2008 to 2014, queries slowed to a crawl
bwhiteside
Valued Member
Points: 54
More actions
September 3, 2015 at 9:02 am
#1824333
Grant, I think you called it. It looks like the new cardinality estimator appears to be causing our queries to run much slower. We changed the compatibility mode to 2012 and that fixed it.