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?
Blocking? There is an option on Adam Machanic's sp_WhoIsActive which will show if you are being blocked.
If it is just "slow", rather than "blocked", then it may be stale Statistics or Indexes that need rebuilding. Or both ...
during update in DECLARE Table