SQL Query performing slow on SQL Server 2016 SP1 than SQL Server 2012 SP3

by user3807537   Last Updated November 15, 2017 00:06 AM

I have a SQL query which runs under 1 minute on SQL Server 2012 SP3 but run over 2 hrs on SQL Server 2016 SP1.on Server side both server runs on identical hardware which is virtual server (VMWare),2 sockets 16 vCPUs with 170GB RAM allocated to SQL Server.The SQL2012 server runs on EMC SAN and SQL2016 runs on Flash drive.The execution plan on both server are different.

Can you please help to troubleshoot this performance issue.

Thanks in advance.

Tags : performance

Related Questions

Lower performance on newest servers

Updated August 29, 2017 14:06 PM

poor and/or unreliable InnoDB performance

Updated June 21, 2017 04:06 AM

How MySQL use the InnoDB Buffer?

Updated July 13, 2018 05:06 AM