What your trace files are telling you?
How do you know process is hanging as opposed to being building indexes or validating constraints?