Killing a Running Activation Procedure

  • Hi. I was wondering if anyone knows of a way of killing a long running instance of an activation procedure. Here is the scenario:

    1. Many messages are queued on in same conversation to be processed by an Activation Procedure. The proc should take perhaps 1 second to execute.

    2. In a heavily trafficked production window we had a occurence where an Activation Proc went into a very slow, long loop.

    3. We were forced to use : select db_name(database_id),* from sys.dm_broker_activated_tasks (pick the correct task and...)

    Kill 25

    This killed all the messages queued in the conversation associated with the SPID. Anyone know of a way of ending an executing Activation Procedure with out killing all messages associated with a particular SPID?

    thanks

    Paul

Viewing 0 posts

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