We have recently upgraded our SQL Server Database from SQL 2005 to SQL 2014. We are experiencing slowness in both SSMS and application as well while executing a SP in SQL 2014. After checking through the sql profiler. This is the difference.
Source Server : SQL 2005 JDBC VERSION : 4.1 Source Data type : Big Decimal Conversion on DB side : It is converted as Numeric (Checked through sql profiler) Execution Time : 1 Second
The below target is the server we have upgraded from 2005.
Target Server : SQL 2014 JDBC VERSION : 6.2 SOURCE Datatype : Big Decimal Conversion on DB Side : It is converted as Decimal Execution Time : 25 Seconds.
Any idea what I can do to fix this?