Help reading wait resource

• mngong

  SSCertifiable

  Points: 6167

  More actions

  July 17, 2006 at 8:33 am

  #171596

  I am looking at process info and consistently have a specific value for wait resource

  TAB:7:124287478

  Could this lead me to a specific table and a specific row or page may be or better still how is  this  interpreted

  Thanks a lot

   

• rsharma

  SSCarpal Tunnel

  Points: 4865

  More actions

  July 17, 2006 at 8:59 am

  #649579

  There is a lot of good information regarding waitresource on this site - you can search for it, here is one URL from a previous discussion on the same topic :

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=16430

   

• mngong

  SSCertifiable

  Points: 6167

  More actions

  July 17, 2006 at 9:54 am

  #649599

  Thanks for your responses.I was checking other sources but sometimes this forum is pretty reliable.

  The culprit is sp_script_reconciliation_insproc

  seems to be a supplied sp but

  Can anyone give a reason why this would be blocking an application from running and what can be done to alleviate blocking by sp_script_reconciliation_insproc

  Thanks again for your quick responses