sql server - How to diagnose SSIS packages locking each-others? -


i have several ssis packages doing few queries , inserting results in new tables. ssis packages triggered different parameters values service broker queues, max 10 simultaneous operations. (ex : 2 packages, each of being called 5 times 5 different values of parameter)

when operated separately took few seconds, when called service broker, after few ran successfull, start slowing down, totally stuck.

there no concurrent read , inserts, packages read same tables (with nolocks everywhere) insert new data in new tables created packages. each package write in own destination table on none other package try read nor write.

what should consider modifying in ssis or investigate in ssms and/or profiler diagnose , solve issue ? i'm not used track down locks...

thanks in advance,

  1. i recommend using sp_whoisactive sure nothing blocking.
  2. i recommend monitoring resources (io, network, ram) on target/destination/etl server(s)
  3. try running different scenarios such 2 packages , 2 simultaneous operations etc.

Comments

Popular posts from this blog

php - Vagrant up error - Uncaught Reflection Exception: Class DOMDocument does not exist -

vue.js - Create hooks for automated testing -

Add new key value to json node in java -