November 2, 2017 at 6:26 am
Hi All
This is not about the code we have written in our package. We are assigned a task to migrate SQL server 2008 SSIS package to 2014
and move our database to 2014 server. I am doing the package run time testing running my package locally but this is taking time to finish
Here is a two configurations and time difference in both for the same package, (Package is migrated in 2014 and running locally)
Case 1-
Source Database Version - 2008R2
SSSI package Version - 2014
Destination Database Version - 2008R2
Run Time - 3 hrs
Case 2 -
Source Database Version - 2008R2
SSSI package Version - 2014
Destination Database Version - 2014
Run Time - 5 hrs
Can you please advise me why this takes time when package and database is in 2014 ,pulling database from 2008R2 database?
Whereas it does take less time if source and destination databases are in 2008R2 version but SSIS version remain same (2014)
November 2, 2017 at 6:35 am
Not enough information to help you here. Some possibilities:
(1) Differences in the data on source and/or destination
(2) Differences in hardware (processors, memory and so on)
(3) Differences in configuration (disk layout, maxdop and many other possible things)
(4) Parameter sniffing leading to inappropriate execution plan(s)
John
November 2, 2017 at 7:04 am
John Mitchell-245523 - Thursday, November 2, 2017 6:35 AMNot enough information to help you here. Some possibilities:(1) Differences in the data on source and/or destination
(2) Differences in hardware (processors, memory and so on)
(3) Differences in configuration (disk layout, maxdop and many other possible things)
(4) Parameter sniffing leading to inappropriate execution plan(s)John
A couple more possibilities:
(5) If data is being moved from server to server, network bandwidth may be throttling performance.
(6) If any queries are running on the target server, the new 2014 cardinality estimator may be choosing a poorer execution plan than in 2008.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply