SQL 2014 SSIS Performance Slow

Question

Hi,

We migrated a few ssis package from SQL 2008 R2 to SQL 2014. Backup the database from SQL 2008 R2 to SQL 2014, converted the ssis package file to the compatible version of the ssis package for SQL 2014. 

Previously, in ssis package for SQL 2008 R2 took around 6 hours processing time but after migrated it took around 9 hours to finished the same package. Only one of the ssis package job took longer time to process. The others ssis package took the same time as the SQL 2008 R2 version.

Any steps / configurations that need to perform? Any possibilities that make this particular ssis package on the slow performance?

Thanks.

Answer 1

1) See database compatibility version to 120

2) index Manage depend on reorganize or rebuild index.

3) updates statistics.

4) what is memory assign in mssql ?

5) check blocking in server.

6)Check the logical and physical integrity of all the objects in the upgraded databases:

DBCC CHECKDB([myDatabase]) WITH NO_INFOMSGS

1. where [mydatabase] is the database to  run the integrity checks
   NO_INFOMSGS option  suppresses all informational messages. 
   
   If If DBCC printed any error messages you must fix them so that your database will work correctly.