deploying to server slows down the package

Question

deploying to server slows down the package

darth vodka

SSCrazy

Points: 2367
More actions
February 10, 2009 at 3:02 am

#206367

hi
i have a daily package that runs 15 packages in parallel (and one before and one after the 15)
it runs fine when i run it in BIDS, taking 40 minutes
when i run it on server, it runs one of the parallel tasks (i know this as i have a little log table) and then seems to hang for three hours (it could hang for more, but i kill it)
has anyone got anything i can try/test that would make a difference between running a package on BIDS and on the server

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Tim Mitchell SSCoach Points: 15681 More actions · Answer 1

When you run it from BIDS, are you running against the same database? Your post wasn't clear if you are using a separate testing environment. If the deployment is going from a test environment to a production environment, you may have an issue with resource contention in production. Your package may be blocked by another process.

More information about monitoring blocking can be found at http://support.microsoft.com/kb/271509.

hth,

Tim

Tim Mitchell, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | Tyleris.com
ETL Best Practices

darth vodka SSCrazy Points: 2367 More actions · Answer 2

hi Tim

thanks for that...but i suspect it isn't blocking as it's the same server from BIDS and deployment (although i'm by no means a blocking expert!)

i can't see anything in the system tables to suggest blocking either

annoyingly, everything looks to be working ok in series in a job, but the master package with all of them in parallel doesn't run so well

hmm

worse case scenarion i'll have lots of jobs running in parallel

Tim Mitchell SSCoach Points: 15681 More actions · Answer 3

OK, if I understand correctly, it runs fine when you run the packages serially (one after another) but it's not completing when they run in parallel. If that is the case, you've almost certainly got issues with resource contention and likely a lot of disk I/O.

hth,

Tim

Tim Mitchell, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | Tyleris.com
ETL Best Practices

darth vodka SSCrazy Points: 2367 More actions · Answer 4

ah, ok

seems strange it would run ok in BIDS though

i'll chop it up and see what happens

many thanks