Post reply

Help reading wait resource

  • 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

     

  • 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

     

  • 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

     

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply