none
High Number of Tasks Aborted/Sec?

    Question

  • Hello,

    I recently setup Service Broker - Internal Activation. I ran built-in SSMS "Service Broker Statistics" reports and saw this;

    Store Procedures Invoked/sec : 184

    Tasks Aborted/sec :184

    Tasks Running: 0

    Tasks Started/sec: 184

    I used "SET XACT_ABORT ON" at the top of the activation sproc. Do you think all transactions through  the activation sproc are rolling back?

    Thanks,

    Kuzey


    Monday, July 14, 2014 5:24 PM