hey you can use sql profiler for this.

then u will come to know that which thread taking more time to execute.

after that check with developer and do needful changes.