Home Forums SQL Server 7,2000 Performance Tuning SP_PREPEXEC and SP_UNPREPARE blocking RE: SP_PREPEXEC and SP_UNPREPARE blocking

  • August 5, 2009 at 6:34 am

    #1034723

    Eswin (7/17/2009)

    Hi Expertz

    These procedures are blocking other processes.

    Lock created is "LOCK_M_S".

    In Most case the blocking is started from the Host_A which at that moment is exec "SP_UNPREPARE" and the other hosts who are being blocked are is exec "SP_PREPEXEC" as shown by Activity Monitor.

    Can give me any suggestion what could have caused this.

    What is a possible solution for avoiding these blocks

    In MOST cases, when is occuring other times? How long does the blocking last?