did you check store procedure execution time on the source server i-e how much time it takes to execute ?