SQLTeam.com | Weblogs | Forums

Stop Procedure when Exec


#1

I have Procedure PrFixe
this procedure change value in table "Stock"
this table contain on 11000 record
when record no 10980 the procedure is pause (sleep) no cancel
why?


#2

Blocking? There is an option on Adam Machanic's sp_WhoIsActive which will show if you are being blocked.

http://whoisactive.com/

If it is just "slow", rather than "blocked", then it may be stale Statistics or Indexes that need rebuilding. Or both ...


#3

during update in DECLARE Table