Shared Session ID from multiple hosts? Is this possible?

• Bob Fazio

  SSChampion

  Points: 10794

  More actions

  October 31, 2011 at 9:06 am

  #390726

  2011-10-31 02:43:29.68 spid58 Error: 10982, Severity: 16, State: 1.

  2011-10-31 02:43:29.68 spid58 Failed to run resource governor classifier user-defined function. See previous errors in SQL Server error log from session ID 58 for details. Classifier elapsed time: 0 ms.

  It is then followed by ...

  The request failed to run because the batch is aborted, this can be caused by abort signal sent from client, or another request is running in the same session, which makes the session busy.

  I have seen multiple hosts on the same SPID. My question is this? Does anyone know of documentation that details how connection pooling creates/releases sessions?

  I am trying to find out how what appears to be two (or more) hosts sharing a spid. As I understand spids, this isn't possible.

  Is this just telling me that the spid was released and is being re-allocated to the pool?

• Igor Micev

  SSC-Dedicated

  Points: 33110

  More actions

  February 5, 2016 at 8:32 am

  #1856878

  Batch is old 4+ years. Nobody have responded. I came to the same problem, not enough clear to me.

  Igor Micev,My blog: www.igormicev.com