0

I Have a Sql Server 2014 Stored Procedure (SearchArticleByNumber) that I'm using for searching data and which works fine until Job schedule starts which job executes additional (five) stored procedures which inserts, update or delete data from tables that I'm using for searching data with SearchArticleByNumber procedure...

I can see in Sql Server Activity Monitor that exec of SearchArticleByNumber is blocked by process which correspondent with execution of Sql Server - Job...

When Job finish or I manually kill the process then everything is normal again...

Can some one help me how to resolve this issue...

Thank You in advance...

TheGameiswar
  • 27,855
  • 8
  • 56
  • 94
user3782230
  • 145
  • 1
  • 3
  • 11
  • You found what is the cause and you determined it is blocking..so you need to take next steps as well,try tuning those statements which are causing blocking ,by making them faster – TheGameiswar Apr 12 '17 at 07:41
  • Are the five procs using transactions? Perhaps you need to look at transaction isolation level for SearchArticleByNumer. – AntDC Apr 12 '17 at 07:42

0 Answers0