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
e4d4
SSCertifiable
Points: 5777
More actions
September 1, 2015 at 1:55 pm
#1823799
Did you updated statistics? How was set on the old server max degree of parallelism and cost threshold for parallelism. What are waiting stats? You could try using sp_AskBrent which will check many things http://www.brentozar.com/askbrent/[/url]